Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B2C9B2E3B87 for ; Sat, 5 Jan 2008 13:30:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 15076-05 for ; Sat, 5 Jan 2008 13:30:42 -0400 (AST) Received: from eagle.jhcloos.com (eagle.jhcloos.com [207.210.242.212]) by postgresql.org (Postfix) with ESMTP id BFFE02E0238 for ; Sat, 5 Jan 2008 13:30:48 -0400 (AST) Received: by eagle.jhcloos.com (Postfix, from userid 10) id C049040203; Sat, 5 Jan 2008 17:30:47 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=eagle; t=1199554247; bh=BEsI8J487uYKlQRvHakgb3mH6oUrKer7+2LDebsAi kA=; h=From:To:Cc:Subject:In-Reply-To:References:User-Agent:Face: Copyright:OpenPGP:OpenPGP-Fingerprint:X-Hashcash:X-Hashcash: X-Hashcash:Date:Message-ID:Lines:MIME-Version:Content-Type; b=tezJ GSIzaAKEa38y6iXzh3fJnldmdP16RO7vKsEqSyNHEzWskTgNswyNRXxzDvTCsDEz549 bRR9qslxTmF5kH7jKMSjzLxUf/ZdiKBkKrecOYAYl5Sz/ki4a5PXvgTzdzVD9U68Law jtDlIpVttBxrr6sDrhZZ479/K4MFA6ksQ= Received: by lugabout.jhcloos.org (Postfix, from userid 500) id 0A04621481B; Sat, 5 Jan 2008 17:28:28 +0000 (UTC) From: James Cloos To: "Scott Marlowe" Cc: "Tom Lane" , pgsql-admin@postgresql.org Subject: Re: When does VACUUM FULL not clean out all deleted data? In-Reply-To: (Scott Marlowe's message of "Fri, 4 Jan 2008 11:02:33 -0600") References: <10656.1199426607@sss.pgh.pa.us> User-Agent: Gnus/5.110007 (No Gnus v0.7) Emacs/23.0.60 (gnu/linux) Face: iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAI1J REFUOE+lU9ESgCAIg64P1y+ngUdxhl5H8wFbbM0OmUiEhKkCYaZThXCo6KE5sCbA1DDX3genvO4d eBQgEMaM5qy6uWk4SfBYfdu9jvBN9nSVDOKRtwb+I3epboOsOX5pZbJNsBJFvmQQ05YMfieIBnYX FK2N6dOawd97r/e8RjkTLzmMsiVgrAoEugtviCM3v2WzjgAAAABJRU5ErkJggg== Copyright: Copyright 2007 James Cloos OpenPGP: ED7DAEA6; url=http://jhcloos.com/public_key/0xED7DAEA6.asc OpenPGP-Fingerprint: E9E9 F828 61A4 6EA9 0F2B 63E7 997A 9F17 ED7D AEA6 X-Hashcash: 1:23:080105:scott.marlowe@gmail.com::S4yg9uufppvKiYWl:0000000000000000000000000000000000000085C6 X-Hashcash: 1:23:080105:pgsql-admin@postgresql.org::QluMITT6AvA8FkOw:00000000000000000000000000000000000LEyg X-Hashcash: 1:23:080105:tgl@sss.pgh.pa.us::gvZSXU47D67JgCth:00000000000000000000000000000000000000000001Xang Date: Sat, 05 Jan 2008 17:28:27 +0000 Message-ID: Lines: 22 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/75 X-Sequence-Number: 27849 >>>>> "Scott" == Scott Marlowe writes: Scott> Note that routine vacuum FULL is not a good idea actually. Scott> vacuum full is something you run when things have gone wrong Scott> (i.e. not enough regular vacuuming) and it is usually best Scott> followed by reindexing all your indexes. I see. Scott> It's far better to keep track of bloat and run vacuum full, if at Scott> all, by hand, and only when needed. Running it regularly with no Scott> reindexing often results in index bloat which makes the database Scott> slower not faster. That, then, probably explains the extra five gigs. There are quite a few indices in the app's schema. Thanks. -JimC -- James Cloos OpenPGP: 1024D/ED7DAEA6