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

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date: 2010-01-14 15:59:57
Message-ID: hinf1q$qop$1@ger.gmane.org
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

Maybe you could add a short note why an estimation like from the
pg_class table is usually enough.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-01-14 16:03:16 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Previous Message Pierre Frédéric Caillaud 2010-01-14 15:59:15 Re: performance config help