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

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема Re: Calculating selectivity for the query-planner on ts_vector colums.
Дата
Msg-id 4AE20429.4020202@krogh.cc
обсуждение исходный текст
Ответ на Re: Calculating selectivity for the query-planner on ts_vector colums.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Queryplan within FTS/GIN index -search.
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Full text search - query plan? PG 8.4.1