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

[Greg Smith]

Kevin Grittner wrote:
Matthew Wakeling <matt...@flymine.org> wrote:
 
  
This is an FAQ.
    
 
I just added it to the wiki FAQ page:
 
http://wiki.postgresql.org/wiki/FAQ#Why_is_.22SELECT_count.28.2A.29_FROM_bigtable.3B.22_slow.3F
  
The content was already there, just not linked into the main FAQ yet: 
http://wiki.postgresql.org/wiki/Slow_Counting

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