Re: [HACKERS] index-only count(*) for indexes supporting bitmap scans

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: [HACKERS] index-only count(*) for indexes supporting bitmap scans
Дата
Msg-id 87ziflvryn.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на [HACKERS] index-only count(*) for indexes supporting bitmap scans  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
Ответы Re: [HACKERS] index-only count(*) for indexes supporting bitmap scans
Список pgsql-hackers
>>>>> "Alexander" == Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru> writes:
Alexander> Structurally, the patch consists of two major parts: aAlexander> specialized executor node

Why?

It strikes me that the significant fact here is not that we're doing
count(*), but that we don't need any columns from the bitmap heap scan
result.  Rather than creating a whole new node, can't the existing
bitmap heapscan be taught to skip fetching the actual table page in
cases where it's all-visible, not lossy, and no columns are needed?

(this would also have the advantage of getting parallelism for free)

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] pg_dump emits ALTER TABLE ONLY partitioned_table
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [HACKERS] [PATCH v1] Add and report the new "in_hot_standby" GUC pseudo-variable.