Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfKZH-0006qp-MX for pgsql-performance@arkaria.postgresql.org; Fri, 04 Jan 2019 08:11:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gfKZE-0008OP-DI for pgsql-performance@arkaria.postgresql.org; Fri, 04 Jan 2019 08:10:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfKZE-0008OF-3J for pgsql-performance@lists.postgresql.org; Fri, 04 Jan 2019 08:10:56 +0000 Received: from smtp2.iter.org ([193.51.56.8]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gfKZA-0005ah-7A for pgsql-performance@lists.postgresql.org; Fri, 04 Jan 2019 08:10:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iter.org; l=5248; q=dns/txt; s=20170425; t=1546589452; x=1547194252; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=P6+dPhe606eU2Wv63vg1z2xVR1TgRaX0zKJJwrlOL4A=; b=PgFXkxLncOmQigWPX9KYodPFFlm9uIRT4Jd2kIAXnlSUpXGq1oyo2nip TP1zFhh2WiGGBuB1eDanbK2vEdEo3+GgC31QabcJVd1Fax+e3+2vk8LI1 uuWXBqW0RZ2k/GRClf0IKb791Rvx0zVcUiq1o/G7Uwghn3mQCPqPDQzok 0=; Received: from XCH-CLU1N3.iter.org (10.10.242.164) by XCH-CLU1N4.iter.org (10.10.243.164) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1261.35; Fri, 4 Jan 2019 09:10:44 +0100 Received: from XCH-CLU1N3.iter.org ([fe80::f903:4e8a:c365:4c74]) by XCH-CLU1N3.iter.org ([fe80::f903:4e8a:c365:4c74%16]) with mapi id 15.01.1261.036; Fri, 4 Jan 2019 09:10:44 +0100 From: Abadie Lana To: David Rowley CC: "pgsql-performance@lists.postgresql.org" Subject: RE: select query does not pick up the right index Thread-Topic: select query does not pick up the right index Thread-Index: AdSitwt5/9TyB7hoTX++E94tUlkiMgAOgIkAABh1BzAAAkhrgAACgegQ///wggD//+6z4IAAnmMA//9HxzA= Date: Fri, 4 Jan 2019 08:10:44 +0000 Message-ID: References: <49406fb0c239480980ffc6c2a250d4e9@iter.org> <438dcc57f91d4a9fab12ae4078592d69@iter.org> In-Reply-To: Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.14.32.57] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk DQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogRGF2aWQgUm93bGV5IDxkYXZpZC5y b3dsZXlAMm5kcXVhZHJhbnQuY29tPiANClNlbnQ6IDAzIEphbnVhcnkgMjAxOSAyMjo0Mg0KVG86 IEFiYWRpZSBMYW5hIDxMYW5hLkFiYWRpZUBpdGVyLm9yZz4NCkNjOiBwZ3NxbC1wZXJmb3JtYW5j ZUBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IHNlbGVjdCBxdWVyeSBkb2VzIG5v dCBwaWNrIHVwIHRoZSByaWdodCBpbmRleA0KDQpPbiBGcmksIDQgSmFuIDIwMTkgYXQgMDI6MjAs IEFiYWRpZSBMYW5hIDxMYW5hLkFiYWRpZUBpdGVyLm9yZz4gd3JvdGU6DQo+ID4gRnJvbTogRGF2 aWQgUm93bGV5IDxkYXZpZC5yb3dsZXlAMm5kcXVhZHJhbnQuY29tPg0KPiA+IFNlbnQ6IDAzIEph bnVhcnkgMjAxOSAxNDowMQ0KPiBSaWdodCwgc28geW91IG5lZWQgdG8gY2hlY2sgeW91ciBpbmRl eGVzIG9uIHNhbXBsZV9jdHJsX3llYXIgYW5kIHNhbXBsZV9idWlsX3llYXIuIFlvdSBuZWVkIGFu IGluZGV4IG9uIChjaGFubmVsX2lkLCBzbXBsX3RpbWUpIG9uIHRob3NlLg0KDQo+IFRoZXNlIGlu ZGV4ZXMgZXhpc3QgYWxyZWFkeQ0KDQpUaGF0J3MgaW50ZXJlc3RpbmcuIFRoZSBcZCBvdXRwdXQg aW5kaWNhdGVzIHRoYXQgdGhlIGluZGV4ZXMgYXJlIG5vdCBJTlZBTElELCBzbyBpdCdzIG5vdCBh bGwgdGhhdCBvYnZpb3VzIHdoeSB0aGUgcGxhbm5lciB3b3VsZCBjaG9vc2UgYSBsZXNzZXIgaW5k ZXggdG8gcHJvdmlkZSB0aGUgcmVxdWlyZWQgcm93cy4gT25lIHRob3VnaHQgaXMgdGhhdCB0aGUg bW9yZSBzdWl0YWJsZSBpbmRleCBpcyB2ZXJ5IGJsb2F0ZWQuICBUaGlzIHdvdWxkIGluY3JlYXNl IHRoZSBlc3RpbWF0ZWQgY29zdCBvZiBzY2FubmluZyB0aGUgaW5kZXggYW5kIHJlZHVjZSB0aGUg Y2hhbmNlcyBvZiB0aGUgaW5kZXggYmVpbmcgc2VsZWN0ZWQgYnkgdGhlIHF1ZXJ5IHBsYW5uZXIu DQoNCklmIHlvdSBleGVjdXRlOg0KDQpzZWxlY3QgaW5kcmVsaWQ6OnJlZ2NsYXNzIGFzIHRhYmxl X25hbWUsIGluZGV4cmVsaWQ6OlJlZ2NsYXNzIGFzDQppbmRleF9uYW1lLHBnX3NpemVfcHJldHR5 KHBnX3JlbGF0aW9uX3NpemUoaW5kcmVsaWQpKQ0KdGFibGVfc2l6ZSxwZ19zaXplX3ByZXR0eShw Z19yZWxhdGlvbl9zaXplKGluZGV4cmVsaWQpKSBpbmRleF9zaXplIGZyb20gcGdfaW5kZXggd2hl cmUgaW5kcmVsaWQgaW4oJ3NhbXBsZV9jdHJsX3llYXInOjpyZWdjbGFzcywgJ3NhbXBsZV9idWls X3llYXInOjpyZWdjbGFzcykgb3JkZXIgYnkgaW5kcmVsaWQ6OnJlZ2NsYXNzOjpuYW1lLCBpbmRl eHJlbGlkOjpyZWdjbGFzczo6bmFtZTsNCg0KVGhpcyBzaG91bGQgc2hvdyB5b3UgdGhlIHNpemUg b2YgdGhlIHRhYmxlcyBhbmQgaW5kZXhlcyBpbiBxdWVzdGlvbi4NCklmIHRoZSBzYW1wbGVfdGlt ZV9jeV9pZHggYW5kIHNhbXBsZV90aW1lX2J5X2lkeCBpbmRleGVzIGFyZSB2ZXJ5IGxhcmdlIHdo ZW4gY29tcGFyZWQgd2l0aCB0aGUgc2l6ZSBvZiB0aGVpciB0YWJsZSwgdGhlbiBpdCBpcyBsaWtl bHkgd29ydGggYnVpbGRpbmcgYSBuZXcgaW5kZXggZm9yIHRoZXNlIHRoZW4gZHJvcHBpbmcgdGhl IG9sZCBpbmRleCB0aGVuIHJldHJ5aW5nIHRoZSByZS13cml0dGVuIHZlcnNpb24gb2YgdGhlIHF1 ZXJ5LiAgSWYgdGhpcyBpcyBhIGxpdmUgc3lzdGVtIHRoZW4geW91IGNhbiBidWlsZCB0aGUgbmV3 IGluZGV4ZXMgYnkgdXNpbmcgdGhlIENSRUFURSBJTkRFWCBDT05DVVJSRU5UTFkgY29tbWFuZC4g IFRoaXMgd2lsbCBhbGxvdyBvdGhlciBETUwgb3BlcmF0aW9ucyB0byB3b3JrIHdpdGhvdXQgYmVp bmcgYmxvY2tlZC4gVGhlIG9sZCBpbmRleGVzIGNhbiB0aGVuIGJlIGRyb3BwZWQgd2l0aCBEUk9Q IElOREVYIENPTkNVUlJFTlRMWS4NCg0KLS0gDQogRGF2aWQgUm93bGV5ICAgICAgICAgICAgICAg ICAgIGh0dHA6Ly93d3cuMm5kUXVhZHJhbnQuY29tLw0KIFBvc3RncmVTUUwgRGV2ZWxvcG1lbnQs IDI0eDcgU3VwcG9ydCwgVHJhaW5pbmcgJiBTZXJ2aWNlcw0KDQpIZXJlIHRoZSByZXN1bHQuLi5G b3IgbWUgaXQgZG9lcyBub3Qgc291bmQgdGhhdCBpdCBpcyBibG9hdGVkLi4uQWxzbyBzdGlsbCBh IG15c3Rlcnkgd2h5IHdyb25nIGluZGV4ZXMgYXJlIHBpY2tlZCB1cCBmb3IgYnVpbCBhbmQgY3Ry bCBhbmQgbm90IGZvciB1dGlsLi4uDQoNCnNlbGVjdCBpbmRyZWxpZDo6cmVnY2xhc3MgYXMgdGFi bGVfbmFtZSwgaW5kZXhyZWxpZDo6UmVnY2xhc3MgYXMNCmluZGV4X25hbWUscGdfc2l6ZV9wcmV0 dHkocGdfcmVsYXRpb25fc2l6ZShpbmRyZWxpZCkpDQp0YWJsZV9zaXplLHBnX3NpemVfcHJldHR5 KHBnX3JlbGF0aW9uX3NpemUoaW5kZXhyZWxpZCkpIGluZGV4X3NpemUgZnJvbSBwZ19pbmRleCB3 aGVyZSBpbmRyZWxpZCBpbignc2FtcGxlX2N0cmxfeWVhcic6OnJlZ2NsYXNzLCAnc2FtcGxlX2J1 aWxfeWVhcic6OnJlZ2NsYXNzLCdzYW1wbGVfdXRpbF95ZWFyJzo6cmVnY2xhc3MpIG9yZGVyIGJ5 IGluZHJlbGlkOjpyZWdjbGFzczo6bmFtZSwgaW5kZXhyZWxpZDo6cmVnY2xhc3M6Om5hbWU7DQog ICAgdGFibGVfbmFtZSAgICB8ICAgICBpbmRleF9uYW1lICAgICAgfCB0YWJsZV9zaXplIHwgaW5k ZXhfc2l6ZQ0KLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tDQogc2FtcGxlX2J1aWxfeWVhciB8IHNhbXBsZV90aW1lX2J5X2lk eCAgfCA0NDkyIE1CICAgIHwgMTUyMiBNQg0KIHNhbXBsZV9idWlsX3llYXIgfCBzYW1wbGVfdGlt ZV95YjFfaWR4IHwgNDQ5MiBNQiAgICB8IDE1MjIgTUINCiBzYW1wbGVfYnVpbF95ZWFyIHwgc21w bF90aW1lX2J4Ml9pZHggICB8IDQ0OTIgTUIgICAgfCAxMDg0IE1CDQogc2FtcGxlX2N0cmxfeWVh ciB8IHNhbXBsZV90aW1lX2N5X2lkeCAgfCA3MDY1IE1CICAgIHwgMjM5NCBNQg0KIHNhbXBsZV9j dHJsX3llYXIgfCBzYW1wbGVfdGltZV95YzFfaWR4IHwgNzA2NSBNQiAgICB8IDIzOTQgTUINCiBz YW1wbGVfY3RybF95ZWFyIHwgc21wbF90aW1lX2NteDJfaWR4ICB8IDcwNjUgTUIgICAgfCAxNzA1 IE1CDQogc2FtcGxlX3V0aWxfeWVhciB8IHNhbXBsZV90aW1lX3V5X2lkeCAgfCA3MTQwIE1CICAg IHwgMjQyNiBNQg0KIHNhbXBsZV91dGlsX3llYXIgfCBzYW1wbGVfdGltZV95dTFfaWR4IHwgNzE0 MCBNQiAgICB8IDI0MjYgTUINCiBzYW1wbGVfdXRpbF95ZWFyIHwgc21wbF90aW1lX3V4Ml9pZHgg ICB8IDcxNDAgTUIgICAgfCAxNzI3IE1CDQooOSByb3dzKQ0KDQpJIGhhdmUgcmVjcmVhdGVkIHRo ZSBpbmRleGVzIGZvciBzYW1wbGVfY3RybF95ZWFyIGFuZCBzYW1wbGVfYnVpbF95ZWFyIGFuZCBz YW1lIGluZGV4IHNpemUuDQpJIHJlcnVuIHRoZSBxdWVyeS4uLiBhbmQgc3RpbGwgdGhlIHNhbWUg cGxhbiBleGVjdXRpb24gYXMgcHJldmlvdXNseSBzZW50Li4uLg0KVGhhbmtzIGZvciB5b3VyIHN1 cHBvcnQuLi5PbmUgdGhpbmcgSSBzcG90IGlzIHRoZSBJL08gb24gdGhpcyBtYWNoaW5lIGlzIHJh dGhlciBzbG93Li4uIHRoZSB2ZXJ5IGZpcnN0IHRpbWUgSSBydW4gdGhpcyBxdWVyeSBpdCB3aWxs IHRha2UgRXhlY3V0aW9uIHRpbWU6IDI0NzUwMy4wMDYgbXMgKCBJIGNhbiBzZWUgdGhhdCBwb3N0 Z3JlcyBwcm9jZXNzIGlzIGluIHN0YXRlIEQgYW5kIGxvdyBDUFUuLi4sdXNpbmcgaW90b3AgSSBj YW4gc2VlIEkvTyByZWFkIHNwZWVkIGNhbm5vdCBnbyBiZXlvbmQgMjBNQi9zZWMuIFRoZSBzZWNv bmQgdGltZSBJIHJ1biB0aGUgcXVlcnksIHRoZSBDUFUgZ29lcyB1cCB0byAxMDAlLCBubyBEIHN0 YXRlKS4NCg0KDQoNCg0K