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

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

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Calculating selectivity for the query-planner on ts_vector colums.
Следующее
От: Kevin Buckham
Дата:
Сообщение: Re: Table Clustering & Time Range Queries