On 2/15/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I think that the
> answer is probably "because the index is lossy for this operator,
> so it has to be checked even if the bitmap didn't become lossy".
> You'd have to check the GIST opclass definition to be sure.
Any idea on what I have to look for (if it's of any interest for
anyone, otherwise, I can live with your answer)?
In response to
pgsql-performance by date
|Next:||From: Guillaume Smet||Date: 2007-02-16 00:32:42|
|Subject: Re: Question about Bitmap Heap Scan/BitmapAnd|
|Previous:||From: philippe||Date: 2007-02-15 17:10:45|
|Subject: Re: Slow query with 'or' clause|