Re: count() in 9.2

On 17 October 2012 18:48, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> 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.

That's a much better answer than my original reply.

There is only one answer, in any DBMS: Prepare special datastructures
that allow you to do that quickly, which is also an option in
Postgres.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services