Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] Approximate count(*) - Mailing list pgsql-docs

From Josh Berkus
Subject Re: [PATCHES] Approximate count(*)
Date
Msg-id 200503241919.00628.josh@agliodbs.com
Whole thread Raw
In response to Re: [PATCHES] Approximate count(*)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: [PATCHES] Approximate count(*)  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-docs
Tree view 
David,

If Jim and I finish our work for 8.1, then you'll be able to do:

SELECT approx_records FROM pg_sysviews.pg_tables WHERE schema_name = 'schema'
AND table_name = 'table'

But the same caveats will apply.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-docs by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: [PATCHES] Approximate count(*)
Next
From: Josh Berkus
Date:
Subject: Missing doc on expression format for ALTER TABLE