Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DA32664FC25 for ; Sat, 15 Nov 2008 09:55:42 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24801-09 for ; Sat, 15 Nov 2008 09:55:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.29]) by mail.postgresql.org (Postfix) with ESMTP id E3BD964FC21 for ; Sat, 15 Nov 2008 09:55:39 -0400 (AST) Received: by yx-out-2324.google.com with SMTP id 8so769188yxb.73 for ; Sat, 15 Nov 2008 05:55:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=gQLHDQcgc8WLO649nT/f072l98GK3W4K3cEYABoasgw=; b=cvnJFpHGg7bxavOF0ALXPvWCBLAT2v9wS9XDXisZRQKJjYCmNAbe1oy0axhkUUyG9c jd5hDhiTXYbZyD+AV+73gv1KUwSOWzqnm1l399gXvv5EiSSV46LMJuS9g3mabIcgjVhr kSU0JsOZm1Yau30HSfziL+2lIbyMwH9tdfH+8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=uWRFMyQLD5Ota+r9+64H3vWWnUlcoXtXDb3A2NsrbWhzV1A2JCuCn/V4xuyIR5N7Ga 9SYfMakxCl38zma45XlIRLAYI4DJnolvgJooBGfcvGlcthRfVzY5DsZ/fyy0gH6RodWv 0jqcMLRRKuKY9kMSFSWgvXlKjy9nBcYScX//4= Received: by 10.65.20.18 with SMTP id x18mr2004143qbi.92.1226757338357; Sat, 15 Nov 2008 05:55:38 -0800 (PST) Received: by 10.64.142.18 with HTTP; Sat, 15 Nov 2008 05:55:38 -0800 (PST) Message-ID: <331e40660811150555l662be646ud07bf357348f1310@mail.gmail.com> Date: Sat, 15 Nov 2008 15:55:38 +0200 From: "=?ISO-8859-5?B?svbi0Nv22SDC2Nzn2OjY3Q==?=" To: "David Wilson" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL OR performance In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37646_13780665.1226757338379" References: <331e40660811050312u552cab53ifa88e493e1c4f7ac@mail.gmail.com> <1225902700.1432.53.camel@jdavis> <331e40660811060246m51df553egd4e2ba91f08d1434@mail.gmail.com> <29e3942f0811060426k5fe34b1av401a2dba62e4ae3c@mail.gmail.com> <331e40660811060833l49bf837em41ca88d4b2061ea1@mail.gmail.com> <49131ED5.80307@archonet.com> <331e40660811060937q460e6f9fvf336455200d31f56@mail.gmail.com> <331e40660811070114rd70cf0dy194020a9f9ea8802@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200811/137 X-Sequence-Number: 31868 ------=_Part_37646_13780665.1226757338379 Content-Type: text/plain; charset=ISO-8859-5 Content-Transfer-Encoding: base64 Content-Disposition: inline U29ycnksIGZvciBkZWxheWVkIHJlc3BvbnNlIC0gSXQgd2FzIHZlcnkgYnVzeSB3ZWVrLgoKMjAw OC8xMS83IERhdmlkIFdpbHNvbiA8ZGF2aWQudC53aWxzb25AZ21haWwuY29tPgoKPiBPbiBGcmks IE5vdiA3LCAyMDA4IGF0IDQ6MTQgQU0sILL24tDb9tkgwtjc59jo2N0gPHRpdnYwMEBnbWFpbC5j b20+IHdyb3RlOgo+ID4gIk1lcmdlIEpvaW4gIChjb3N0PTUxODc3MS4wNy4uNjI4ODQ1NTkuODAg cm93cz0xMzg2MTU4MTcxIHdpZHRoPTMyKQo+IChhY3R1YWwKPiA+IHRpbWU9MzAyOTIuODAyLi43 NTU3NTEuMjQyIHJvd3M9MzQ3NDkgbG9vcHM9MSkiCj4KPiBIYXZlIHlvdSB0cmllZCBpbmNyZWFz aW5nIHRoZSBkZWZhdWx0X3N0YXRpc3RpY3NfdGFyZ2V0PyBUaGUgcGxhbm5lcgo+IGlzIGV4cGVj dGluZyAxLjMgYmlsbGlvbiByb3dzIHRvIGJlIHByb2R1Y2VkIGZyb20gYSBxdWVyeSB0aGF0J3Mg b25seQo+IGFjdHVhbGx5IHByb2R1Y3RpbmcgMzVrLCB3aGljaCBwcm9iYWJseSBpbmRpY2F0ZXMg c29tZSB2ZXJ5IGJhZAo+IHN0YXRpc3RpY3MuCgoKIFRoZSBwbGFubmVyIHNlZW1zIHRvIHRoaW5r IHRoYXQgZXZlcnkgc2Vjb25kIHBhaXIgZnJvbSBjb21wYW55PC0+Y29tcGFueQpqb2luIHdpbGwg c3VjY2VlZCB3aXRoIHRoaXMgam9pbiBleHByZXNzaW9uICgxMzg2MTU4MTcxIH4gIDUyNjQ4XjIg LyAyKS4KVGhhdCBpcyBub3QgdHJ1ZS4KQW55d2F5LCBJJ3ZlIHRyaWVkIHRvIHNldCBkZWZhdWx0 X3N0YXRpc3RpY3NfdGFyZ2V0IHRvIDEwMDAsIHRoZW4gYW5hbHl6ZS4KTm90aGluZyd2ZSBjaGFu Z2VkCgpBdCB0aGUgc2FtZSB0aW1lLCB0aGUgbWF0ZXJpYWxpemUgc3RlcCBwcm9kdWNlcyAyNDIK PiBtaWxsaW9uIHJvd3Mgd2hlbiB0aGUgcGxhbm5lciBvbmx5IGV4cGVjdHMgdG8gcHJvZHVjZSAy LjMsIGluZGljYXRpbmcKPiBhIHNpbWlsYXIgcHJvYmxlbSBpbiB0aGUgb3Bwb3NpdGUgZGlyZWN0 aW9uLiBUaGlzIHByb2JhYmx5IG1lYW5zIHRoYXQKPiB0aGUgcGxhbm5lciBpcyBjaG9vc2luZyBw bGFucyB0aGF0IHdvdWxkIGJlIG9wdGltYWwgaWYgaXQgd2FzIG1ha2luZwo+IGdvb2QgZ3Vlc3Nl cyBidXQgYXJlIGRlY2lkZWRseSBzdWItb3B0aW1hbCBmb3IgeW91ciBhY3R1YWwgZGF0YS4KPgo+ ClRoYXQgaXMgZXZlbiBtb3JlIHN0cmFuZ2UsIGJlY2F1c2UgbWF0ZXJpYWxpemUgc3RlcCBtdXN0 IHByb2R1Y2UgZXhhY3RseSB0aGUKcm93cyBpdCB0YWtlcyBmcm9tIHNvcnQsIHRoYXQgaXMgMjMx NjUwMywgc28gSSBkb24ndCBnZXQgaG93IHRhYmxlIHNjYW4gKwpzb3J0ICsgbWF0ZXJpYWxpemUg Y2FuIG11bHRpcGx5IG51bWJlciBvZiByb3dzIGJ5IDEwMC4K ------=_Part_37646_13780665.1226757338379 Content-Type: text/html; charset=ISO-8859-5 Content-Transfer-Encoding: base64 Content-Disposition: inline U29ycnksIGZvciBkZWxheWVkIHJlc3BvbnNlIC0gSXQgd2FzIHZlcnkgYnVzeSB3ZWVrLjxicj48 YnI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPjIwMDgvMTEvNyBEYXZpZCBXaWxzb24gPHNwYW4g ZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86ZGF2aWQudC53aWxzb25AZ21haWwuY29tIiB0 YXJnZXQ9Il9ibGFuayI+ZGF2aWQudC53aWxzb25AZ21haWwuY29tPC9hPiZndDs8L3NwYW4+PGJy Pgo8YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXItbGVmdDogMXB4 IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0IDBwdCAwLjhleDsgcGFk ZGluZy1sZWZ0OiAxZXg7Ij4KPGRpdj5PbiBGcmksIE5vdiA3LCAyMDA4IGF0IDQ6MTQgQU0sILL2 4tDb9tkgwtjc59jo2N0gJmx0OzxhIGhyZWY9Im1haWx0bzp0aXZ2MDBAZ21haWwuY29tIiB0YXJn ZXQ9Il9ibGFuayI+dGl2djAwQGdtYWlsLmNvbTwvYT4mZ3Q7IHdyb3RlOjxicj4KJmd0OyAmcXVv dDtNZXJnZSBKb2luICZuYnNwOyhjb3N0PTUxODc3MS4wNy4uNjI4ODQ1NTkuODAgcm93cz0xMzg2 MTU4MTcxIHdpZHRoPTMyKSAoYWN0dWFsPGJyPgomZ3Q7IHRpbWU9MzAyOTIuODAyLi43NTU3NTEu MjQyIHJvd3M9MzQ3NDkgbG9vcHM9MSkmcXVvdDs8YnI+Cjxicj4KPC9kaXY+SGF2ZSB5b3UgdHJp ZWQgaW5jcmVhc2luZyB0aGUgZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldD8gVGhlIHBsYW5uZXI8 YnI+CmlzIGV4cGVjdGluZyAxLjMgYmlsbGlvbiByb3dzIHRvIGJlIHByb2R1Y2VkIGZyb20gYSBx dWVyeSB0aGF0JiMzOTtzIG9ubHk8YnI+CmFjdHVhbGx5IHByb2R1Y3RpbmcgMzVrLCB3aGljaCBw cm9iYWJseSBpbmRpY2F0ZXMgc29tZSB2ZXJ5IGJhZDxicj4Kc3RhdGlzdGljcy48L2Jsb2NrcXVv dGU+PGRpdj4mbmJzcDs8L2Rpdj48ZGl2PiZuYnNwO1RoZSBwbGFubmVyIHNlZW1zIHRvIHRoaW5r IHRoYXQgZXZlcnkgc2Vjb25kIHBhaXIgZnJvbSBjb21wYW55Jmx0Oy0mZ3Q7Y29tcGFueSBqb2lu IHdpbGwgc3VjY2VlZCB3aXRoIHRoaXMgam9pbiBleHByZXNzaW9uICgxMzg2MTU4MTcxIH4mbmJz cDsgNTI2NDheMiAvIDIpLiBUaGF0IGlzIG5vdCB0cnVlLiA8YnI+QW55d2F5LCBJJiMzOTt2ZSB0 cmllZCB0byBzZXQgZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldCB0byAxMDAwLCB0aGVuIGFuYWx5 emUuIE5vdGhpbmcmIzM5O3ZlIGNoYW5nZWQ8YnI+Cjxicj48L2Rpdj48YmxvY2txdW90ZSBjbGFz cz0iZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXItbGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIw NCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0IDBwdCAwLjhleDsgcGFkZGluZy1sZWZ0OiAxZXg7Ij4g QXQgdGhlIHNhbWUgdGltZSwgdGhlIG1hdGVyaWFsaXplIHN0ZXAgcHJvZHVjZXMgMjQyPGJyPgpt aWxsaW9uIHJvd3Mgd2hlbiB0aGUgcGxhbm5lciBvbmx5IGV4cGVjdHMgdG8gcHJvZHVjZSAyLjMs IGluZGljYXRpbmc8YnI+CmEgc2ltaWxhciBwcm9ibGVtIGluIHRoZSBvcHBvc2l0ZSBkaXJlY3Rp b24uIFRoaXMgcHJvYmFibHkgbWVhbnMgdGhhdDxicj4KdGhlIHBsYW5uZXIgaXMgY2hvb3Npbmcg cGxhbnMgdGhhdCB3b3VsZCBiZSBvcHRpbWFsIGlmIGl0IHdhcyBtYWtpbmc8YnI+Cmdvb2QgZ3Vl c3NlcyBidXQgYXJlIGRlY2lkZWRseSBzdWItb3B0aW1hbCBmb3IgeW91ciBhY3R1YWwgZGF0YS48 YnI+Cjxmb250IGNvbG9yPSIjODg4ODg4Ij48YnI+CjwvZm9udD48L2Jsb2NrcXVvdGU+PC9kaXY+ PGJyPlRoYXQgaXMgZXZlbiBtb3JlIHN0cmFuZ2UsIGJlY2F1c2UgbWF0ZXJpYWxpemUgc3RlcCBt dXN0IHByb2R1Y2UgZXhhY3RseSB0aGUgcm93cyBpdCB0YWtlcyBmcm9tIHNvcnQsIHRoYXQgaXMg MjMxNjUwMywgc28gSSBkb24mIzM5O3QgZ2V0IGhvdyB0YWJsZSBzY2FuICsgc29ydCArIG1hdGVy aWFsaXplIGNhbiBtdWx0aXBseSBudW1iZXIgb2Ygcm93cyBieSAxMDAuPGJyPgo8c3Bhbj48L3Nw YW4+PHNwYW4+PC9zcGFuPgo8c3BhbiBzdHlsZT0iZGlzcGxheTogbm9uZTsgdmlzaWJpbGl0eTog aGlkZGVuOyIgaWQ9Indpa0VkU2V0dXBGbGFnIj48L3NwYW4+PHNwYW4gc3R5bGU9ImRpc3BsYXk6 IG5vbmU7IHZpc2liaWxpdHk6IGhpZGRlbjsiIGlkPSJ3aWtFZERpZmZTZXR1cEZsYWciPjwvc3Bh bj4K ------=_Part_37646_13780665.1226757338379--