Re: [HACKERS] Much Ado About COUNT(*)

From: Wes <wespvp(at)syntegra(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Dann Corbit <DCorbit(at)connx(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] Much Ado About COUNT(*)
Date: 2005-01-14 23:57:21
Message-ID: BE0DB881.4060%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/14/05 5:37 PM, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote:

> If that's all you want, what about the row estimate from pg_class? It
> has the number of rows active at last vacuum... For really large tables
> I imagine it'd be easily close enough...

For showing the changes in a given day (or even week), that isn't accurate
enough.

Wes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2005-01-15 00:07:47 Re: MOVE
Previous Message Tom Lane 2005-01-14 23:47:35 Re: Parsing of backslash in statements via ODBC