Re: Calculating selectivity for the query-planner on ts_vector colums.

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Calculating selectivity for the query-planner on ts_vector colums.
Date: 2009-10-23 19:29:45
Message-ID: 4AE20429.4020202@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thanks.

least_common_frequence / 2
Which also gives 33 in my situation.

--
Jesper

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2009-10-23 20:32:53 Re: Full text search - query plan? PG 8.4.1
Previous Message Jeff Davis 2009-10-23 19:22:03 Re: Queryplan within FTS/GIN index -search.