Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about Bitmap Heap Scan/BitmapAnd - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: Question about Bitmap Heap Scan/BitmapAnd
Date
Msg-id 1d4e0c10702151009n54772ac0rece99a7af35f3399@mail.gmail.com
Whole thread Raw
In response to Re: Question about Bitmap Heap Scan/BitmapAnd  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question about Bitmap Heap Scan/BitmapAnd  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-performance
Tree view 
On 2/15/07, Tom Lane <tgl@sss.pgh.pa.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)?

Thanks.

--
Guillaume

pgsql-performance by date:

Previous
From: Mike Gargano
Date:
Subject: strange issue for certain queries
Next
From: "Guillaume Smet"
Date:
Subject: Re: Question about Bitmap Heap Scan/BitmapAnd