X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 85A579FA0ED for ; Mon, 18 Sep 2006 05:50:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 47233-10 for ; Mon, 18 Sep 2006 08:50:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.197]) by postgresql.org (Postfix) with ESMTP id 6BD8D9F9FE1 for ; Mon, 18 Sep 2006 05:50:45 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 14so1382130nzn for ; Mon, 18 Sep 2006 01:50:44 -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=Vot1TrP3gdhSNCU10dPZgtWBqLP7gApkS3FchIr6He1CVR3EuHqhU97LrRB2op8+vPSZs4NG4rUboYUKgUM+3rWEgmpi37vMs9PLug3caPBdDYN25MvgEy7Q/E4aSZ7bfIY3iCXHBgQMEBe5n6v3QuXTlTbIWjFRG3R5gxgczMQ= Received: by 10.64.184.14 with SMTP id h14mr15086348qbf; Mon, 18 Sep 2006 01:50:43 -0700 (PDT) Received: by 10.64.96.15 with HTTP; Mon, 18 Sep 2006 01:50:43 -0700 (PDT) Message-ID: Date: Mon, 18 Sep 2006 10:50:43 +0200 From: "Guido Neitzer" To: "=?UTF-8?Q?Piotr_Ko=C5=82aczkowski?=" Subject: Re: Poor performance on seq scan Cc: pgsql-performance@postgresql.org In-Reply-To: <200609121410.02710.P.Kolaczkowski@elka.pw.edu.pl> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 Content-Disposition: inline References: <450684EC.4090304@designaproduct.biz> <4506902C.7090407@enterprisedb.com> <200609121410.02710.P.Kolaczkowski@elka.pw.edu.pl> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.423 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, MIME_BASE64_NO_NAME, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/227 X-Sequence-Number: 20913 QmVjYXVzZSB0aGVyZSBpcyBubyBNVkNDIGluZm9ybWF0aW9uIGluIHRoZSBpbmRleC4KCmN1ZwoK MjAwNi85LzEyLCBQaW90ciBLb8WCYWN6a293c2tpIDxQLktvbGFjemtvd3NraUBlbGthLnB3LmVk dS5wbD46Cj4gT24gVHVlc2RheSAxMiBTZXB0ZW1iZXIgMjAwNiAxMjo0NywgSGVpa2tpIExpbm5h a2FuZ2FzIHdyb3RlOgo+ID4gTGFzemxvIE5hZ3kgd3JvdGU6Cj4gPiA+IEkgbWFkZSBhbm90aGVy IHRlc3QuIEkgY3JlYXRlIGEgZmlsZSB3aXRoIHRoZSBpZGVudGlmaWVycyBhbmQgbmFtZXMgb2YK PiA+ID4gdGhlIHByb2R1Y3RzOgo+ID4gPgo+ID4gPiBwc3FsI1xvIHByb2R1Y3RzLnR4dAo+ID4g PiBwc3FsI3NlbGVjdCBpZCxuYW1lIGZyb20gcHJvZHVjdDsKPiA+ID4KPiA+ID4gVGhlbiBJIGNh biBzZWFyY2ggdXNpbmcgZ3JlcDoKPiA+ID4KPiA+ID4gZ3JlcCAiTXVnIiBwcm9kdWN0cy50eHQg fCBjdXQgLWYxIC1kXHwKPiA+ID4KPiA+ID4gVGhlcmUgaXMgYSBodWdlIGRpZmZlcmVuY2UuIFRo aXMgY29tbWFuZCBydW5zIHdpdGhpbiAwLjUgc2Vjb25kcy4gVGhhdAo+ID4gPiBpcywgYXQgbGVh c3QgNzYgdGltZXMgZmFzdGVyIHRoYW4gdGhlIHNlcSBzY2FuLiBJdCBpcyB0aGUgc2FtZSBpZiBJ Cj4gPiA+IHZhY3V1bSwgYmFja3VwIGFuZCByZXN0b3JlIHRoZSBkYXRhYmFzZS4gSSB0aG91Z2h0 IHRoYXQgdGhlIHRhYmxlIGlzCj4gPiA+IHN0b3JlZCBpbiBvbmUgZmlsZSwgYW5kIHRoZSBzZXEg c2NhbiB3aWxsIGJlIGFjdHVhbGx5IGZhc3RlciB0aGFuCj4gPiA+IGdyZXBwaW5nIHRoZSBmaWxl LiBDYW4geW91IHBsZWFzZSB0ZWxsIG1lIHdoYXQgYW0gSSBkb2luZyB3cm9uZz8gSSdtCj4gPiA+ IG5vdCBzdXJlIGlmIEkgY2FuIGluY3JlYXNlIHRoZSBwZXJmb3JtYW5jZSBvZiBhIHNlcSBzY2Fu IGJ5IGFkanVzdGluZwo+ID4gPiB0aGUgdmFsdWVzIGluIHBvc3RncmVzcWwuY29uZi4gSSBkbyBu b3QgbGlrZSB0aGUgaWRlYSBvZiBleHBvcnRpbmcgdGhlCj4gPiA+IHByb2R1Y3QgdGFibGUgcGVy aW9kaWNhbGx5IGludG8gYSB0eHQgZmlsZSwgYW5kIHNlYXJjaCB3aXRoIGdyZXAuIDotKQo+ID4K PiA+IElzIHRoZXJlIGFueSBvdGhlciBjb2x1bW5zIGJlc2lkZXMgaWQgYW5kIG5hbWUgaW4gdGhl IHRhYmxlPyBIb3cgYmlnIGlzCj4gPiBwcm9kdWN0cy50eHQgY29tcGFyZWQgdG8gdGhlIGhlYXAg ZmlsZT8KPiA+Cj4gPiA+IEFub3RoZXIgcXVlc3Rpb246IEkgaGF2ZSBhIGJ0cmVlIGluZGV4IG9u IHByb2R1Y3QobmFtZSkuIEl0IGNvbnRhaW5zCj4gPiA+IGFsbCBwcm9kdWN0IG5hbWVzIGFuZCB0 aGUgaWRlbnRpZmllcnMgb2YgdGhlIHByb2R1Y3RzLiBXb3VsZG4ndCBpdCBiZQo+ID4gPiBlYXNp ZXIgdG8gc2VxIHNjYW4gdGhlIGluZGV4IGluc3RlYWQgb2Ygc2VxIHNjYW4gdGhlIHRhYmxlPyBU aGUgaW5kZXgKPiA+ID4gaXMgb25seSA2Nk1CLCB0aGUgdGFibGUgaXMgMTEyM01CLgo+ID4KPiA+ IFByb2JhYmx5LCBidXQgUG9zdGdyZVNRTCBkb2Vzbid0IGtub3cgaG93IHRvIGRvIHRoYXQuIEV2 ZW4gaWYgaXQgZGlkLCBpdAo+ID4gZGVwZW5kcyBvbiBob3cgbWFueSBtYXRjaGVzIHRoZXJlIGlz LiBJZiB5b3Ugc2NhbiB0aGUgaW5kZXggYW5kIHRoZW4KPiA+IGZldGNoIHRoZSBtYXRjaGluZyBy b3dzIGZyb20gdGhlIGhlYXAsIHlvdSdyZSBkb2luZyByYW5kb20gSS9PIHRvIHRoZQo+ID4gaGVh cC4gVGhhdCBiZWNvbWVzIHNsb3dlciB0aGFuIHNjYW5uaW5nIHRoZSBoZWFwIHNlcXVlbnRpYWxs eSBpZiB5b3UncmUKPiA+IGdvaW5nIHRvIGdldCBtb3JlIHRoYW4gYSBmZXcgaGl0cy4KPgo+IFdo eSBtYXRjaCByb3dzIGZyb20gdGhlIGhlYXAgaWYgQUxMIHJlcXVpcmVkIGRhdGEgYXJlIGluIHRo ZSBpbmRleCBpdHNlbGY/Cj4gV2h5IGxvb2sgYXQgdGhlIGhlYXAgYXQgYWxsPwo+Cj4gVGhpcyBp cyB0aGUgc2FtZSBwZXJmb3JtYW5jZSBwcm9ibGVtIGluIFBvc3RncmVTUUwgSSBub3RpY2VkIHdo ZW4gZG9pbmcKPiBzb21lICJTRUxFQ1QgY291bnQoKikiIHF1ZXJpZXMuIExvb2sgYXQgdGhpczoK Pgo+IGV4cGxhaW4gYW5hbHl6ZSBzZWxlY3QgY291bnQoKikgZnJvbSB0cmFuc2FrY2phIHdoZXJl IGRhdGEgPiAnMjAwNS0wOS0wOScgYW5kCj4gbWllc2lhYyA+PSAoOSArIDIwMDUgKiAxMikgYW5k IGt3b3RhIDwgNTA7Cj4KPiBRVUVSWSBQTEFOCj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tCj4gIEFnZ3JlZ2F0ZSAgKGNvc3Q9NjAxNTU3Ljg2Li42MDE1 NTcuODcgcm93cz0xIHdpZHRoPTApIChhY3R1YWwKPiB0aW1lPTI2NzMzLjQ3OS4uMjY3MzMuNDg0 IHJvd3M9MSBsb29wcz0xKQo+ICAgIC0+ICBCaXRtYXAgSGVhcCBTY2FuIG9uIHRyYW5zYWtjamEg IChjb3N0PTE1NDg3OC4wMC4uNTk2OTI4LjIzIHJvd3M9MTg1MTg1Mgo+IHdpZHRoPTApIChhY3R1 YWwgdGltZT05OTc0LjIwOC4uMTg3OTYuMDYwIHJvd3M9MTY1NDIxOCBsb29wcz0xKQo+ICAgICAg ICAgIFJlY2hlY2sgQ29uZDogKChtaWVzaWFjID49IDI0MDY5KSBBTkQgKGt3b3RhIDwgNTA6OmRv dWJsZSBwcmVjaXNpb24pKQo+ICAgICAgICAgIEZpbHRlcjogKGRhdGEgPiAnMjAwNS0wOS0wOSAw MDowMDowMCc6OnRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSkKPiAgICAgICAgICAtPiAgQml0 bWFwIEluZGV4IFNjYW4gb24gaWR4X3RyYW5zYWtjamFfbWllc2lhY19rd290YQo+IChjb3N0PTAu MDAuLjE1NDg3OC4wMCByb3dzPTU1NTU1NTYgd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTk5MTkuOTY3 Li45OTE5Ljk2Nwo+IHJvd3M9MTY5MDQwMiBsb29wcz0xKQo+ICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICgobWllc2lhYyA+PSAyNDA2OSkgQU5EIChrd290YSA8IDUwOjpkb3VibGUKPiBwcmVj aXNpb24pKQo+ICBUb3RhbCBydW50aW1lOiAyNjczMy45ODAgbXMKPiAoNyByb3dzKQo+Cj4gVGhl IGFjdHVhbCB0aW1lIHJldHJpZXZpbmcgdHVwbGVzIGZyb20gdGhlIGluZGV4IGlzIGxlc3MgdGhh biAxMCBzZWNvbmRzLCBidXQKPiB0aGUgc3lzdGVtIGV4ZWN1dGVzIG5lZWRsZXNzIGhlYXAgc2Nh biB0aGF0IHRha2VzIHVwIGFkZGl0aW9uYWwgMTYgc2Vjb25kcy4KPgo+IEJlc3QgcmVnYXJkcywK PiBQZXRlcgo+Cj4KPgo+Cj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKGVuZCBvZiBicm9h ZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCj4gVElQIDk6IEluIHZlcnNpb25zIGJl bG93IDguMCwgdGhlIHBsYW5uZXIgd2lsbCBpZ25vcmUgeW91ciBkZXNpcmUgdG8KPiAgICAgICAg Y2hvb3NlIGFuIGluZGV4IHNjYW4gaWYgeW91ciBqb2luaW5nIGNvbHVtbidzIGRhdGF0eXBlcyBk byBub3QKPiAgICAgICAgbWF0Y2gKPgoKCi0tIApQb3N0Z3JlU1FMIEJvb3RjYW1wLCBCaWcgTmVy ZCBSYW5jaCBFdXJvcGUsIE5vdiAyMDA2Cmh0dHA6Ly93d3cuYmlnbmVyZHJhbmNoLmNvbS9uZXdz LzIwMDYtMDgtMjEuc2h0bWwK