Thanks to both Elein and Tom. pgstattuple (and dbsize) from contrib
gave me exactly what I wanted. The statistics views give me something
extra.
__
Marc
signature.asc
Description: This is a digitally signed message part
Marc Munro <[EMAIL PROTECTED]> writes:
> Is there a query that will return an estimated row count as well as an
> estimated unused tuple count for each table?
See the contrib/pgstattuple module.
regards, tom lane
---(end of broadcast)--
http://www.varlena.com/GeneralBits/107.php has an explanation
of the statistics views pg_stat*. Perhaps those would help.
--elein
[EMAIL PROTECTED]
On Wed, May 11, 2005 at 04:12:11PM -0700, Marc Munro wrote:
> On a 7.3 production system with limited downtime available, we can
> rarely take the t
On a 7.3 production system with limited downtime available, we can
rarely take the time to run vaccuum full. From time to time though,
performance of some of the tables becomes an issue and we have to
perform a full vaccum on those tables.
We'd like to be able to better plan these operations, so:
