Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow "Select count(*) ..." query on table with 60 Mio. rows - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date
Msg-id hinf1q$qop$1@ger.gmane.org
Whole thread Raw
In response to Re: Slow "Select count(*) ..." query on table with 60 Mio. rows  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
List pgsql-performance
Tree view 
Kevin Grittner wrote:
> Matthew Wakeling <matthew@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

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

pgsql-performance by date:

Previous
From: Pierre Frédéric Caillaud
Date:
Subject: Re: performance config help
Next
From: "Kevin Grittner"
Date:
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows