Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YI27J-0002oV-Kc for pgsql-performance@arkaria.postgresql.org; Sun, 01 Feb 2015 21:31:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YI27I-0002HK-Tp for pgsql-performance@arkaria.postgresql.org; Sun, 01 Feb 2015 21:31:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YI27G-0002HB-Nr for pgsql-performance@postgresql.org; Sun, 01 Feb 2015 21:31:38 +0000 Received: from mail-am1on0611.outbound.protection.outlook.com ([2a01:111:f400:fe00::611] helo=emea01-am1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YI278-0006hB-Cy for pgsql-performance@postgresql.org; Sun, 01 Feb 2015 21:31:36 +0000 Received: from AMSPR03MB518.eurprd03.prod.outlook.com (10.242.19.153) by AMSPR03MB519.eurprd03.prod.outlook.com (10.242.19.154) with Microsoft SMTP Server (TLS) id 15.1.75.20; Sun, 1 Feb 2015 21:19:30 +0000 Received: from AMSPR03MB518.eurprd03.prod.outlook.com ([10.242.19.153]) by AMSPR03MB518.eurprd03.prod.outlook.com ([10.242.19.153]) with mapi id 15.01.0075.002; Sun, 1 Feb 2015 21:19:30 +0000 From: Christian Weyer To: Josh Berkus , "pgsql-performance@postgresql.org" Subject: Re: Unexpected (bad) performance when querying indexed JSONB column Thread-Topic: [PERFORM] Unexpected (bad) performance when querying indexed JSONB column Thread-Index: AQHQPYh+MPtYv9v9GUulrT5Ss+d0jZzcStTlgAAUZYA= Date: Sun, 1 Feb 2015 21:19:29 +0000 Message-ID: References: <7F9BEAD7-C190-4E21-8240-04687FA88435@thinktecture.com> <54CE954F.7070904@agliodbs.com> In-Reply-To: <54CE954F.7070904@agliodbs.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/15.6.0.150113 x-originating-ip: [84.174.125.68] authentication-results: agliodbs.com; dkim=none (message not signed) header.d=none; x-microsoft-antispam: BCL:0;PCL:0;RULEID:;SRVR:AMSPR03MB519; x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:;SRVR:AMSPR03MB519; x-forefront-prvs: 04740D25F1 x-forefront-antispam-report: SFV:NSPM; SFS:(10009020)(6009001)(52604005)(51704005)(24454002)(87936001)(107886001)(106116001)(92566002)(36756003)(19580405001)(82746002)(50986999)(83506001)(54356999)(19580395003)(16601075003)(46102003)(2900100001)(83716003)(66066001)(40100003)(2656002)(76176999)(15975445007)(33656002)(2950100001)(77096005)(86362001)(102836002)(77156002)(122556002)(62966003); DIR:OUT; SFP:1101; SCL:1; SRVR:AMSPR03MB519; H:AMSPR03MB518.eurprd03.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; Content-Type: text/plain; charset="utf-8" Content-ID: <15AC75CAFCF4C6488E2154C06CE84AA2@eurprd03.prod.outlook.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: thinktecture.com X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2015 21:19:29.8022 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: ed1f07e9-ad7c-4ea4-842e-2e16ed4db6e9 X-MS-Exchange-Transport-CrossTenantHeadersStamped: AMSPR03MB519 X-Pg-Spam-Score: -1.9 (-) 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 T24gMDEuMDIuMTUgMjI6MDYsICJKb3NoIEJlcmt1cyIgPGpvc2hAYWdsaW9k YnMuY29tPiB3cm90ZToNCg0KDQoNCj5QbGVhc2Ugc2VuZCB1cyB0aGUgb3V0 cHV0IG9mIEVYUExBSU4gKCBBTkFMWVpFIE9OLCBCVUZGRVJTIE9OICkgc28g dGhhdA0KPndlIGNhbiBzZWUgd2hhdCB0aGUgcXVlcnkgaXMgYWN0dWFsbHkg ZG9pbmcsIHJhdGhlciB0aGFuIGp1c3Qgd2hhdCB0aGUNCj5wbGFuIHdhcy4N Cj4NCj4tLSANCj5Kb3NoIEJlcmt1cw0KPlBvc3RncmVTUUwgRXhwZXJ0cyBJ bmMuDQo+aHR0cDovL3BnZXhwZXJ0cy5jb20NCg0KDQpTdXJlLiBIZXJlIHdl IGdvOg0KDQoiQml0bWFwIEhlYXAgU2NhbiBvbiBhcnRpY2xlcyAgKGNvc3Q9 MTYuMjUuLjEzNS42NCByb3dzPTMzIHdpZHRoPTQyNykgDQooYWN0dWFsIHRp bWU9Ni40MjUuLjQzLjYwMyByb3dzPTE4NTg0IGxvb3BzPTEpIg0KIiAgUmVj aGVjayBDb25kOiAoZGF0YSBAPiDigJh7ImxvY2tlZCI6IHRydWV9Jzo6anNv bmIpIg0KIiAgSGVhcCBCbG9ja3M6IGV4YWN0PTE0OTYiDQoiICBCdWZmZXJz OiBzaGFyZWQgaGl0PTE1MDQiDQoiICAtPiAgQml0bWFwIEluZGV4IFNjYW4g b24gaWR4X2RhdGEgIChjb3N0PTAuMDAuLjE2LjI0IHJvd3M9MzMgd2lkdGg9 MCkgDQooYWN0dWFsIHRpbWU9Ni4wOTAuLjYuMDkwIHJvd3M9MTg1ODQgbG9v cHM9MSkiDQoiICAgICAgICBJbmRleCBDb25kOiAoZGF0YSBAPiDigJh7Imxv Y2tlZCI6IHRydWV9Jzo6anNvbmIpIg0KIiAgICAgICAgQnVmZmVyczogc2hh cmVkIGhpdD04Ig0KIlBsYW5uaW5nIHRpbWU6IDAuMzQ4IG1zIg0KIkV4ZWN1 dGlvbiB0aW1lOiA0Ny43ODggbXMiDQoNCg0KVGhhbmtzIGZvciBsb29raW5n IGludG8gdGhpcy4NCg0KLUMuDQoNCgotLSAKU2VudCB2aWEgcGdzcWwtcGVy Zm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0 Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0 aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs LXBlcmZvcm1hbmNlCg==