Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 712739F99C3 for ; Sat, 10 Nov 2007 14:50:57 -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 25483-06 for ; Sat, 10 Nov 2007 14:50:50 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 59B4B9F942D for ; Sat, 10 Nov 2007 14:50:51 -0400 (AST) Received: from scratch (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 lAAIooEn004874 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 10 Nov 2007 10:50:50 -0800 Date: Sat, 10 Nov 2007 10:51:19 -0800 From: "Joshua D. Drake" To: Jean-David Beyer Cc: pgsql performance Subject: Re: Curious about dead rows. Message-ID: <20071110105119.35346a29@scratch> In-Reply-To: <4735FA9F.1080805@verizon.net> References: <4735DBDB.5050208@verizon.net> <16627.1194714491@sss.pgh.pa.us> <4735FA9F.1080805@verizon.net> 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]); Sat, 10 Nov 2007 10:50:51 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/165 X-Sequence-Number: 27580 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBTYXQs IDEwIE5vdiAyMDA3IDEzOjM4OjIzIC0wNTAwDQpKZWFuLURhdmlkIEJleWVyIDxqZWFuZGF2aWQ4 QHZlcml6b24ubmV0PiB3cm90ZToNCg0KPiBUb20gTGFuZSB3cm90ZToNCj4gPiBKZWFuLURhdmlk IEJleWVyIDxqZWFuZGF2aWQ4QHZlcml6b24ubmV0PiB3cml0ZXM6DQo+ID4+IEkgYW0gZG9pbmcg bG90cyBvZiBJTlNFUlRzIG9uIGEgdGFibGUgdGhhdCBzdGFydHMgb3V0IGVtcHR5IChJIGRpZA0K PiA+PiBhIFRSVU5DQVRFIG9uIGl0KS4gSSBhbSBub3QsIEFGQUlLLCBkb2luZyBERUxFVEVzIG9y IFVQREFURXMuDQo+ID4+IEF1dG92YWN1dW0gaXMgb24uIEkgbW92ZWQgbG9nZ2luZyB1cCB0byBk ZWJ1ZzIgbGV2ZWwgdG8gc2VlIHdoYXQNCj4gPj4gd2FzIGdvaW5nIG9uLCBhbmQgSSBnZXQgdGhp bmdzIGxpa2UgdGhpczoNCj4gPiANCj4gPj4gICJ2bF9hcyI6IHNjYW5uZWQgMzAwMCBvZiA1Mjk2 IHBhZ2VzLCBjb250YWluaW5nIDIzMjk0NCBsaXZlIHJvd3MNCj4gPj4gYW5kIDEwMzMgZGVhZCBy b3dzOyAzMDAwIHJvd3MgaW4gc2FtcGxlLCA0MTEyMjQgZXN0aW1hdGVkIHRvdGFsDQo+ID4+IHJv d3MNCj4gPiANCj4gPj4gQSBsaXR0bGUgbGF0ZXIsIGl0IHNheXM6DQo+ID4gDQo+ID4+ICJ2bF9h cyI6IHNjYW5uZWQgMzAwMCBvZiA2OTE2IHBhZ2VzLCBjb250YWluaW5nIDIzMzUwNyBsaXZlIHJv d3MNCj4gPj4gYW5kIDQ5MyBkZWFkIHJvd3M7IDMwMDAgcm93cyBpbiBzYW1wbGUsIDUzODMxMSBl c3RpbWF0ZWQgdG90YWwgcm93cw0KPiA+IA0KPiA+IFdlbGwsICpzb21ldGhpbmcqIGlzIGRvaW5n IGRlbGV0ZXMgb3IgdXBkYXRlcyBpbiB0aGF0IHRhYmxlLiAgQmV0dGVyDQo+ID4gbG9vayBhIGJp dCBoYXJkZXIgYXQgeW91ciBhcHBsaWNhdGlvbiAuLi4NCj4gPiANCj4gT0ssIHlvdSBhZ3JlZSB0 aGF0IGlmIEkgYW0gZG9pbmcgb25seSBJTlNFUlRzLCB0aGF0IHRoZXJlIHNob3VsZCBub3QNCj4g YmUgYW55IGRlYWQgcm93cy4gVGhlcmVmb3JlLCBJIF9tdXN0XyBiZSBkb2luZyBkZWxldGVzIG9y IHVwZGF0ZXMuDQo+IA0KPiBCdXQgdGhlIHByb2dyYW0gaXMgcHJldHR5IHNpbXBsZSwgYW5kIEkg c2VlIG5vIFVQREFURXMgb3IgREVMRVRFcy4gSQ0KPiBzZWFyY2hlZCBhbGwgdGhlIHByb2dyYW0g c291cmNlIGZpbGVzICh0aGF0IGNvbnRhaW4gbm9uZSBvZiB0aGVtKSBhbmQNCj4gYWxsIHRoZSBs aWJyYXJpZXMgSSBoYXZlIHdyaXR0ZW4sIGFuZCB0aGV5IGhhdmUgbm9uZSBlaXRoZXIuIFJpZ2h0 DQo+IG5vdyB0aGUgcHJvZ3JhbXMgYXJlIG5vdCB0byB0aGUgc3RhdGUgd2hlcmUgVVBEQVRFcyBv ciBERUxFVEVzIGFyZQ0KPiByZXF1aXJlZCAodGhvdWdoIHRoZXkgd2lsbCBiZSBsYXRlcikuIEkg YW0gc3RpbGwgZGV2ZWxvcGluZyB0aGVtIGFuZA0KPiBpdCBpcyBlYXNpZXIgdG8ganVzdCByZXN0 b3JlIGZyb20gYmFja3VwIG9yIHN0YXJ0IG92ZXIgZnJvbSB0aGUNCj4gYmVnaW5uaW5nIHNpbmNl IG1vc3Qgb2YgdGhlIGNoYW5nZXMgYXJlIGRhdGEgbGF1bmRlcmluZyBmcm9tIGFuDQo+IGV2ZXIt aW5jcmVhc2luZyBudW1iZXIgb2Ygc3ByZWFkc2hlZXRzLg0KPiANCj4gQW0gSSByaWdodCB0aGF0 IFRSVU5DQVRFIGRlbGV0ZXMgYWxsIHRoZSByb3dzIG9mIGEgdGFibGUuIFRoZXkgbWF5DQo+IHRo ZW4gYmUgc3RpbGwgdGhlcmUsIGJ1dCB3b3VsZCBub3QgYXV0b3ZhY3V1bSBjbGVhbiBvdXQgdGhl IGRlYWQNCj4gcm93cz8gT3IgbWF5YmUgaXQgaGFzIG5vdCBnb3R0ZW4gdG8gdGhlbSB5ZXQ/IEkg Y291bGQgZG8gYW4gZXhwbGljaXQNCj4gb25lIGVhcmxpZXIuDQoNClRydW5jYXRlIHdpbGwgbm90 IGNyZWF0ZSBkZWFkIHJvd3MuIEhvd2V2ZXIgUk9MTEJBQ0sgd2lsbC4gQXJlIHlvdQ0KZ2V0dGlu ZyBhbnkgZHVwbGljYXRlIGtleSBlcnJvcnMgb3IgYW55dGhpbmcgbGlrZSB0aGF0IHdoZW4geW91 IGluc2VydD8NCg0KU2luY2VyZWx5LA0KDQpKb3NodWEgRC4gRHJha2UNCg0KIA0KDQoNCi0gLS0g DQoNCiAgICAgID09PSBUaGUgUG9zdGdyZVNRTCBDb21wYW55OiBDb21tYW5kIFByb21wdCwgSW5j LiA9PT0NClNhbGVzL1N1cHBvcnQ6ICsxLjUwMy42NjcuNDU2NCAgIDI0eDcvRW1lcmdlbmN5OiAr MS44MDAuNDkyLjIyNDANClBvc3RncmVTUUwgc29sdXRpb25zIHNpbmNlIDE5OTcgIGh0dHA6Ly93 d3cuY29tbWFuZHByb21wdC5jb20vDQoJCQlVTklRVUUgTk9UIE5VTEwNCkRvbmF0ZSB0byB0aGUg UG9zdGdyZVNRTCBQcm9qZWN0OiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2Fib3V0L2RvbmF0 ZQ0KUG9zdGdyZVNRTCBSZXBsaWNhdGlvbjogaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS9w cm9kdWN0cy8NCg0KLS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNpb246IEdudVBH IHYxLjQuNiAoR05VL0xpbnV4KQ0KDQppRDhEQlFGSE5mMnBBVGIvenFmWlVVUVJBcFlFQUtDV3Ax MDdrb0JocFdRYk1qd0x5YkJCNlN2RG1RQ2dqOFE2DQprUEFFNHFlMWZUNlJOYkZ0cWxJdzUyTT0N Cj0vNXVzDQotLS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0NCg==