Re: COUNT(*) and index-only scans

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: COUNT(*) and index-only scans
Дата
Msg-id CAM-w4HOBfxNcexc+gyhUe4LSYLeSsnPrtZsn3KcTaeK8h7Tq2A@mail.gmail.com
обсуждение исходный текст
Ответ на COUNT(*) and index-only scans  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Mon, Oct 10, 2011 at 6:23 PM, Bruce Momjian <bruce@momjian.us> wrote:
> I talked to Robert Haas and he said that index-only scans do not
> optimize COUNT(*).  Is this something we can do for PG 9.2?  Is anyone
> working on this?

People usually conflate multiple problems when they talk about
"count(*). The usual case people are concerned about would require
materialized views, not index-only scans.


--
greg


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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: COUNT(*) and index-only scans
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: COUNT(*) and index-only scans