[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Unexpected (bad) performance when querying indexed JSONB column
From:       Christian Weyer <christian.weyer () thinktecture ! com>
Date:       2015-02-02 6:31:24
Message-ID: A191183A-AE61-40B7-84C5-355B7A429086 () thinktecture ! com
[Download RAW message or body]

Pj4iQml0bWFwIEhlYXAgU2NhbiBvbiBhcnRpY2xlcyAgKGNvc3Q9MTYuMjUu
LjEzNS42NCByb3dzPTMzIHdpZHRoPTQyNykgDQo+PiAoYWN0dWFsIHRpbWU9
Ni40MjUuLjQzLjYwMyByb3dzPTE4NTg0IGxvb3BzPTEpIg0KPj4gIiAgUmVj
aGVjayBDb25kOiAoZGF0YSBAPiDigJh7ImxvY2tlZCI6IHRydWV9Jzo6anNv
bmIpIg0KPj4gIiAgSGVhcCBCbG9ja3M6IGV4YWN0PTE0OTYiDQo+PiAiICBC
dWZmZXJzOiBzaGFyZWQgaGl0PTE1MDQiDQo+PiAiICAtPiAgQml0bWFwIElu
ZGV4IFNjYW4gb24gaWR4X2RhdGEgIChjb3N0PTAuMDAuLjE2LjI0IHJvd3M9
MzMgDQo+PndpZHRoPTApIA0KPj4gKGFjdHVhbCB0aW1lPTYuMDkwLi42LjA5
MCByb3dzPTE4NTg0IGxvb3BzPTEpIg0KPj4gIiAgICAgICAgSW5kZXggQ29u
ZDogKGRhdGEgQD4g4oCYeyJsb2NrZWQiOiB0cnVlfSc6Ompzb25iKSINCj4+
ICIgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9OCINCj4+ICJQbGFubmlu
ZyB0aW1lOiAwLjM0OCBtcyINCj4+ICJFeGVjdXRpb24gdGltZTogNDcuNzg4
IG1zIg0KPg0KPlNvIHRoYXQncyBzaG93aW5nIGEgcnVudGltZSBvZiA0OCBt
cywgbm90IDkwMC4gIEZvciByZXRyaWV2aW5nIDE4NTg0DQo+cm93cywgZG9l
c24ndCBzb3VuZCB0aGF0IGJhZCB0byBtZS4NCj4NCj4oSWYgdGhlIHBsYW5u
ZXIgaGFkIGhhZCBhIGJldHRlciByb3djb3VudCBlc3RpbWF0ZSwgaXQnZCBs
aWtlbHkgaGF2ZQ0KPm5vdCBib3RoZXJlZCB3aXRoIHRoZSBpbmRleCBhdCBh
bGwgYnV0IGp1c3QgZG9uZSBhIHNlcXNjYW4uICBUaGlzIGlzDQo+YSBjb25z
ZXF1ZW5jZSBvZiB0aGUgbGFjayBvZiBhbnkgdmVyeSB1c2VmdWwgc3RhdHMg
Zm9yIEpTT05CIGNvbHVtbnMsDQo+d2hpY2ggaXMgc29tZXRoaW5nIHdlIGhv
cGUgdG8gYWRkcmVzcyBzb29uOyBidXQgaXQncyBub3QgZG9uZSBpbiA5LjQN
Cj5hbmQgbGlrZWx5IHdvbid0IGJlIGluIDkuNSBlaXRoZXIgLi4uKQ0KPg0K
PgkJCXJlZ2FyZHMsIHRvbSBsYW5lDQoNClRoYW5rcyBmb3IgeW91ciBpbnNp
Z2h0cy4NClRoaXMgZ3JlYXRseSBoZWxwZWQuDQoNCi1DLg0KDQoKLS0gClNl
bnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwt
cGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0
byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y
Zy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQo=
[prev in list] [next in list] [prev in thread] [next in thread]