Re: count() in 9.2

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: count() in 9.2
Date: 2012-10-17 17:48:26
Message-ID: k5mr14$6u2$1@ger.gmane.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2012-10-17 17:50:30 WARNING: psql version 8.4, server version 9.1
Previous Message Simon Riggs 2012-10-17 16:57:28 Re: count() in 9.2