One of the reasons that my team could not take advantage of PostgreSQL was due to the poor performance of count(*) aggregate function.
"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