Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 368EA2E3BD3 for ; Mon, 7 Jan 2008 13:47:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14697-09 for ; Mon, 7 Jan 2008 13:47:02 -0400 (AST) Received: from mout.perfora.net (mout.perfora.net [74.208.4.195]) by postgresql.org (Postfix) with ESMTP id 0CBD32E404C for ; Mon, 7 Jan 2008 13:43:37 -0400 (AST) Received: from [172.16.255.106] (duck.3times25.net [66.23.211.34]) by mrelay.perfora.net (node=mrus0) with ESMTP (Nemesis) id 0MKp8S-1JBw0c2my1-0004Db; Mon, 07 Jan 2008 12:43:36 -0500 Message-ID: <478264C5.9040004@serioustechnology.com> Date: Mon, 07 Jan 2008 12:43:33 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: When does VACUUM FULL not clean out all deleted data? References: <10656.1199426607@sss.pgh.pa.us> <47824AE7.6000006@serioustechnology.com> <20080107091211.7745b51a@commandprompt.com> In-Reply-To: <20080107091211.7745b51a@commandprompt.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1+/Qd+hwfPYJdyAoMft3xHhKhRVMlPabz4IgB0 DtgdFshs+8iGtxa8tllTxA90AWeYRVM83xMWr/GRvCKhaByMhY 6tykCB4C9fnWQqpPBHP8ay3eesIOrkP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/79 X-Sequence-Number: 27853 Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Mon, 07 Jan 2008 10:53:11 -0500 > Geoffrey wrote: > >> So, I'm wondering if anyone can point me to more specific information >> as to when, if ever, you should 'vacuum full?' > > 1. If you over run your fsm pages > * Except that vacuum full won't reclaim the index usage so use > CLUSTER instead. > 2. If you are only repairing bloat on a smaller table. > * It may be faster to backup and restore the table. Since vacuum full > is an exclusive lock anyway it doesn't matter. Thank you Joshua. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin