X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1AF939DC8A5 for ; Sat, 4 Mar 2006 15:07:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26938-01 for ; Sat, 4 Mar 2006 15:07:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.199]) by postgresql.org (Postfix) with ESMTP id 4D4E59DC893 for ; Sat, 4 Mar 2006 15:07:20 -0400 (AST) Received: by nproxy.gmail.com with SMTP id x37so667244nfc for ; Sat, 04 Mar 2006 11:07:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=akceifqvUWTL//9iowRYO+Vz2AMIEIymzTUree7RxSCSuJw91s2veXebDil3WVWcAoJDcwPe/LEXZu9PABAVGhpiMPMKt3jpG+cDrVQajhP1UrCkwVYgkbIFZkAqx73jdtzkw44xif0wq+hmPp3r1XvqyOKJLpzjnwcLVC9OXck= Received: by 10.48.226.12 with SMTP id y12mr1676242nfg; Sat, 04 Mar 2006 11:07:20 -0800 (PST) Received: by 10.49.7.7 with HTTP; Sat, 4 Mar 2006 11:07:20 -0800 (PST) Message-ID: Date: Sat, 4 Mar 2006 22:07:20 +0300 From: "Nikolay Samokhvalov" Reply-To: nikolay@samokhvalov.com To: pgsql-sql@postgresql.org, "Bryce Nesbitt" Subject: Re: Sequential scan where Index scan expected. In-Reply-To: <4407EFD9.7050008@obviously.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <244004377.20060302124132@isb.com.pl> <2873.1141312882@sss.pgh.pa.us> <4407EFD9.7050008@obviously.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.162 required=5 tests=[AWL=0.162] X-Spam-Score: 0.162 X-Spam-Level: X-Archive-Number: 200603/86 X-Sequence-Number: 24432 cGxlYXNlLCBzaG93ICdcZCB4eF90aGluZ19ldmVudCcgdG9vIDotKQoKT24gMy8zLzA2LCBCcnlj ZSBOZXNiaXR0IDxicnljZTFAb2J2aW91c2x5LmNvbT4gd3JvdGU6Cj4gSSdtIGdldHRpbmcgc2Vx dWVudGlhbCBzY2FucyAoYW5kIHBvb3IgcGVyZm9ybWFuY2UpLCBvbiBzY2FucyB1c2luZyBteQo+ IHByaW1hcnkga2V5cy4KPiBDYW4gYW55b25lIGhlbHAgZmlndXJlIG91dCB3aHk/Cj4KPiBkZW1v PSMgXGQgeHhfdGhpbmcKPiAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLnh4X3Ro aW5nIgo+ICAgICAgICAgIENvbHVtbiAgICAgICAgICB8ICAgICAgICAgICAgVHlwZSAgICAgICAg ICAgICB8IE1vZGlmaWVycwo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0KPiAgdGhpbmdfaWQgICAgICAgICAgICAgIHwg YmlnaW50ICAgICAgICAgICAgICAgICAgICAgIHwgbm90IG51bGwKPiB0aGluZ19tb2RlbCAgICAg ICAgICAgfCBjaGFyYWN0ZXIgdmFyeWluZygxMjgpICAgICAgfAo+ICB0aGluZ19jb2xvciAgICAg ICAgICAgfCBjaGFyYWN0ZXIgdmFyeWluZygxMjgpICAgICAgfAo+ICB0aGluZ195ZWFyICAgICAg ICAgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgICAgICAgfAo+IEluZGV4ZXM6Cj4gICAgICJ4 eF90aGluZ19wa2V5IiBwcmltYXJ5IGtleSwgYnRyZWUgKHRoaW5nX2lkKQo+Cj4KPiBkZW1vPSMg YW5hbHl6ZSB2ZXJib3NlIHh4X3RoaW5nX2V2ZW50Owo+IElORk86ICBhbmFseXppbmcgInB1Ymxp Yy54eF90aGluZ19ldmVudCIKPiBJTkZPOiAgInh4X3RoaW5nX2V2ZW50IjogMzM3NCBwYWdlcywg MzAwMCByb3dzIHNhbXBsZWQsIDE5NzQ3OCBlc3RpbWF0ZWQKPiB0b3RhbCByb3dzCj4KPgo+IGRl bW89IyBleHBsYWluIHVwZGF0ZSB4eF90aGluZ19ldmVudCBzZXQgdGhpbmdfY29sb3I9J2Zvbycg d2hlcmUKPiB0aGluZ19ldmVudF9pZD0xMDAwMDsKPiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFFVRVJZIFBMQU4KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPiAgU2VxIFNjYW4gb24geHhfdGhpbmdfZXZl bnQgIChjb3N0PTAuMDAuLjU4NDIuNDggcm93cz0xIHdpZHRoPTExMCkKPiAgICBGaWx0ZXI6ICh0 aGluZ19ldmVudF9pZCA9IDEwMDAwKQo+ICgyIHJvd3MpCj4KPgo+Cj4gLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tKGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t Cj4gVElQIDU6IGRvbid0IGZvcmdldCB0byBpbmNyZWFzZSB5b3VyIGZyZWUgc3BhY2UgbWFwIHNl dHRpbmdzCj4KCgotLQpCZXN0IHJlZ2FyZHMsCk5pa29sYXkK