Re: [BUGS] BUG #3225: BitmapOr plan node does not show currect row count

2007-04-13 Thread Russell Smith
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

Re: [BUGS] BUG #3225: BitmapOr plan node does not show currect row count

2007-04-13 Thread Tom Lane
"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

Re: [BUGS] BUG #3225: BitmapOr plan node does not show currect row count

2007-04-13 Thread Heikki Linnakangas
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

[BUGS] BUG #3225: BitmapOr plan node does not show currect row count

2007-04-13 Thread Jens-Wolfhard Schicke
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