Tom Lane wrote:
"Jens-Wolfhard Schicke" <[EMAIL PROTECTED]> writes:
I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
looked like this:
BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
rows=0 loops=1)
Can we do better than just sayi
"Jens-Wolfhard Schicke" <[EMAIL PROTECTED]> writes:
> I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
> looked like this:
> BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
> rows=0 loops=1)
BitmapOr and BitmapAnd don't attempt to count their re
Jens-Wolfhard Schicke wrote:
I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
looked like this:
BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
rows=0 loops=1)
Yet, the last subnode was:
Bitmap Index Scan on location_gs (cost=0.00..8.14 row
The following bug has been logged online:
Bug reference: 3225
Logged by: Jens-Wolfhard Schicke
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Linux
Description:BitmapOr plan node does not show currect row count
Details:
I an explain analy