Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9CB802E2DC5 for ; Mon, 19 Nov 2007 13:19:00 -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 52654-02 for ; Mon, 19 Nov 2007 13:18:15 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id E77002E2D6D for ; Mon, 19 Nov 2007 13:18:50 -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 lAJHIgh3026558 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 19 Nov 2007 09:18:42 -0800 Date: Mon, 19 Nov 2007 09:18:59 -0800 From: "Joshua D. Drake" To: Bill Moran Cc: Jean-David Beyer , pgsql-performance@postgresql.org Subject: Re: autovacuum: recommended? Message-ID: <20071119091859.383b7607@commandprompt.com> In-Reply-To: <20071119085142.580a8975.wmoran@collaborativefusion.com> References: <473D659B.1070008@nekomancer.net> <20071116094541.GA5177@depesz.com> <474091D4.4000201@nekomancer.net> <3E736C3C-9137-4B14-9010-95E57B8385F0@decibel.org> <474191FC.3090402@verizon.net> <20071119085142.580a8975.wmoran@collaborativefusion.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, 19 Nov 2007 09:18:43 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/270 X-Sequence-Number: 27685 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBNb24s IDE5IE5vdiAyMDA3IDA4OjUxOjQyIC0wNTAwDQpCaWxsIE1vcmFuIDx3bW9yYW5AY29sbGFib3Jh dGl2ZWZ1c2lvbi5jb20+IHdyb3RlOg0KDQo+ID4gTHVja2lseSBJIGRvIG5vdCBzZWVtIHRvIGJl IHRyb3VibGVkIGJ5IHRoZSBwcm9ibGVtcyBleHBlcmllbmNlZCBieQ0KPiA+IHRoZSBPLlAuDQo+ ID4gDQo+ID4gSSBkbyBrbm93IHRoYXQgaWYgSSB0cnkgdG8gdXNlIC5ycG1zIGZyb20gb3RoZXIg c291cmNlcywgSSBjYW4gZ2V0DQo+ID4gaW4gYSBsb3Qgb2YgdHJvdWJsZSB3aXRoIGluY29tcGF0 aWJsZSBsaWJyYXJpZXMuIEFuZCBJIGNhbm5vdA0KPiA+IHVwZ3JhZGUgdGhlIGxpYnJhcmllcyB3 aXRob3V0IGRhbWFnaW5nIG90aGVyIHByb2dyYW1zLg0KPiANCj4gSSB0aGluayB5b3UndmUgbWlz c2VkIHRoZSBwb2ludC4NCj4gDQo+IFRoZSBkaXNjdXNzaW9uIGlzIG5vdCB0aGF0IHRoZSBkaXN0 cm8gaXMgYmFkIGJlY2F1c2UgaXQgaGFzbid0IG1vdmVkDQo+IGZyb20gOC4xIC0+IDguMi4gIFRo ZSBjb21tZW50IGlzIHRoYXQgaXQncyBiYWQgYmVjYXVzZSBpdCBoYXNuJ3QNCj4gdXBkYXRlZCBh IG1ham9yIGJyYW5jaCB3aXRoIHRoZSBsYXRlc3QgYnVnIGZpeGVzLiAgaS5lLiBpdCBoYXNuJ3QN Cj4gbW92ZWQgZnJvbSA4LjEuNCB0byA4LjEuNS4NCj4gDQo+IElmIHRoaXMgaXMgaW5kZWVkIHRo ZSBjYXNlLCBJIGFncmVlIHRoYXQgc3VjaCBhIGRpc3RybyBpc24ndCB3b3J0aA0KPiB1c2luZy4N Cg0KSSB3b3VsZCBub3RlLCBhbmQgVG9tIHdvdWxkIGFjdHVhbGx5IGJlIGEgYmV0dGVyIHBlcnNv biB0byBleHBvdW5kIG9uDQp0aGlzIHRoYXQgUmVkIEhhdCBoYXMgYSB0ZW5kZW5jeSAoYXQgbGVh c3QgdGhleSB1c2VkIHRvKSB0byBsZWF2ZSB0aGUNCm1pbm9yIG51bWJlciB1bmNoYW5nZWQuIEUu ZzsNCg0KOC4xLjQgaXMgc2hpcHBlZCB3aXRoIFJIRUw1IA0KVGhleSByZWxlYXNlIGEgc2Vydmlj ZSB1cGRhdGUNCllvdSBub3cgaGF2ZSA4LjEuNC0xLjkNCg0KT3Igc29tZSBzdWNoIGRyaXZlbC4g VGhleSBkbyB0aGlzIGJlY2F1c2UgYXBwbGljYXRpb24gdmVuZG9ycyB3ZXQNCnRoZW1zZWx2ZXMg aW4gZmVhciBpZiB0aGV5IHNlZSBhIHZlcnNpb24gY2hhbmdlIG1pZGN5bGUgbm8gbWF0dGVyIGhv dw0KbXVjaCB5b3UgdGVsbCB0aGVtIGl0IGlzIGp1c3Qgc2VjdXJpdHkgYW5kIGRhdGEgZml4ZXMu Li4NCg0KL21lIHdobyBoYXMgZGVhbHQgd2l0aCAzICJlbnRlcnByaXNlIiB2ZW5kb3JzIG9uIHRo aXMgZXhhY3QgaXNzdWVzIGluDQp0aGUgbGFzdCB3ZWVrLg0KDQpTaW5jZXJlbHksDQoNCkpvc2h1 YSBELiBEcmFrZSANCg0KDQotIC0tIA0KDQogICAgICA9PT0gVGhlIFBvc3RncmVTUUwgQ29tcGFu eTogQ29tbWFuZCBQcm9tcHQsIEluYy4gPT09DQpTYWxlcy9TdXBwb3J0OiArMS41MDMuNjY3LjQ1 NjQgICAyNHg3L0VtZXJnZW5jeTogKzEuODAwLjQ5Mi4yMjQwDQpQb3N0Z3JlU1FMIHNvbHV0aW9u cyBzaW5jZSAxOTk3ICBodHRwOi8vd3d3LmNvbW1hbmRwcm9tcHQuY29tLw0KCQkJVU5JUVVFIE5P VCBOVUxMDQpEb25hdGUgdG8gdGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9hYm91dC9kb25hdGUNClBvc3RncmVTUUwgUmVwbGljYXRpb246IGh0dHA6Ly93 d3cuY29tbWFuZHByb21wdC5jb20vcHJvZHVjdHMvDQoNCi0tLS0tQkVHSU4gUEdQIFNJR05BVFVS RS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkhRY1dH QVRiL3pxZlpVVVFSQXRZbUFKOVFLdUgvbW91ODdYQ3dpQm9EUGl3KzAzU1Q3UUNmUk1sYg0Kbjcr SVZmdGZPclBCZDIrQ0tBNkIxTjQ9DQo9TU1LTw0KLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0t DQo=