X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E90C49F9CC1 for ; Wed, 3 May 2006 14:54:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 99496-03 for ; Wed, 3 May 2006 14:54:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (pproxy.gmail.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id 6A0F89F9C1D for ; Wed, 3 May 2006 14:54:06 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id b29so274545pya for ; Wed, 03 May 2006 10:54:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bx7XweaAxaJ2bDCqTdLIMhQEIhEj4Zu2LrxPSw60lFBFqu19LmQoLYhXKCbfv6lJjV8AQb2qNIxfwWf/3P3rDlQUF/KcJrMJd100YOAupUnk196zsJ3spGgi8zOdlUB5a0r7HFvb7iqag4zedp2HzLKgiG1YwDe8GbzlsLXUenI= Received: by 10.35.9.2 with SMTP id m2mr73147pyi; Wed, 03 May 2006 10:54:05 -0700 (PDT) Received: by 10.35.45.14 with HTTP; Wed, 3 May 2006 10:54:04 -0700 (PDT) Message-ID: Date: Wed, 3 May 2006 10:54:04 -0700 From: "Ian Burrell" To: "Tom Lane" Subject: Re: Nested loop join and date range query Cc: pgsql-performance@postgresql.org In-Reply-To: <9688.1146625437@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 Content-Disposition: inline References: <9688.1146625437@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/89 X-Sequence-Number: 18876 T24gNS8yLzA2LCBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+IHdyb3RlOgo+ICJJYW4gQnVy cmVsbCIgPGlhbmJ1cnJlbGxAZ21haWwuY29tPiB3cml0ZXM6Cj4gPiBXZSByZWNlbnRseSB1cGdy YWRlZCB0byBQb3N0Z3JlU1FMIDguMSBmcm9tIDcuNCBhbmQgYSBmZXcgcXVlcmllcyBhcmUKPiA+ IGhhdmluZyBwZXJmb3JtYW5jZSBwcm9ibGVtcyBhbmQgcnVubmluZyBmb3IgdmVyeSBsb25nIHRp bWVzLiAgVGhlCj4gPiBjb21tb25hbGl0eSBzZWVtcyB0byBiZSBQb3N0Z3JlU1FMIDguMSBpcyBj aG9vc2luZyB0byB1c2UgYSBuZXN0ZWQKPiA+IGxvb3Agam9pbiBiZWNhdXNlIGl0IGVzdGltYXRl cyB0aGVyZSB3aWxsIGJlIG9ubHkgYmUgYSBzaW5nbGUgcm93Lgo+Cj4gV2UndmUgYWxyZWFkeSBu b3RlZCB0aGF0IHRoZXJlJ3MgYSBwcm9ibGVtIHdpdGggZXN0aW1hdGluZyB6ZXJvLXdpZHRoCj4g cmFuZ2VzICh0b28gbGF6eSB0byBzZWFyY2ggdGhlIGFyY2hpdmVzLCBidXQgdGhpcyBoYXMgY29t ZSB1cCBhdCBsZWFzdAo+IHR3aWNlIHJlY2VudGx5KS4gIENhbiB5b3UgbW9kaWZ5IHlvdXIgYXBw IHRvIGdlbmVyYXRlIHNvbWV0aGluZyBsaWtlCj4KPiAgICAgICAgIHdlZWsgPj0geCBhbmQgd2Vl ayA8IHgrMQo+Cj4gaW5zdGVhZCBvZgo+Cj4gICAgICAgICB3ZWVrID49IHggYW5kIHdlZWsgPD0g eAo+CgpJIGFtIHdvcmtpbmcgb24gbW9kaWZ5aW5nIHRoZSBTUUwgZ2VuZXJhdGlvbiBjb2RlIHRv IHJlcGxhY2UgdGhlCnplcm8td2lkdGggcmFuZ2Ugd2l0aCBhbiBlcXVhbHMuCgpEb2VzIEJFVFdF RU4gaGF2ZSB0aGUgc2FtZSBidWc/Cgo+ID8gIE15IHJlY29sbGVjdGlvbiBpcyB0aGF0IHRoZSBm aXggd2lsbCBwcm9iYWJseSBiZSBjb21wbGljYXRlZAo+IGVub3VnaCB0byBub3QgZ2V0IGJhY2st cGF0Y2hlZCBpbnRvIDguMS4KPgo+IEJUVywgQUZBSUsgdGhlIHNhbWUgcHJvYmxlbSBleGlzdHMg aW4gNy40LiAgV2hhdCBraW5kIG9mIGVzdGltYXRlcy9wbGFucwo+IHdlcmUgeW91IGdldHRpbmcg Zm9yIHRoaXMgY2FzZSBpbiA3LjQ/Cj4KCldlIGdldCBzaW1pbGFyIHJvd3M9MSBlc3RpbWF0ZXMg b24gNy40LiAgNy40IGRvZXNuJ3QgY2hvb3NlIHRvIHVzZSB0aGUKbmVzdGVkIGxvb3Agam9pbnMg c28gaXQgcGVyZm9ybXMgZmluZS4KCldlIGhhdmUgYmVlbiBnZXR0aW5nIHNpbWlsYXIgcm93cz0x IGVzdGltYXRlcyBhbmQgbmVzdGVkIGxvb3Agam9pbnMKd2l0aCBzb21lIG90aGVyIHF1ZXJpZXMu IEJ1dCBJIHRoaW5rIHRob3NlIGFyZSBjYXVzZWQgYnkgbm90CmZyZXF1ZW50bHkgYW5hbHl6aW5n IGxvZyB0eXBlIHRhYmxlcyBhbmQgdGhlbiBzZWFyY2hpbmcgZm9yIHJlY2VudApkYXlzIHdoaWNo IGl0IGRvZXNuJ3QgdGhpbmsgZXhpc3QuCgogLSBJYW4K