Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E1F639FA0B9 for ; Fri, 6 Oct 2006 16:13:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 12570-01-3 for ; Fri, 6 Oct 2006 16:13:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 842CA9FB55A for ; Fri, 6 Oct 2006 15:51:05 -0300 (ADT) Received: (qmail 8918 invoked by uid 500); 6 Oct 2006 19:01:34 -0000 Date: Fri, 6 Oct 2006 14:01:34 -0500 From: Bruno Wolff III To: Kevin Johnson Cc: Jim Nasby , pgsql-admin@postgresql.org, Sean Webb Subject: Re: Disk space consumed by pk not returned after vacuum or Message-ID: <20061006190134.GA6084@wolff.to> Mail-Followup-To: Bruno Wolff III , Kevin Johnson , Jim Nasby , pgsql-admin@postgresql.org, Sean Webb References: <45080D4C.2020709@noaa.gov> <20060922170557.GB571@wolff.to> <452531AB.2050709@noaa.gov> <4526326C.2000009@noaa.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4526326C.2000009@noaa.gov> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.047 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/50 X-Sequence-Number: 23353 On Fri, Oct 06, 2006 at 06:39:40 -0400, Kevin Johnson wrote: > You are correct, it is 7.4 we are running on a RHEL3 system. > The database itself is vacuumed via cron 6 times a day. The other thing you need to watch out for is that your FSM setting is large enough to recover all of the dead space. If your vacuum runs aren't recovering as much dead space as is being created on average, then you are going to have dead space accumalate.