Re: count() in 9.2

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: count() in 9.2
Дата
Msg-id k5mr14$6u2$1@ger.gmane.org
обсуждение исходный текст
Ответ на count() in 9.2  (Steve Horn <steve@stevehorn.cc>)
Ответы Re: count() in 9.2  (Simon Riggs <simon@2ndQuadrant.com>)
Re: count() in 9.2  (Steve Horn <steve@stevehorn.cc>)
Список pgsql-novice
Steve Horn wrote on 17.10.2012 17:00:
> One of the reasons that my team could not take advantage of
> PostgreSQL was due to the poor performance of count(*) aggregate
> function.

I wonder what kind of application makes a slow count(*) on a table a show stopper.

I have been developing DB centric applications for over 20 years now and that never has been any issue.

And which DBMS are you currently using?
I don't know any transactional DBMS that will do count all the rows in a table *really* fast...

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: count() in 9.2
Следующее
От: Ennio-Sr
Дата:
Сообщение: WARNING: psql version 8.4, server version 9.1