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

Поиск
Список
Период
Сортировка
От Jens-Wolfhard Schicke
Тема BUG #3225: BitmapOr plan node does not show currect row count
Дата
Msg-id 200704131231.l3DCV4jY096282@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3225: BitmapOr plan node does not show currect row count  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: BUG #3225: BitmapOr plan node does not show currect row count  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3225
Logged by:          Jens-Wolfhard Schicke
Email address:      j.schicke@asco.de
PostgreSQL version: 8.2
Operating system:   Linux
Description:        BitmapOr plan node does not show currect row count
Details:

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 rows=251 width=0) (actual
time=0.094..0.094 rows=375 loops=1)

The real rowcount of the BitmapOr is wrong.

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

Предыдущее
От: "Stefan Kaltenbrunner"
Дата:
Сообщение: BUG #3223: Testbugreport for new wwwmaster
Следующее
От: "Gabriele Bartolini"
Дата:
Сообщение: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification