Re: Slow "Select count(*) ..." query on table with 60 Mio. rows

Kevin Grittner wrote:

Greg Smith <greg@2ndquadrant.com> wrote: 

The content was already there, just not linked into the main FAQ
yet: 
http://wiki.postgresql.org/wiki/Slow_Counting   

 
For a question asked this frequently, it should probably be in the
FAQ.  I'll add a link from there to the more thorough write-up.

There's a whole list of FAQs that are documented on the wiki but not in the main FAQ yet leftover from before the main FAQ was hosted there.  You can see them all at http://wiki.postgresql.org/wiki/Frequently_Asked_Questions

I just haven't had time to merge those all usefully into the main FAQ.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com