Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 877739FBFEE for ; Tue, 15 May 2007 22:28:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 72985-08 for ; Tue, 15 May 2007 22:28:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C2E069FBFD8 for ; Tue, 15 May 2007 22:28:10 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 7FD8F564D5; Tue, 15 May 2007 20:28:09 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 15 May 2007 20:28:08 -0500 Date: Tue, 15 May 2007 20:28:08 -0500 From: "Jim C. Nasby" To: pgsql-admin@postgresql.org Subject: Re: How overcome wait for vacuum full? Message-ID: <20070516012808.GF11533@nasby.net> References: <20070515221356.GG5264@nicku.org> <20070515225313.GV12731@alvh.no-ip.org> <20070515231616.GH5264@nicku.org> <20070516011252.GW12731@alvh.no-ip.org> <20070516012052.GC16310@nicku.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070516012052.GC16310@nicku.org> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070516:pgsql-admin@postgresql.org::/9SVvAjF7JbYH54m:00000000000 0000000000000000000000002ARq X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/135 X-Sequence-Number: 25455 On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote: > Dear Alvaro, > > On 15/05/07 21:12 -0400, Alvaro Herrera wrote: > >Nick Urbanik wrote: > >>On 15/05/07 18:53 -0400, Alvaro Herrera wrote: > >>>Instead of waiting a month for the time when you can take the > >>>application offline (thus accumulating a month's worth of dead tuples), > >>>run a non-full vacuum more often (say, once a day or more). It doesn't > >>>lock the table so the app can continue to be online while it runs. > >> > >>Yes, it is vacuumed non-full regularly. However, for some reason, > >>only a full vacuum will recover the space. > > > >You probably need to better configure the FSM settings. See > >fsm_max_pages in the docs. > > This is probably the critical piece of information we need to prevent > the need for another sleepless night and an outage! Thank you. http://www.pervasive-postgres.com/instantkb13/article.aspx?id=10087&cNode=5K1C3W might be of use as well. -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)