Re: Free Space after vacuuming - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Free Space after vacuuming
Date
Msg-id 4BB37C9602000025000302CB@gw.wicourts.gov
Whole thread Raw
In response to Free Space after vacuuming  ("Naomi Walker" <nwalker@mhs.mphasis.com>)
List pgsql-admin
"Naomi Walker" <nwalker@mhs.mphasis.com> wrote:

> How does one tell how much space is available (probably by table),
> after a "vacuum verbose analyze" has completed.

Personally, I mostly pay attention to these lines:

NNNNN pages contain useful free space.

(where NNNNN is a large number).

We grep for large numbers in the file where we've redirected the
nightly VACUUM ANALYZE VERBOSE output, and if we find something we
email our DBA team.

-Kevin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statistics Collector not collecting server activities
Next
From: Mario Splivalo
Date:
Subject: Re: Live sort-of-'warehousing' database how-to?