[RFC] speed up count(*)

Поиск
Список
Период
Сортировка
От John Naylor
Тема [RFC] speed up count(*)
Дата
Msg-id CAFBsxsGn-LePDQksLdceecyipHdhaEh0G=oXFgdQNwyV7LGUfA@mail.gmail.com
обсуждение исходный текст
Ответы Re: [RFC] speed up count(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Perennially our users have complaints about slow count(*) when coming from some other systems. Index-only scans help, but I think we can do better. I recently wondered if a BRIN index could be used to answer min/max aggregate queries over the whole table, and it turns out it doesn't. However, then it occurred to me that if we had an opclass that keeps track of the count in each page range, that would be a way to do a fast count(*) by creating the right index. That would require planner support and other work, but it seems doable. Any opinions on whether this is worth the effort?

--

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

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [RFC] speed up count(*)