Faster 'select count(*) from table' ?

Поиск
Список
Период
Сортировка
От Matt Mello
Тема Faster 'select count(*) from table' ?
Дата
Msg-id 3E5BF1BD.9070301@spaceship.com
обсуждение исходный текст
Ответ на Re: Really bad insert performance: what did I do wrong?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Faster 'select count(*) from table' ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-performance
Does anyone know if there is a fast way to find out how many records are
in a table?

"Select count(*) from table" is very slow.

I would think that PG would keep up with the number of undeleted rows on
a realtime basis.  Is that the case?  If so, how would I query it?

Hope this is the correct list for this question.

Thanks!

--
Matt Mello



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

Предыдущее
От: Peter Childs
Дата:
Сообщение: Re: slow query
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Faster 'select count(*) from table' ?