Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B873B2E0242 for ; Tue, 18 Mar 2008 12:50:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66006-09 for ; Tue, 18 Mar 2008 12:50:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id BC7A82E0223 for ; Tue, 18 Mar 2008 12:50:29 -0300 (ADT) 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 m2IFowFf004311 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 18 Mar 2008 08:50:58 -0700 Date: Tue, 18 Mar 2008 08:50:59 -0700 From: "Joshua D. Drake" To: "Chris Kratz" Cc: pgsql-performance@postgresql.org Subject: Re: Planner mis-estimation using nested loops followup Message-ID: <20080318085059.7c5da59a@commandprompt.com> In-Reply-To: <3642025c0803180835n20062314g94870b137d8c3ff7@mail.gmail.com> References: <3642025c0803180835n20062314g94870b137d8c3ff7@mail.gmail.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]); Tue, 18 Mar 2008 08:50:59 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.685 tagged_above=0 required=5 tests=AWL=-2.111, MIME_BASE64_TEXT=2.796 X-Spam-Level: X-Archive-Number: 200803/373 X-Sequence-Number: 29327 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUdWUs IDE4IE1hciAyMDA4IDExOjM1OjA4IC0wNDAwDQoiQ2hyaXMgS3JhdHoiIDxjaHJpcy5rcmF0ekB2 aXN0YXNoYXJlLmNvbT4gd3JvdGU6DQoNCj4gTm9uZGVmYXVsdCBzZXR0aW5ncyBvZiBpbnRlcmVz dCBmcm9tIHBvc3RncmVzcWwuY29uZg0KPiANCj4gDQo+IHNoYXJlZF9idWZmZXJzID0gMTAyNE1C ICAgICAgICAgICAgICAgICAjIG1pbiAxMjhrQiBvcg0KPiBtYXhfY29ubmVjdGlvbnMqMTZrQiB3 b3JrX21lbSA9IDI1Nk1CDQo+ICMgbWluIDY0a0IgbWFpbnRlbmFuY2Vfd29ya19tZW0gPSAyNTZN QiAgICAgICAgICAgICMgbWluIDFNQg0KPiByYW5kb21fcGFnZV9jb3N0ID0gMS43NSAgICAgICAg ICAgICAgICAgIyBzYW1lIHNjYWxlIGFzIGFib3ZlDQo+IGVmZmVjdGl2ZV9jYWNoZV9zaXplID0g NDA5Nk1CDQo+IGRlZmF1bHRfc3RhdGlzdGljc190YXJnZXQgPSAxMDAgICAgICAgICAjIHJhbmdl IDEtMTAwMA0KPiANCj4gDQo+IElmIG5vdGhpbmcgZWxzZSwgcGVyaGFwcyB0aGlzIHdpbGwgaGVs cCBzb21lYm9keSBlbHNlIHdobyBoYXMgcnVuDQo+IGludG8gdGhlIHNhbWUgcHJvYmxlbS4gIElm IGV4cGxhaW4gYW5hbHl6ZSBvZiBhIHF1ZXJ5IHNob3dzIGEgbGFyZ2UNCj4gbWlzLWVzdGltYXRp b24gb2Ygcm93cyByZXR1cm5lZCBvbiBhIGpvaW4gKGVzdGltYXRlPTEsIGFjdHVhbD0yaykNCj4g Y2F1c2luZyB0aGUgcGxhbm5lciB0byBjaG9vc2UgbmVzdGVkIGxvb3BzIGluc3RlYWQgb2YgYW5v dGhlciBqb2luDQo+IHR5cGUsIHlvdSBtaWdodCB0cnkgcnVubmluZyB0aGUgcXVlcnkgd2l0aCBu ZXN0ZWQgbG9vcHMgc2V0IHRvIG9mZg0KPiBhbmQgc2VlIGlmIHRoYXQgaGVscHMgdy8gcGVyZm9y bWFuY2UuDQoNCkRpZCB5b3UgdHJ5IHRoYXQ/IERpZCBpdCB3b3JrPw0KDQpKb3NodWEgRC4gRHJh a2UNCg0KDQotIC0tIA0KVGhlIFBvc3RncmVTUUwgQ29tcGFueSBzaW5jZSAxOTk3OiBodHRwOi8v d3d3LmNvbW1hbmRwcm9tcHQuY29tLyANClBvc3RncmVTUUwgQ29tbXVuaXR5IENvbmZlcmVuY2U6 IGh0dHA6Ly93d3cucG9zdGdyZXNxbGNvbmZlcmVuY2Uub3JnLw0KRG9uYXRlIHRvIHRoZSBQb3N0 Z3JlU1FMIFByb2plY3Q6IGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvYWJvdXQvZG9uYXRlDQog ICAgICBQb3N0Z3JlU1FMIHBvbGl0aWNhbCBwdW5kaXQgfCBNb2NrZXIgb2YgRG9scGhpbnMNCg0K LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNpb246IEdudVBHIHYxLjQuNiAoR05V L0xpbnV4KQ0KDQppRDhEQlFGSDMrVGxBVGIvenFmWlVVUVJBbVhVQUtDandpZGZXMEtYanpVTTI2 STR5VHg5NC93U2lRQ2ZhcVdVDQplSTlpNXl1Y0JINzE4b2tXM3cyVWV3UT0NCj1CTzNFDQotLS0t LUVORCBQR1AgU0lHTkFUVVJFLS0tLS0NCg==