Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0
Дата
Msg-id 46B0D8D5.2010703@enterprisedb.com
обсуждение исходный текст
Ответ на EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0  (Joseph S <jks@selectacast.net>)
Список pgsql-bugs
Joseph S wrote:
> From this snipped you can see that the Bitmap Heap scan returns 123
> rows, but the BitmapAnd under it returns 0.  I would find it useful to
> determine how many rows were thrown out by the recheck.

Yeah, it would be nice. Unfortunately there's some problems with that,
see previous discussion on that:
http://archives.postgresql.org/pgsql-bugs/2007-04/msg00029.php

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Justin Hibbits"
Дата:
Сообщение: BUG #3503: Benchmark scripts broken
Следующее
От: Decibel!
Дата:
Сообщение: Re: Oddities with ANYARRAY