Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0 - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0
Date
Msg-id 46B0D8D5.2010703@enterprisedb.com
Whole thread Raw
In response to EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0  (Joseph S <jks@selectacast.net>)
List 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 by date:

Previous
From: "Justin Hibbits"
Date:
Subject: BUG #3503: Benchmark scripts broken
Next
From: Decibel!
Date:
Subject: Re: Oddities with ANYARRAY