Re: Queryplan within FTS/GIN index -search.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Queryplan within FTS/GIN index -search.
Дата
Msg-id 11587.1257207482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Queryplan within FTS/GIN index -search.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Queryplan within FTS/GIN index -search.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Any sane text search application is going to try to filter out
>> common words as stopwords; it's only the failure to do that that's
>> making this run slow.

> I'd rather have the index used for the selective test, and apply the
> remaining tests to the rows retrieved from the heap.

Uh, that was exactly my point.  Indexing common words is a waste.

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Queryplan within FTS/GIN index -search.
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Queryplan within FTS/GIN index -search.