Re: count() in 9.2 - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: count() in 9.2
Date
Msg-id k5mr14$6u2$1@ger.gmane.org
Whole thread Raw
In response to count() in 9.2  (Steve Horn <steve@stevehorn.cc>)
Responses Re: count() in 9.2
Re: count() in 9.2
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: count() in 9.2
Next
From: Ennio-Sr
Date:
Subject: WARNING: psql version 8.4, server version 9.1