Re: Queryplan within FTS/GIN index -search. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Queryplan within FTS/GIN index -search.
Date
Msg-id 11587.1257207482@sss.pgh.pa.us
Whole thread Raw
In response to Re: Queryplan within FTS/GIN index -search.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Queryplan within FTS/GIN index -search.
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Queryplan within FTS/GIN index -search.
Next
From: "Kevin Grittner"
Date:
Subject: Re: Queryplan within FTS/GIN index -search.