Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2826F2E3D21 for ; Mon, 7 Jan 2008 13:08:17 -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 03171-01 for ; Mon, 7 Jan 2008 13:08:13 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id EE4952E3D03 for ; Mon, 7 Jan 2008 13:08:12 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m07H8H5D022084 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 7 Jan 2008 09:08:18 -0800 Date: Mon, 7 Jan 2008 09:12:11 -0800 From: "Joshua D. Drake" To: Geoffrey Cc: pgsql-admin@postgresql.org Subject: Re: When does VACUUM FULL not clean out all deleted data? Message-ID: <20080107091211.7745b51a@commandprompt.com> In-Reply-To: <47824AE7.6000006@serioustechnology.com> References: <10656.1199426607@sss.pgh.pa.us> <47824AE7.6000006@serioustechnology.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 07 Jan 2008 09:08:18 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/78 X-Sequence-Number: 27852 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBNb24s IDA3IEphbiAyMDA4IDEwOjUzOjExIC0wNTAwDQpHZW9mZnJleSA8bGlzdHNAc2VyaW91c3RlY2hu b2xvZ3kuY29tPiB3cm90ZToNCg0KPiBTbywgSSdtIHdvbmRlcmluZyBpZiBhbnlvbmUgY2FuIHBv aW50IG1lIHRvIG1vcmUgc3BlY2lmaWMgaW5mb3JtYXRpb24NCj4gYXMgdG8gd2hlbiwgaWYgZXZl ciwgeW91IHNob3VsZCAndmFjdXVtIGZ1bGw/Jw0KDQoxLiBJZiB5b3Ugb3ZlciBydW4geW91ciBm c20gcGFnZXMNCiAgKiBFeGNlcHQgdGhhdCB2YWN1dW0gZnVsbCB3b24ndCByZWNsYWltIHRoZSBp bmRleCB1c2FnZSBzbyB1c2UNCkNMVVNURVIgaW5zdGVhZC4NCjIuIElmIHlvdSBhcmUgb25seSBy ZXBhaXJpbmcgYmxvYXQgb24gYSBzbWFsbGVyIHRhYmxlLg0KICAqIEl0IG1heSBiZSBmYXN0ZXIg dG8gYmFja3VwIGFuZCByZXN0b3JlIHRoZSB0YWJsZS4gU2luY2UgdmFjdXVtIGZ1bGwNCmlzIGFu IGV4Y2x1c2l2ZSBsb2NrIGFueXdheSBpdCBkb2Vzbid0IG1hdHRlci4NCg0KU2luY2VyZWx5LA0K DQpKb3NodWEgRC4gRHJha2UNCg0KDQotIC0tIA0KVGhlIFBvc3RncmVTUUwgQ29tcGFueTogU2lu Y2UgMTk5NywgaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS8gDQpTYWxlcy9TdXBwb3J0OiAr MS41MDMuNjY3LjQ1NjQgICAyNHg3L0VtZXJnZW5jeTogKzEuODAwLjQ5Mi4yMjQwDQpEb25hdGUg dG8gdGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9hYm91 dC9kb25hdGUNClNFTEVDVCAnVHJhaW5pbmcnLCAnQ29uc3VsdGluZycgRlJPTSB2ZW5kb3IgV0hF UkUgbmFtZSA9ICdDTUQnDQoNCg0KLS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNp b246IEdudVBHIHYxLjQuNiAoR05VL0xpbnV4KQ0KDQppRDhEQlFGSGdsMXJBVGIvenFmWlVVUVJB b2Q2QUtDVWtSS3krZ3FPa2I0eHBnVlhpUDhCQ0llUEtRQ2dvMnlTDQpaUm1uSVZ3cllIRm9KOGp1 STA4S0w2Yz0NCj1KYjFpDQotLS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0NCg==