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