Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 982029FC028 for ; Wed, 9 May 2007 10:36:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 48976-04 for ; Wed, 9 May 2007 10:36:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.224]) by postgresql.org (Postfix) with ESMTP id 417619FC06D for ; Wed, 9 May 2007 10:36:47 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so205415nze for ; Wed, 09 May 2007 06:36:45 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=TDr8OYkw2Od588VKeY3O7ldjN2ZW/CBUZd0LvPK0xxO9caFPcygcf+H44T4NSn8Dvl9iBYqLdHq/uGl+CxGLlxb/UpbN/mL0kZbMR12FXIhOE0Zb6HOeWBFCcAAwd55WBsNjSurT55/faEW0Yi2h2uSMYKhHa3KHovdUgFUcxQY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=WQEImT984fFMI2TxzX+kSb08UvkIJd7Pmp15MQEpki5ApPX9ID86k8l95T8gwqGPrR50pW38X221C29TJOI2/T70U9evAOXl1VN6dc0qrjkaYdUd8lKL282x/RhLvKiOFXNbb4nO2it0XJD1+n1e9iFKW2fn6OKwXhbi82c4G84= Received: by 10.114.120.1 with SMTP id s1mr176593wac.1178717804872; Wed, 09 May 2007 06:36:44 -0700 (PDT) Received: by 10.115.19.4 with HTTP; Wed, 9 May 2007 06:36:44 -0700 (PDT) Message-ID: <3ce9822f0705090636s46b71c48mafb6ba7d64781fbf@mail.gmail.com> Date: Wed, 9 May 2007 15:36:44 +0200 From: "Valentine Gogichashvili" To: "Oleg Bartunov" Subject: Re: Cannot make GIN intarray index be used by the planner Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_104986_3128620.1178717804748" References: <3ce9822f0705090612nd6198a2xd06da85f1accbae9@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/186 X-Sequence-Number: 24576 ------=_Part_104986_3128620.1178717804748 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 Content-Disposition: inline SSBoYXZlIGV4cGVyaW1lbnRlZCBxdWl0ZSBhIGxvdC4gU28gZmlyc3QgSSBkaWQgd2hlbiBzdGFy dGluZyB0aGUgYXR0ZW1wdCB0bwptb3ZlIGZyb20gR2lTVCB0byBHSU4sIHdhcyB0byBkcm9wIHRo ZSBHaVNUIGluZGV4IGFuZCBjcmVhdGUgYSBicmFuZCBuZXcgR0lOCmluZGV4Li4uIGFmdGVyIHRo YXQgZGlkIG5vdCBicmluZyB0aGUgcmVzdWx0cywgSSBzdGFydGVkIHRvIGNyZWF0ZSBhbGwgdGhp cwp0YWJsZXMgd2l0aCBkaWZmZXJlbnQgc2V0cyBvZiBpbmRleGVzIGFuZCBzbyBvbi4uLgoKU28g dGhlIGFuc3dlciB0byB0aGUgcXVlc3Rpb24gaXM6IG5vIHRoZXJlIGluIG9ubHkgR0lOIGluZGV4 IG9uIHRoZSB0YWJsZS4KClRoYW5rIHlvdSBpbiBhZHZhbmNlLAoKVmFsZW50aW5lCgpPbiA1Lzkv MDcsIE9sZWcgQmFydHVub3YgPG9sZWdAc2FpLm1zdS5zdT4gd3JvdGU6Cj4KPiBEbyB5b3UgaGF2 ZSBib3RoIGluZGV4ZXMgKEdpU1QsIEdJTikgb24gdGhlIHNhbWUgdGFibGUgPwo+Cj4gT24gV2Vk LCA5IE1heSAyMDA3LCBWYWxlbnRpbmUgR29naWNoYXNodmlsaSB3cm90ZToKPgo+ID4gSGVsbG8g YWxsLAo+ID4KPiA+IEkgYW0gdHJ5aW5nIHRvIG1vdmUgZnJvbSBHaVNUIGludGFycmF5IGluZGV4 IHRvIEdJTiBpbnRhcnJheSBpbmRleCwgYnV0Cj4gbXkKPiA+IEdJTiBpbmRleCBpcyBub3QgYmVp bmcgdXNlZCBieSB0aGUgcGxhbm5lci4KPiA+Cj4gPiBUaGUgbm9ybWFsIHF1ZXJ5IGlzIGxpa2Ug dGhhdAo+ID4KPiA+IHNlbGVjdCAqCj4gPiBmcm9tIHNvdXJjZXRhYmxld2l0aF9pbnQ0Cj4gPiB3 aGVyZSBBUlJBWVtteWludF0gPEAgbXlpbnRfYXJyYXkKPiA+ICBhbmQgc29tZV9vdGhlcl9maWx0 ZXJzCj4gPgo+ID4gKHdpdGggR2lTVCBpbmRleCBldmVyeXRoaW5nIHdvcmtzIGZpbmUsIGJ1dCBH SU4gaW5kZXggaXMgbm90IGJlaW5nIHVzZWQpCj4gPgo+ID4gSWYgSSBjcmVhdGUgdGhlIHNhbWUg dGFibGUgcG9wdWxhdGluZyBpdCB3aXRoIHRleHRbXSBkYXRhIGxpa2UKPiA+Cj4gPiBzZWxlY3Qg bXlpbnRfYXJyYXk6OnRleHRbXSBhcyBteWludF9hcnJheV9hc190ZXh0YXJyYXkKPiA+IGludG8g bmV3dGFibGV3aXRoX3RleHQKPiA+IGZyb20gc291cmNldGFibGV3aXRoX2ludDQKPiA+Cj4gPiBh bmQgdGhlbiBjcmVhdGUgYSBHSU4gaW5kZXggdXNpbmcgdGhpcyBuZXcgdGV4dFtdIGNvbHVtbgo+ ID4KPiA+IHRoZSBwbGFubmVyIHN0YXJ0cyB0byB1c2UgdGhlIGluZGV4IGFuZCBxdWVyaWVzIHJ1 biB3aXRoIGdyYXRlIHNwZWVkCj4gd2hlbgo+ID4gdGhlIHF1ZXJ5IGxvb2tzIGxpa2UgdGhhdDoK PiA+Cj4gPiBzZWxlY3QgKgo+ID4gZnJvbSBuZXd0YWJsZXdpdGhfdGV4dAo+ID4gd2hlcmUgQVJS QVlbJ215aW50J10gPEAgbXlpbnRfYXJyYXlfYXNfdGV4dGFycmF5Cj4gPiAgYW5kIHNvbWVfb3Ro ZXJfZmlsdGVycwo+ID4KPiA+IFdoZXJlIHRoZSBwcm9ibGVtIGNhbiBiZSB3aXRoIF9pbnQ0IEdJ TiBpbmRleCBpbiB0aGlzIGNvbnN0ZWxsYXRpb24/Cj4gPgo+ID4gYnkgbm93IHRoZSBlbmFibGVf c2Vxc2NhbiBpcyBzZXQgdG8gb2ZmIGluIHRoZSBjb25maWd1cmF0aW9uLgo+ID4KPiA+IFdpdGgg YmVzdCByZWdhcmRzLAo+ID4KPiA+IC0tIFZhbGVudGluZSBHb2dpY2hhc2h2aWxpCj4gPgo+Cj4g ICAgICAgICBSZWdhcmRzLAo+ICAgICAgICAgICAgICAgICBPbGVnCj4gX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+IE9sZWcgQmFy dHVub3YsIFJlc2VhcmNoIFNjaWVudGlzdCwgSGVhZCBvZiBBc3Ryb05ldCAod3d3LmFzdHJvbmV0 LnJ1KSwKPiBTdGVybmJlcmcgQXN0cm9ub21pY2FsIEluc3RpdHV0ZSwgTW9zY293IFVuaXZlcnNp dHksIFJ1c3NpYQo+IEludGVybmV0OiBvbGVnQHNhaS5tc3Uuc3UsIGh0dHA6Ly93d3cuc2FpLm1z dS5zdS9+bWVnZXJhLwo+IHBob25lOiArMDA3KDQ5NSk5MzktMTYtODMsICswMDcoNDk1KTkzOS0y My04Mwo+CgoKCi0tIArhg5Xhg5Dhg5rhg5Thg5zhg6Lhg5jhg5wg4YOS4YOd4YOS4YOY4YOp4YOQ 4YOo4YOV4YOY4YOa4YOYClZhbGVudGluZSBHb2dpY2hhc2h2aWxpCg== ------=_Part_104986_3128620.1178717804748 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SSBoYXZlIGV4cGVyaW1lbnRlZCBxdWl0ZSBhIGxvdC4gU28gZmlyc3QgSSBkaWQgd2hlbiBzdGFy dGluZyB0aGUgYXR0ZW1wdCB0byBtb3ZlIGZyb20gR2lTVCB0byBHSU4sIHdhcyB0byBkcm9wIHRo ZSBHaVNUIGluZGV4IGFuZCBjcmVhdGUgYSBicmFuZCBuZXcgR0lOIGluZGV4Li4uIGFmdGVyIHRo YXQgZGlkIG5vdCBicmluZyB0aGUgcmVzdWx0cywgSSBzdGFydGVkIHRvIGNyZWF0ZSBhbGwgdGhp cyB0YWJsZXMgd2l0aCBkaWZmZXJlbnQgc2V0cyBvZiBpbmRleGVzIGFuZCBzbyBvbi4uLgo8YnI+ PGJyPlNvIHRoZSBhbnN3ZXIgdG8gdGhlIHF1ZXN0aW9uIGlzOiBubyB0aGVyZSBpbiBvbmx5IEdJ TiBpbmRleCBvbiB0aGUgdGFibGUuPGJyPjxicj5UaGFuayB5b3UgaW4gYWR2YW5jZSwgPGJyPjxi cj5WYWxlbnRpbmU8YnI+PGJyPjxkaXY+PHNwYW4gY2xhc3M9ImdtYWlsX3F1b3RlIj5PbiA1Lzkv MDcsIDxiIGNsYXNzPSJnbWFpbF9zZW5kZXJuYW1lIj5PbGVnIEJhcnR1bm92PC9iPgogJmx0Ozxh IGhyZWY9Im1haWx0bzpvbGVnQHNhaS5tc3Uuc3UiPm9sZWdAc2FpLm1zdS5zdTwvYT4mZ3Q7IHdy b3RlOjwvc3Bhbj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXIt bGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0IDBwdCAw LjhleDsgcGFkZGluZy1sZWZ0OiAxZXg7Ij5EbyB5b3UgaGF2ZSBib3RoIGluZGV4ZXMgKEdpU1Qs IEdJTikgb24gdGhlIHNhbWUgdGFibGUgPwo8YnI+PGJyPk9uIFdlZCwgOSBNYXkgMjAwNywgVmFs ZW50aW5lIEdvZ2ljaGFzaHZpbGkgd3JvdGU6PGJyPjxicj4mZ3Q7IEhlbGxvIGFsbCw8YnI+Jmd0 Ozxicj4mZ3Q7IEkgYW0gdHJ5aW5nIHRvIG1vdmUgZnJvbSBHaVNUIGludGFycmF5IGluZGV4IHRv IEdJTiBpbnRhcnJheSBpbmRleCwgYnV0IG15PGJyPiZndDsgR0lOIGluZGV4IGlzIG5vdCBiZWlu ZyB1c2VkIGJ5IHRoZSBwbGFubmVyLgo8YnI+Jmd0Ozxicj4mZ3Q7IFRoZSBub3JtYWwgcXVlcnkg aXMgbGlrZSB0aGF0PGJyPiZndDs8YnI+Jmd0OyBzZWxlY3QgKjxicj4mZ3Q7IGZyb20gc291cmNl dGFibGV3aXRoX2ludDQ8YnI+Jmd0OyB3aGVyZSBBUlJBWVtteWludF0gJmx0O0AgbXlpbnRfYXJy YXk8YnI+Jmd0OyZuYnNwOyZuYnNwO2FuZCBzb21lX290aGVyX2ZpbHRlcnM8YnI+Jmd0Ozxicj4m Z3Q7ICh3aXRoIEdpU1QgaW5kZXggZXZlcnl0aGluZyB3b3JrcyBmaW5lLCBidXQgR0lOIGluZGV4 IGlzIG5vdCBiZWluZyB1c2VkKQo8YnI+Jmd0Ozxicj4mZ3Q7IElmIEkgY3JlYXRlIHRoZSBzYW1l IHRhYmxlIHBvcHVsYXRpbmcgaXQgd2l0aCB0ZXh0W10gZGF0YSBsaWtlPGJyPiZndDs8YnI+Jmd0 OyBzZWxlY3QgbXlpbnRfYXJyYXk6OnRleHRbXSBhcyBteWludF9hcnJheV9hc190ZXh0YXJyYXk8 YnI+Jmd0OyBpbnRvIG5ld3RhYmxld2l0aF90ZXh0PGJyPiZndDsgZnJvbSBzb3VyY2V0YWJsZXdp dGhfaW50NDxicj4mZ3Q7Cjxicj4mZ3Q7IGFuZCB0aGVuIGNyZWF0ZSBhIEdJTiBpbmRleCB1c2lu ZyB0aGlzIG5ldyB0ZXh0W10gY29sdW1uPGJyPiZndDs8YnI+Jmd0OyB0aGUgcGxhbm5lciBzdGFy dHMgdG8gdXNlIHRoZSBpbmRleCBhbmQgcXVlcmllcyBydW4gd2l0aCBncmF0ZSBzcGVlZCB3aGVu PGJyPiZndDsgdGhlIHF1ZXJ5IGxvb2tzIGxpa2UgdGhhdDo8YnI+Jmd0Ozxicj4mZ3Q7IHNlbGVj dCAqPGJyPiZndDsgZnJvbSBuZXd0YWJsZXdpdGhfdGV4dAo8YnI+Jmd0OyB3aGVyZSBBUlJBWVsm IzM5O215aW50JiMzOTtdICZsdDtAIG15aW50X2FycmF5X2FzX3RleHRhcnJheTxicj4mZ3Q7Jm5i c3A7Jm5ic3A7YW5kIHNvbWVfb3RoZXJfZmlsdGVyczxicj4mZ3Q7PGJyPiZndDsgV2hlcmUgdGhl IHByb2JsZW0gY2FuIGJlIHdpdGggX2ludDQgR0lOIGluZGV4IGluIHRoaXMgY29uc3RlbGxhdGlv bj88YnI+Jmd0Ozxicj4mZ3Q7IGJ5IG5vdyB0aGUgZW5hYmxlX3NlcXNjYW4gaXMgc2V0IHRvIG9m ZiBpbiB0aGUgY29uZmlndXJhdGlvbi4KPGJyPiZndDs8YnI+Jmd0OyBXaXRoIGJlc3QgcmVnYXJk cyw8YnI+Jmd0Ozxicj4mZ3Q7IC0tIFZhbGVudGluZSBHb2dpY2hhc2h2aWxpPGJyPiZndDs8YnI+ PGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO1JlZ2Fy ZHMsPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO09sZWc8YnI+X19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f Xzxicj5PbGVnIEJhcnR1bm92LCBSZXNlYXJjaCBTY2llbnRpc3QsIEhlYWQgb2YgQXN0cm9OZXQg KAo8YSBocmVmPSJodHRwOi8vd3d3LmFzdHJvbmV0LnJ1Ij53d3cuYXN0cm9uZXQucnU8L2E+KSw8 YnI+U3Rlcm5iZXJnIEFzdHJvbm9taWNhbCBJbnN0aXR1dGUsIE1vc2NvdyBVbml2ZXJzaXR5LCBS dXNzaWE8YnI+SW50ZXJuZXQ6IDxhIGhyZWY9Im1haWx0bzpvbGVnQHNhaS5tc3Uuc3UiPm9sZWdA c2FpLm1zdS5zdTwvYT4sIDxhIGhyZWY9Imh0dHA6Ly93d3cuc2FpLm1zdS5zdS9+bWVnZXJhLyI+ Cmh0dHA6Ly93d3cuc2FpLm1zdS5zdS9+bWVnZXJhLzwvYT48YnI+cGhvbmU6ICswMDcoNDk1KTkz OS0xNi04MywgKzAwNyg0OTUpOTM5LTIzLTgzPGJyPjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PGJy IGNsZWFyPSJhbGwiPjxicj4tLSA8YnI+4YOV4YOQ4YOa4YOU4YOc4YOi4YOY4YOcIOGDkuGDneGD kuGDmOGDqeGDkOGDqOGDleGDmOGDmuGDmDxicj5WYWxlbnRpbmUgR29naWNoYXNodmlsaQo= ------=_Part_104986_3128620.1178717804748--