Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date
Msg-id 4B4EEBE4020000250002E4AA@gw.wicourts.gov
Whole thread Raw
In response to Re: Slow "Select count(*) ..." query on table with 60 Mio. rows  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
Tree view 
Ivan Voras <ivoras@freebsd.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

pgsql-performance by date:

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