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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Ivan Voras" <ivoras(at)freebsd(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date: 2010-01-14 16:03:16
Message-ID: 4B4EEBE4020000250002E4AA@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ivan Voras <ivoras(at)freebsd(dot)org> wrote:

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

OK. Will do.

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre Frédéric Caillaud 2010-01-14 16:08:59 Re: Inserting 8MB bytea: just 25% of disk perf used?
Previous Message Ivan Voras 2010-01-14 15:59:57 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows