Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 51BD12E0069 for ; Sat, 5 Jan 2008 13:26:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74604-09 for ; Sat, 5 Jan 2008 13:26:34 -0400 (AST) Received: from eagle.jhcloos.com (eagle.jhcloos.com [207.210.242.212]) by postgresql.org (Postfix) with ESMTP id 6CB2C2E3B88 for ; Sat, 5 Jan 2008 13:26:35 -0400 (AST) Received: by eagle.jhcloos.com (Postfix, from userid 10) id AD4FB40197; Sat, 5 Jan 2008 17:26:32 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=eagle; t=1199553993; bh=4DqGlIVA0YJ14WnpEhHS0KzfTe10gbTM1nhVfnxLV Rs=; 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=cabR JQjcgo/7GuyYcbdCXjOx9suH55W13nP35G1kGAudRju6i9QsmxH6zE9MNa9h46BpLe/ UdWAwAyUF3DOVCOcxnLiV3fX48l05qIZuQZxrivR9tWpE08ha2GlgLqE165HlUVTnKP PWt4uriWGfBfT6ULoOx3fAMUufzzEdXA0= Received: by lugabout.jhcloos.org (Postfix, from userid 500) id A809721481B; Sat, 5 Jan 2008 17:24:37 +0000 (UTC) From: James Cloos To: "Joshua D. Drake" Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: When does VACUUM FULL not clean out all deleted data? In-Reply-To: <477E5E31.1040202@commandprompt.com> (Joshua D. Drake's message of "Fri, 04 Jan 2008 08:26:25 -0800") References: <10656.1199426607@sss.pgh.pa.us> <477E5E31.1040202@commandprompt.com> 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:jd@commandprompt.com::131cXcckhtpn8hXC:000000000000000000000000000000000000000006ocQ X-Hashcash: 1:23:080105:tgl@sss.pgh.pa.us::n9ESpvSA44zKax9V:00000000000000000000000000000000000000000000TV1V X-Hashcash: 1:23:080105:pgsql-admin@postgresql.org::23oVP8grbLzSJhFr:00000000000000000000000000000000000d6dl Date: Sat, 05 Jan 2008 17:24:37 +0000 Message-ID: Lines: 11 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/74 X-Sequence-Number: 27848 >>>>> "Joshua" == Joshua D Drake writes: Joshua> Autovacuum by default won't do enough work for many production Joshua> databases. You still have to configure it. OK. Thanks. Good to know. -JimC -- James Cloos OpenPGP: 1024D/ED7DAEA6