Re: Queryplan within FTS/GIN index -search.

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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 17:03:43
Message-ID: 4AF00E0F020000250002C1BB@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> I'm wondering if anyone has ever confirmed that probing for the more
> frequent term through the index is *ever* a win, versus using the
> index for the most common of the top level AND conditions and doing
> the rest on recheck.

s/most/least/

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2009-11-03 17:23:33 Re: Problem with database performance, Debian 4gb ram ?
Previous Message Kevin Grittner 2009-11-03 16:49:31 Re: Queryplan within FTS/GIN index -search.