Re: Calculating selectivity for the query-planner on ts_vector colums. - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: Calculating selectivity for the query-planner on ts_vector colums.
Date
Msg-id 4AE20429.4020202@krogh.cc
Whole thread Raw
In response to Re: Calculating selectivity for the query-planner on ts_vector colums.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> Jesper Krogh <jesper@krogh.cc> writes:
>> It seems to me that the row estimates on a ts_vector search is a bit on
>> the low side for terms that is not in th MCV-list in pg_stats:
>
> tsvector has its own selectivity estimator that's not like plain scalar
> equality.  Look into src/backend/tsearch/ts_selfuncs.c if you want to
> see the rules.

Thanks.

least_common_frequence / 2
Which also gives 33 in my situation.

--
Jesper




pgsql-performance by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Queryplan within FTS/GIN index -search.
Next
From: Jesper Krogh
Date:
Subject: Re: Full text search - query plan? PG 8.4.1