Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3CF29633AAE for ; Wed, 31 Mar 2010 18:47:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 02945-01 for ; Wed, 31 Mar 2010 21:47:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 807EC6328F0 for ; Wed, 31 Mar 2010 18:47:24 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Wed, 31 Mar 2010 16:47:23 -0500 Message-Id: <4BB37C9602000025000302CB@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Wed, 31 Mar 2010 16:47:18 -0500 From: "Kevin Grittner" To: "Naomi Walker" , Subject: Re: Free Space after vacuuming References: <49ECBBD3.5060200@nasa.gov> <20090420182602.GE10358@alvh.no-ip.org> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.524 tagged_above=-10 required=5 tests=AWL=-0.784, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201003/295 X-Sequence-Number: 34094 "Naomi Walker" 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