Re: Question about Bitmap Heap Scan/BitmapAnd

Поиск
Список
Период
Сортировка
От Guillaume Smet
Тема Re: Question about Bitmap Heap Scan/BitmapAnd
Дата
Msg-id 1d4e0c10702151009n54772ac0rece99a7af35f3399@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about Bitmap Heap Scan/BitmapAnd  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Question about Bitmap Heap Scan/BitmapAnd  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Mike Gargano
Дата:
Сообщение: strange issue for certain queries
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: Question about Bitmap Heap Scan/BitmapAnd