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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3225: BitmapOr plan node does not show currect row count
Дата
Msg-id 19389.1176477250@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3225: BitmapOr plan node does not show currect row count  ("Jens-Wolfhard Schicke" <j.schicke@asco.de>)
Ответы Re: BUG #3225: BitmapOr plan node does not show currect row count  (Russell Smith <mr-russ@pws.com.au>)
Список pgsql-bugs
"Jens-Wolfhard Schicke" <j.schicke@asco.de> 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 result rows --- doing
so would involve an extra scan over the bitmap, and what would you do
for lossy pages?

            regards, tom lane

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #3225: BitmapOr plan node does not show currect row count
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification