Tom Lane wrote:
> Jesper Krogh <jesper(at)krogh(dot)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.
least_common_frequence / 2
Which also gives 33 in my situation.
In response to
pgsql-performance by date
|Next:||From: Jesper Krogh||Date: 2009-10-23 20:32:53|
|Subject: Re: Full text search - query plan? PG 8.4.1|
|Previous:||From: Jeff Davis||Date: 2009-10-23 19:22:03|
|Subject: Re: Queryplan within FTS/GIN index -search.|