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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date: 2010-01-14 18:01:50
Message-ID: 4B4F5C0E.6050506@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Kevin Grittner wrote:
> Matthew Wakeling <matthew(at)flymine(dot)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
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Kretschmer 2010-01-14 18:03:49 Re: bad execution plan for subselects containing windowing-function
Previous Message Tom Lane 2010-01-14 17:42:05 Re: bad execution plan for subselects containing windowing-function