Re: select count(*) on large tables - Mailing list pgsql-performance

From Tom Lane
Subject Re: select count(*) on large tables
Date
Msg-id 13441.1081433347@sss.pgh.pa.us
Whole thread Raw
In response to select count(*) on large tables  (Cosimo Streppone <cosimo@streppone.it>)
List pgsql-performance
Cosimo Streppone <cosimo@streppone.it> writes:
> Is there an estimate time for this issue to be resolved?

Approximately never.  It's a fundamental feature of Postgres' design.

As noted by Dennis, you can look at the pg_class statistics if a recent
estimate is good enough, or you can build user-level tracking tools if
you'd rather have fast count(*) than concurrent update capability.  But
don't sit around waiting for the developers to "fix this bug", because
it isn't a bug and it isn't going to be fixed.

            regards, tom lane

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: data=writeback
Next
From: Bruce Momjian
Date:
Subject: Re: data=writeback