Re: Indices for select count(*)?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Indices for select count(*)?
Дата
Msg-id 200512231612.37801.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: Indices for select count(*)?  (Jaime Casanova <systemguards@gmail.com>)
Ответы Re: Indices for select count(*)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
One way to conceptually tackle this count(*) issue would be to create a new
index type for it.  The index type would (logically) just need to implement
insert and delete operations and keep a running count with a big lock around
it.  Users could then choose to trade off concurrent performance against the
speed of count() by creating or dropping that index.  Implementing that type
of index might not even be that hard but convincing the planer and executor
to use it without too many hardcoded cases seems more challenging.

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

Предыдущее
От: Mike Rylander
Дата:
Сообщение: Re: Inheritance Algebra
Следующее
От: Tom Lane
Дата:
Сообщение: Re: query for a time interval