Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT
Дата
Msg-id 26975.1256132273@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-general
Sergey Konoplev <gray.ru@gmail.com> writes:
> Is there a way (or workaround) to make it use i_test_table__created
> for frequent and i_test_table__tsvector_1 for sparse words?

You would need to update to 8.4 for that --- 8.3 does not have any
support for statistics estimation for @@.

(Whether 8.4 would get it right is a different question, but at least
it has a chance.  8.3 has none.)

            regards, tom lane

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

Предыдущее
От: Sam Jas
Дата:
Сообщение: Re: How to use Logical Operators in Fulltext Search?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to use Logical Operators in Fulltext Search?