Re: Free Space after vacuuming

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Naomi Walker" <nwalker(at)mhs(dot)mphasis(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Free Space after vacuuming
Date: 2010-03-31 21:47:18
Message-ID: 4BB37C9602000025000302CB@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Naomi Walker" <nwalker(at)mhs(dot)mphasis(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mario Splivalo 2010-04-01 07:54:37 Re: Live sort-of-'warehousing' database how-to?
Previous Message Tom Lane 2010-03-31 21:42:46 Re: Statistics Collector not collecting server activities