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 1iPnVJ-0008F4-CX for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Oct 2019 12:55:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iPnVI-0003GC-24 for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Oct 2019 12:55:12 +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 1iPnVH-0003G5-Ql for pgsql-bugs@lists.postgresql.org; Wed, 30 Oct 2019 12:55:11 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iPnVA-0004mq-V2 for pgsql-bugs@lists.postgresql.org; Wed, 30 Oct 2019 12:55:11 +0000 Content-Type: multipart/mixed; boundary="===============1451428983939095354==" MIME-Version: 1.0 Subject: BUG #16089: Index only scan does not happen but expected To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stepya@ukr.net Reply-To: stepya@ukr.net, pgsql-bugs@lists.postgresql.org Date: Wed, 30 Oct 2019 12:54:31 +0000 Message-ID: <16089-89312196238e2c78@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1451428983939095354== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjA4OQpMb2dnZWQgYnk6ICAgICAgICAgIFN0ZXBhbiBZYW5rZXZ5Y2gK RW1haWwgYWRkcmVzczogICAgICBzdGVweWFAdWtyLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjUKT3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgTGludXggcmVsZWFzZSA3LjMuMTYxMSAoQ29y ZSkKRGVzY3JpcHRpb246ICAgICAgICAKCk5vdCBhIHJlYWwgaXNzdWUgYnV0IHJhdGhlciBwZXJm b3JtYW5jZSBsZWFrLg0KVGhlIGlzc3VlIGlzIHJlcHJvZHVjaWJsZSBvbiB0aGUgdmVyc2lvbiAx MS41IGFuZCAxMi4wIGFzIHdlbGwuIA0KU2VlIHNjcmlwdCBvZiBwYXJ0aXRpb25lZCB0YWJsZS4g UGxlYXNlIG5vdGljZSBQSyBhbmQgaW5kZXggY29udGFpbnMKc3RhcnRfZGF0ZV9pZCBhcyBzZWNv bmQgZmllbGQuDQogDQpDUkVBVEUgVEFCTEUgaWYgbm90IGV4aXN0cyBkd2gubDFfc25hcHNob3Rf dGFpbDIgKA0KCWwxX3NuYXBzaG90X2lkIGludDggTk9UIE5VTEwsDQoJc3RhcnRfZGF0ZV9pZCBp bnQ0IE5PVCBOVUxMLA0KCXRyYW5zYWN0aW9uX2lkIGludDggTk9UIE5VTEwsDQoJZXhjaGFuZ2Vf aWQgdmFyY2hhcig2KSBOVUxMLA0KCWluc3RydW1lbnRfaWQgaW50NCBOVUxMLA0KCWJpZF9wcmlj ZSBudW1lcmljKDEyLDQpIE5VTEwsDQoJYXNrX3ByaWNlIG51bWVyaWMoMTIsNCkgTlVMTCwNCgli aWRfcXVhbnRpdHkgaW50OCBOVUxMLA0KCWFza19xdWFudGl0eSBpbnQ4IE5VTEwsDQoJZGF0YXNl dF9pZCBpbnQ0IE5VTEwsDQoJdHJhbnNhY3Rpb25fdGltZSB0aW1lc3RhbXAgTlVMTCwNCglDT05T VFJBSU5UIHBrX2wxX3NuYXBzaG90IFBSSU1BUlkgS0VZIChsMV9zbmFwc2hvdF9pZCwgc3RhcnRf ZGF0ZV9pZCkNCikNClBBUlRJVElPTiBCWSBSQU5HRSAoc3RhcnRfZGF0ZV9pZCk7DQpDUkVBVEUg SU5ERVggaWYgbm90IGV4aXN0cyBsMV9zbmFwc2hvdF90cmFuc2FjdF9kYXRlX2lkeCBPTiAKZHdo LmwxX3NuYXBzaG90X3RhaWwyIFVTSU5HIGJ0cmVlICh0cmFuc2FjdGlvbl9pZCwgc3RhcnRfZGF0 ZV9pZCk7DQoNCg0KQ1JFQVRFIFRBQkxFIHBhcnRpdGlvbnMubDFfc25hcHNob3RfMjAxODA1IFBB UlRJVElPTiBPRgpkd2gubDFfc25hcHNob3RfdGFpbDIgRk9SIFZBTFVFUyBGUk9NICgyMDE4MDUw MSkgVE8gKDIwMTgwNjAxKTsNCkNSRUFURSBUQUJMRSBwYXJ0aXRpb25zLmwxX3NuYXBzaG90XzIw MTgwNiBQQVJUSVRJT04gT0YKZHdoLmwxX3NuYXBzaG90X3RhaWwyIEZPUiBWQUxVRVMgRlJPTSAo MjAxODA2MDEpIFRPICgyMDE4MDcwMSk7DQpDUkVBVEUgVEFCTEUgcGFydGl0aW9ucy5sMV9zbmFw c2hvdF8yMDE4MDcgUEFSVElUSU9OIE9GCmR3aC5sMV9zbmFwc2hvdF90YWlsMiBGT1IgVkFMVUVT IEZST00gKDIwMTgwNzAxKSBUTyAoMjAxODA4MDEpOw0KQ1JFQVRFIFRBQkxFIHBhcnRpdGlvbnMu bDFfc25hcHNob3RfMjAxODA4IFBBUlRJVElPTiBPRgpkd2gubDFfc25hcHNob3RfdGFpbDIgRk9S IFZBTFVFUyBGUk9NICgyMDE4MDgwMSkgVE8gKDIwMTgwOTAxKTsNCkNSRUFURSBUQUJMRSBwYXJ0 aXRpb25zLmwxX3NuYXBzaG90XzIwMTgwOSBQQVJUSVRJT04gT0YKZHdoLmwxX3NuYXBzaG90X3Rh aWwyIEZPUiBWQUxVRVMgRlJPTSAoMjAxODA5MDEpIFRPICgyMDE4MTAwMSk7DQpDUkVBVEUgVEFC TEUgcGFydGl0aW9ucy5sMV9zbmFwc2hvdF8yMDE4MTAgUEFSVElUSU9OIE9GCmR3aC5sMV9zbmFw c2hvdF90YWlsMiBGT1IgVkFMVUVTIEZST00gKDIwMTgxMDAxKSBUTyAoMjAxODExMDEpOw0KQ1JF QVRFIFRBQkxFIHBhcnRpdGlvbnMubDFfc25hcHNob3RfMjAxODExIFBBUlRJVElPTiBPRgpkd2gu bDFfc25hcHNob3RfdGFpbDIgRk9SIFZBTFVFUyBGUk9NICgyMDE4MTEwMSkgVE8gKDIwMTgxMjAx KTsNCkNSRUFURSBUQUJMRSBwYXJ0aXRpb25zLmwxX3NuYXBzaG90XzIwMTgxMiBQQVJUSVRJT04g T0YKZHdoLmwxX3NuYXBzaG90X3RhaWwyIEZPUiBWQUxVRVMgRlJPTSAoMjAxODEyMDEpIFRPICgy MDE5MDEwMSk7DQoNCmkgaGF2ZSBsb2FkZWQgNTAwMDAwIHJvd3Mgd2l0aCBkYXRlX2lkID0gMjAx ODExMTINClJlYWwgdGFibGUgaGFzIDIwLTQwIG1pbGxpb25zIHJlY29yZHMgYSBkYXkuDQoNCkV4 YW1pbmUgcXVlcnkgDQpzZWxlY3Qgc3RhcnRfZGF0ZV9pZCwgY291bnQoc3RhcnRfZGF0ZV9pZCkg YXMgY24NCmZyb20gZHdoLmwxX3NuYXBzaG90X3RhaWwyDQp3aGVyZSBzdGFydF9kYXRlX2lkIGJl dHdlZW4gMjAxODExMTIgYW5kIDIwMTgxMTEyDQpncm91cCBieSBzdGFydF9kYXRlX2lkDQoNClRo ZSBleGVjdXRpb24gcGxhbiBzaG93cyByZWFkaW5nIGZ1bGwgcGFydGl0aW9ucy5sMV9zbmFwc2hv dF8yMDE4MTENCldoeSBkbyB3ZSBuZWVkIHRvIHJlYWQgZGF0YSBmcm9tIHRhYmxlLiANCldlIGhh dmUgYWxsIG5lZWRlZCBpbmZvcm1hdGlvbiBpbiB0aGUgaW5kZXggdGhhdCBpcyBzbWFsbGVyLiAN Ckkgd291bGQgZXhwZWN0IGluZGV4IG9ubHkgc2NhbiAoc29tZXRoaW5nIGxpa2UgT3JhY2xlIHZl cnNpb24gb2YgaW5kZXggZmFzdApmdWxsIHNjYW4gKQoK --===============1451428983939095354==--