Postgres Pro
Downloads
Home   >   mailing lists

count() in 9.2 - Mailing list pgsql-novice

From Steve Horn
Subject count() in 9.2
Date
Msg-id CAFLkBaVjm9sF38ew_3quhKb7DRn_b5fBghJmgmda=rbB5jYW1Q@mail.gmail.com
Whole thread Raw
Responses Re: count() in 9.2
Re: count() in 9.2
List pgsql-novice
Tree view
One of the reasons that my team could not take advantage of PostgreSQL was due to the poor performance of count(*) aggregate function.

I visited the "Slow Counting" page on the wiki (http://wiki.postgresql.org/wiki/Slow_Counting) and it states:
"Note that the following article only applies to versions of PostgreSQL prior to 9.2. Index-only scans are now implemented."

So does this mean that count() is no longer slow? If not, how much faster is it? And what does it mean when it says "Index-only scans are now implemented."?

Thanks for your help!

--
Steve Horn

pgsql-novice by date:

Previous
From: Samat Galimov
Date:
Subject: Re: OID column in pg_class
Next
From: Simon Riggs
Date:
Subject: Re: count() in 9.2