Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZTtO5-0002nM-3k for pgsql-performance@arkaria.postgresql.org; Mon, 24 Aug 2015 15:10:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZTtO4-0003fv-6F for pgsql-performance@arkaria.postgresql.org; Mon, 24 Aug 2015 15:10:16 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZTtMR-0001nO-14 for pgsql-performance@postgresql.org; Mon, 24 Aug 2015 15:08:35 +0000 Received: from smtp1.cvent.com ([198.207.146.196]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZTtMN-0004Ho-Tk for pgsql-performance@postgresql.org; Mon, 24 Aug 2015 15:08:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cvent.com; i=@cvent.com; q=dns/txt; s=c1211; t=1440428911; x=1471964911; h=from:to:subject:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version; bh=D1UaHhXH/JL8M3C4RkYY/vOrzugMYh5LZzckqEE4Eu0=; b=C1mv+9l9oZh+WYtVLrEa83qhsVf1w5LksuroCvoyKjKVyj+IBrhJEPQM DYlWfwpUUW0zutDdE9JSFZ9OrgO92walCPZak+f8+ZlpAduigBa/w7u3Q a9IZvbjWQwEkahHER/UqbqqsIj4wgyfxja9rQnlhV4FxEZmCO+N+bwslo k=; X-IronPort-AV: E=Sophos;i="5.15,738,1432612800"; d="scan'208";a="52288626" From: "Guo, Yun" To: "pgsql-performance@postgresql.org" Subject: Re: query not using GIN index Thread-Topic: [PERFORM] query not using GIN index Thread-Index: AQHQ3H2vF7PNkAAHqEWqVZEvn//5m54XsjuAgAOSPwA= Date: Mon, 24 Aug 2015 15:08:29 +0000 Message-ID: References: <55D7FC3F.6070104@2ndquadrant.com> In-Reply-To: <55D7FC3F.6070104@2ndquadrant.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.5.3.150624 Content-Type: text/plain; charset="euc-kr" Content-ID: <33204D1955C1794BA87CD53502414ABA@cvent.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -3.4 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org DQoNCkhpIFRvbSwNClRoYW5rcyBmb3IgeW91IHZhbHVhYmxlIGlucHV0Lg0K DQoNCg0KPkhpLA0KPg0KPk9uIDA4LzIyLzIwMTUgMDM6NTUgQU0sIEd1bywg WXVuIHdyb3RlOg0KPj4gSGksDQo+Pg0KPj4gV2UgaGF2ZSBhIHF1ZXJ5IG9u IGEgY29sdW1uIHdpdGggR0lOIGluZGV4LCBidXQgcXVlcnkgcGxhbiBjaG9v c2VzIG5vdA0KPj4gdXNpbmcgdGhlIGluZGV4IGJ1dCBkbyBhbiBzZXEgc2Nh biB3aGljaGkgaXMgbXVzdCBzbG93ZXINCj4+DQo+PiBDUkVBVEUgSU5ERVgg aWR4X2FjY2Vzc19ncmFudHNfb25fYWNjZXNzX3Rva2VucyBPTiBhY2Nlc3Nf Z3JhbnRzIFVTSU5HDQo+PiBnaW4gKGFjY2Vzc190b2tlbnMpOw0KPj4NCj4+ IGV4cGxhaW4gYW5hbHl6ZSBTRUxFQ1QgImFjY2Vzc19ncmFudHMiLiogRlJP TSAiYWNjZXNzX2dyYW50cyIgIFdIRVJFDQo+PiAoYWNjZXNzX3Rva2VucyBA PiBBUlJBWVsnMTI0ZTVhMWY5ZGUzMjVmYzE3NmE3Yzg5MTUyYWM3MzQnXSkg Ow0KPj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0KPj4gDQo+Pi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4+LS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPj4gICBMaW1pdCAgKGNv c3Q9MC4wMC4uNy40NiByb3dzPTEgd2lkdGg9MTU3KSAoYWN0dWFsDQo+PiB0 aW1lPTI2MC4zNzYuLjI2MC4zNzcgcm93cz0xIGxvb3BzPTEpDQo+PiAgICAg LT4gIFNlcSBTY2FuIG9uIGFjY2Vzc19ncmFudHMgIChjb3N0PTAuMDAuLjI5 NzE4LjAzIHJvd3M9Mzk4NQ0KPj4gd2lkdGg9MTU3KSAoYWN0dWFsIHRpbWU9 MjYwLjM3My4uMjYwLjM3MyByb3dzPTEgbG9vcHM9MSkNCj4+ICAgICAgICAg ICBGaWx0ZXI6IChhY2Nlc3NfdG9rZW5zIEA+DQo+PiAnezEyNGU1YTFmOWRl MzI1ZmMxNzZhN2M4OTE1MmFjNzM0fSc6OnRleHRbXSkNCj4+ICAgICAgICAg ICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA3OTY4MTgNCj4+ICAgVG90YWwg cnVudGltZTogMjYwLjQwOCBtcw0KPj4NCj4NCj5JIGZpbmQgaXQgdmVyeSBs aWtlbHkgdGhhdCB0aGUgZXhwbGFpbiBvdXRwdXQgYWN0dWFsbHkgY29tZXMg ZnJvbSBhDQo+c2xpZ2h0bHkgZGlmZmVyZW50IHF1ZXJ5LCBpbmNsdWRpbmcg YSBMSU1JVCAxIGNsYXVzZS4NCg0KIFlvdan2cmUgcmlnaHQsIHRoZSBwbGFu IHdhcyBjb21pbmcgZnJvbQ0KZXhwbGFpbiBhbmFseXplIFNFTEVDVCAiYWNj ZXNzX2dyYW50cyIuKiBGUk9NICJhY2Nlc3NfZ3JhbnRzqfcgV0hFUkUNCihh Y2Nlc3NfdG9rZW5zIEA+IEFSUkFZWycxMjRlNWExZjlkZTMyNWZjMTc2YTdj ODkxNTJhYzczNCddKSBsaW1pdCAxOw0KV2UgdHJpZWQgcmVtb3ZpbmcgImxp bWl0IDGp9ywgd2hpY2ggZGlkIGdpdmUgdXMgdGhlIGJlbmVmaXQgb2YgdXNp bmcgaW5kZXgNCmZvciBzb21ldGltZS4gSG93ZXZlciwgYWZ0ZXIgYSB3aGls ZSwgaXQgd2VudCBiYWNrIHRvIHRoZSBvbGQgYmVoYXZpb3Igb2YNCmlnbm9y aW5nIHRoZSBpbmRleCBmb3IgIiBTRUxFQ1QgImFjY2Vzc19ncmFudHMiLiog RlJPTSAiYWNjZXNzX2dyYW50c6n3DQpXSEVSRSAoYWNjZXNzX3Rva2VucyBA PiBBUlJBWVsnMTI0ZTVhMWY5ZGUzMjVmYzE3NmE3Yzg5MTUyYWM3MzQnXSkg O6n3IC4NCldlIGhhZCB0byB0dXJuIG9mZiBzZXF1ZW50aWFsIHNjYW5zIChl bmFibGVfc2Vxc2NhbikgdG8gZm9yY2UgaXQgdXNlIHRoZQ0KaW5kZXguIEJ1 dCBJqfZtIG5vdCBzdXJlIHRoaXMgc2hvdWxkIGJlIHRoZSBwZXJtYW5lbnQg Zml4Lg0KDQoNCj4NCj5UaGF0IG1pZ2h0IGVhc2lseSBiZSB0aGUgcHJvYmxl bSBoZXJlLCBiZWNhdXNlIHRoZSBvcHRpbWl6ZXIgZXhwZWN0cyB0aGUNCj4z OTg1ICJtYXRjaGVzIiB0byBiZSB1bmlmb3JtbHkgZGlzdHJpYnV0ZWQgaW4g dGhlIHRhYmxlLCBzbyBpdCB0aGlua3MNCj5pdCdsbCBzY2FuIGp1c3QgYSB0 aW55IGZyYWN0aW9uIG9mIHRoZSB0YWJsZSAoMS8zOTg1KSB1bnRpbCB0aGUg Zmlyc3QNCj5tYXRjaC4gQnV0IGl0J3MgcXVpdGUgcG9zc2libGUgYWxsIGF0 IHJvd3MgYXJlIGVuZCBvZiB0aGUgdGFibGUsIGFuZCB0aGUNCj5leGVjdXRv ciBoYXMgdG8gYWN0dWFsbHkgc2NhbiB0aGUgd2hvbGUgdGFibGUuDQo+DQo+ SXQncyBkaWZmaWN1bHQgdG8gc2F5IHdpdGhvdXQgZnVydGhlciBkZXRhaWxz IG9mIHRoZSB0YWJsZSBhbmQgaG93IHRoZQ0KPmRhdGEgYXJlIGdlbmVyYXRl ZC4NCg0KVGhlIGFjY2Vzc19ncmFudHMgdGFibGUgaGFzIDc5NzQxNSByb3dz IGFuZCB0aGUgc2NoZW1hIGFzIGJlbG93Og0KQ29sdW1uIHwgVHlwZSB8DQpN b2RpZmllcnMNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCmlkIHwg aW50ZWdlciB8IG5vdCBudWxsIGRlZmF1bHQNCm5leHR2YWwoJ2FjY2Vzc19n cmFudHNfaWRfc2VxJzo6cmVnY2xhc3MpDQp1c2VyX2lkIHwgaW50ZWdlciB8 IG5vdCBudWxsDQpjb2RlIHwgdGV4dCB8IG5vdCBudWxsDQpjbGllbnRfYXBw bGljYXRpb25fbmFtZSB8IHRleHQgfCBub3QgbnVsbA0KYWNjZXNzX3Rva2Vu cyB8IHRleHRbXSB8IGRlZmF1bHQNCid7fSc6OnRleHRbXQ0KY3JlYXRlZF9h dCB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8IG5vdCBudWxsDQp1 cGRhdGVkX2F0IHwgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIHwgbm90 IG51bGwNCm1vbmdvX2lkIHwgdGV4dCB8DQpJbmRleGVzOg0KImFjY2Vzc19n cmFudHNfcGtleSIgUFJJTUFSWSBLRVksIGJ0cmVlIChpZCkNCiJpbmRleF9h Y2Nlc3NfZ3JhbnRzX29uX2NvZGUiIFVOSVFVRSwgYnRyZWUgKGNvZGUpDQoi aW5kZXhfYWNjZXNzX2dyYW50c19vbl9tb25nb19pZCIgVU5JUVVFLCBidHJl ZSAobW9uZ29faWQpDQoiaWR4X2FjY2Vzc19ncmFudHNfb25fYWNjZXNzX3Rv a2VucyIgZ2luIChhY2Nlc3NfdG9rZW5zKQ0KImluZGV4X2FjY2Vzc19ncmFu dHNfb25fdXNlcl9pZCIgYnRyZWUgKHVzZXJfaWQpDQoNCg0KDQo+DQo+PiBX ZSB0ZXN0ZWQgb24gc21hbGxlciB0YWJsZSBpbiBkZXZlbG9wbWVudCByZWdp b24gYW5kIGl0IGNob29zZXMgdG8gdXNlDQo+PiB0aGUgaW5kZXggdGhlcmUu IEhvd2V2ZXIsIGluIHByb2R1Y3Rpb24gc2l6ZSB0YWJsZSBpdCBkZWNpZGVz IHRvIGlnbm9yZQ0KPj4gdGhlIGluZGV4IGZvciB1bmtub3duIHJlYXNvbnMu DQo+DQo+UGxlYXNlIHByb3ZpZGUgZXhwbGFpbiBvdXRwdXQgZnJvbSB0aGF0 IHRhYmxlLiBJdCdzIGRpZmZpY3VsdCB0byBzYXkNCj53aGF0J3MgZGlmZmVy ZW50IHdpdGhvdXQgc2VlaW5nIHRoZSBkZXRhaWxzLg0KPg0KPkFsc28gcGxl YXNlIHByb3ZpZGUgaW1wb3J0YW50IGRldGFpbHMgYWJvdXQgdGhlIHN5c3Rl bSAoZS5nLiB3aGljaA0KPlBvc3RncmVTUUwgdmVyc2lvbiwgaG93IG11Y2gg UkFNLCB3aGF0IHdvcmtfbWVtL3NoYXJlZF9idWZmZXJzIGFuZCBzdWNoDQo+ c3R1ZmYpLg0KDQpUaGUgYXJyYXkgbGVuZ3RoIGRpc3RyaWJ1dGlvbiBvZiBh Y2Nlc3NfdG9rZW4gaXMgYmVsb3c6DQozMDk5OTcgcm93cyBoYXMgb25seSBv bmUgZWxlbWVudCwgMjQ4MzM0IHJvd3MgaGFzIGVtcHR5IGFycmF5LCA0MzIg cm93cw0KaGFzIGFycmF5IGxlbmd0aCA+MTAwLCBhbmQgMSByb3cgaGFzIGFy cmF5IGxlbmd0aCAzNTc1Lg0KVGhlIHRhYmxlIHNpemUgaXMgMTU0TUIsIGFu ZCB0aGUgaW5kZXggc2l6ZSBpcyAxODBNQi4NCiAgDQoNCkl0qfZzIG9uIEFX UyBkYi5yMy54bGFyZ2UgaW5zdGFuY2Ugd2l0aCA0IHZpcnR1YWwgY29yZXM0 LCBNZW1vcnkzMC41IEdpQiwNCkdlbmVyYWwgcHVycG9zZSBzc2QsIHdpdGgg c2hhcmVkX2J1ZmZlcnMgMTA0ODU3NiBhbmQgd29ya19tZW0gMTU5NzQ0Lg0K DQoNCj4NCj4+IElzIHRoZSBsYXJnZSBudW1iZXIgb2YgdHVwbGVzIHNrZXdp bmcgdGhlIHF1ZXJ5IHBsYW5uZXKhr3MgZGVjaXNpb24NCj4+IG9yIHRoZSBp bmRleCBpdHNlbGYgaXMgbGFyZ2VyIHRoYW4gdGhlIHRhYmxlIHRoZXJlZm9y IGl0IHdvdWxkIGRlY2lkZQ0KPj4gdG8gZG8gdGFibGUgc2Nhbj8NCj4NCj5X aGF0IGxhcmdlIG51bWJlciBvZiB0dXBsZXM/IFRoZSBpbmRleGVzIGFyZSBz dXBwb3NlZCB0byBiZSBtb3JlDQo+ZWZmaWNpZW50IHRoZSBsYXJnZXIgdGhl IHRhYmxlIGlzLg0KPg0KPnJlZ2FyZHMNCj4NCj4tLQ0KPlRvbWFzIFZvbmRy YSAgICAgICAgICAgICAgICAgIGh0dHA6Ly93d3cuMm5kUXVhZHJhbnQuY29t DQo+UG9zdGdyZVNRTCBEZXZlbG9wbWVudCwgMjR4NyBTdXBwb3J0LCBSZW1v dGUgREJBLCBUcmFpbmluZyAmIFNlcnZpY2VzDQo+DQo+DQo+LS0gDQo+U2Vu dCB2aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1w ZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykNCj5UbyBtYWtlIGNoYW5nZXMg dG8geW91ciBzdWJzY3JpcHRpb246DQo+aHR0cDovL3d3dy5wb3N0Z3Jlc3Fs Lm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQ0KDQoKLS0gClNlbnQg dmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVy Zm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5 b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t YWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQo=