Re: Queryplan within FTS/GIN index -search.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: jesper(at)krogh(dot)cc, pgsql-performance(at)postgresql(dot)org, oleg(at)sai(dot)msu(dot)su, teodor(at)sigaev(dot)ru
Subject: Re: Queryplan within FTS/GIN index -search.
Date: 2009-11-03 00:18:02
Message-ID: 11587.1257207482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-11-03 14:56:53 Re: Queryplan within FTS/GIN index -search.
Previous Message Kevin Grittner 2009-11-02 22:06:00 Re: Queryplan within FTS/GIN index -search.