Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jmFgS-0007RW-O8 for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Jun 2020 11:59:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jmFgR-0001HN-M3 for pgsql-bugs@arkaria.postgresql.org; Fri, 19 Jun 2020 11:59:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jm7l9-0003VQ-EZ for pgsql-bugs@lists.postgresql.org; Fri, 19 Jun 2020 03:32:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jm7l5-0007RC-Rh for pgsql-bugs@lists.postgresql.org; Fri, 19 Jun 2020 03:32:06 +0000 Content-Type: multipart/mixed; boundary="===============8043899640145160869==" MIME-Version: 1.0 Subject: BUG #16504: Wrapping query in EXISTS() causes sequential scans of tables To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgresql.20.drkshadow@spamgourmet.com Reply-To: postgresql.20.drkshadow@spamgourmet.com, pgsql-bugs@lists.postgresql.org Date: Fri, 19 Jun 2020 03:31:29 +0000 Message-ID: <16504-d8c5d6beb38e8b6e@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8043899640145160869== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjUwNApMb2dnZWQgYnk6ICAgICAgICAgIERyayBTaGFkb3cKRW1haWwg YWRkcmVzczogICAgICBwb3N0Z3Jlc3FsLjIwLmRya3NoYWRvd0BzcGFtZ291cm1ldC5jb20KUG9z dGdyZVNRTCB2ZXJzaW9uOiAxMi4wCk9wZXJhdGluZyBzeXN0ZW06ICAgR2VudG9vCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpJJ20gdHJ5aW5nIHRvIG1pZ3JhdGUgZnJvbSBQb3N0Z3Jlc3FsIDkuNiwg YnV0IHJ1bm5pbmcgaW50byBwZXJmb3JtYW5jZQppc3N1ZXMuDQoNCkluIHRoaXMgY2FzZSwgSSBo YXZlIGEgcXVlcnkgdGhhdCBzZWxlY3RzIGZyb20gYSB0YWJsZSwgam9pbnMgYSB0YWJsZSwgam9p bnMKdGhhdCBzYW1lIHRhYmxlLCBqb2lucyB0aGUgZmlyc3QgdGFibGUsIHBlcmZvcm1zIGEgTk9U CmZpcnN0dGFibGUudmFsdWU9bGFzdHRhYmxlLnZhbHVlIHRvIG1ha2Ugc3VyZSB0aGF0IEknbSBu b3Qgam9pbmluZyBhbiBpdGVtCndpdGggaXRzZWxmLiBUaGVyZSBhcmUgaW5kZXhlcyBmb3IgdGhl IGNvbmRpdGlvbnMgaW4gZWFjaCBqb2luLiBXaGVuIEkgcnVuCnRoaXMgYXMgYSBzZWxlY3QgcXVl cnksIHRoZSBFWFBMQUlOIG91dHB1dCB1c2VzIGluZGV4IHNjYW5zIHRoZSB3aG9sZSB3YXkKdGhy b3VnaC4gV2hlbiBJIFNFTEVDVCBFWElTVFModGhhdHF1ZXJ5KSBGUk9NIGZpcnN0dGFibGUgV0hF UkUgZmlyc3R0YWJsZS5pZApJTiAoMSwyLDMpLCB0aGUgRVhQTEFJTiBvdXRwdXQgc3dpdGNoZXMg dG8gdXNpbmcgc2VxdWVudGlhbCBzY2Fucy4gVGhpcwpkZXN0cm95cyBwZXJmb3JtYW5jZSBvbiB0 aGlzIDMuOG0gcm93IHRhYmxlLg0KDQoNClRoZSByZWFsIGNhc2UsIHdpdGggYSB2aWV3IGFuZCBt dWx0aXBsZSBxdWVyaWVzIGpvaW5lZCB0b2dldGhlciwgdHJ5aW5nIHRvCmRldGVybWluZSBpZiBv bmUgaXRlbSAob3IgaXRzIHByZXZpZXcpIGhhcyBhIHRhZyBhbnl3aGVyZToNCmh0dHBzOi8vd3d3 LmRiLWZpZGRsZS5jb20vZi9lZlNGNEdiUEViQUFVUVdSblJDa0VwLzUNCg0KVGhlIGV4YW1wbGUg Y2FzZSwgd2hlcmUgSSBjb21wYXJlIGFuIEVYSVNUUygpIHRvIGEgZmxhdCBzZWxlY3Q6DQpodHRw czovL3d3dy5kYi1maWRkbGUuY29tL2YvZjk2TFJwSlFGM1ZGR1pvOUVQOG5NbS8wDQoNCj09PT09 PT0NClRoZSBTUUwgZm9yIHRoZSBleGFtcGxlLCBpbiBjYXNlIGRiLWZpZGRsZSBnb2VzIGF3YXkN Cg0KQ1JFQVRFIFRBQkxFIGJveGVzICgNCiAgaXRlbWlkIElOVEVHRVIgUFJJTUFSWSBLRVksDQog IHNpemUgSU5URUdFUiBERUZBVUxUIDAsDQogIG1kNSBDSEFSQUNURVIoMjIpLA0KICBwcmV2b2lk IG9pZCBERUZBVUxUIDAsDQogIHByZXZsb2NhbCBCT09MRUFOIERFRkFVTFQgRkFMU0UNCiApOw0K Q1JFQVRFIElOREVYIHByZXZvaWQgT04gYm94ZXMgKHByZXZvaWQpIFdIRVJFIHByZXZvaWQgPiAw Ow0KQ1JFQVRFIElOREVYIGJveGhhc2ggT04gYm94ZXMoc2l6ZSwgU1VCU1RSKG1kNSwgMSwgMykp Ow0KDQotLSB5b3VyIHByZXZpZXcgaXMgc3RvcmVkIGluIGFub3RoZXIgbG9jYXRpb24uLg0KQ1JF QVRFIFRBQkxFIHByZXZzICgNCiAgaWQgSU5URUdFUiBQUklNQVJZIEtFWSwNCiAgc2l6ZSBJTlRF R0VSIE5PVCBOVUxMLA0KICBtZDUgQ0hBUkFDVEVSKDIyKSBOT1QgTlVMTA0KICAtLSBsb2NhdGlv biBDSEFSQUNURVIuLi4NCiApOw0KQ1JFQVRFIElOREVYIHByZXZoYXNoIE9OIHByZXZzKHNpemUs IFNVQlNUUihtZDUsIDEsIDMpKTsNCg0KLS0gcmF0aW5ncw0KQ1JFQVRFIFRBQkxFIGJveF90YWdz ICgNCiAgc2l6ZSBJTlRFR0VSIE5PVCBOVUxMLA0KICBtZDUgQ0hBUkFDVEVSKDIyKSBOT1QgTlVM TCwNCiAgdmFsdWUgSU5URUdFUiBOT1QgTlVMTA0KICApOw0KQ1JFQVRFIElOREVYIHRhZ2hhc2hl cyBPTiBib3hfdGFncyhzaXplLCBTVUJTVFIobWQ1LCAxLCAzKSk7DQoNCkNSRUFURSBWSUVXIG90 aGVyX2xvY2F0aW9uIEFTDQpTRUxFQ1QgYnhfYS5pdGVtaWQsIGJ4X2EucHJldmxvY2FsIEFTIGxv Y2FsLCBieF9vdGhlcl9hLml0ZW1pZCBBUyBiaXRlbWlkLApidF9hLnZhbHVlDQpmcm9tIGJveGVz IGJ4X2ENCkpPSU4gcHJldnMgcHZfYSBPTiBwdl9hLmlkPShieF9hLnByZXZvaWQpOjpJTlRFR0VS IEFORCBieF9hLnByZXZsb2NhbA0KSk9JTiBwcmV2cyBwdjFfYSBPTiAocHYxX2Euc2l6ZSxTVUJT VFIocHYxX2EubWQ1LCAxLAozKSxwdjFfYS5tZDUpPShwdl9hLnNpemUsIFNVQlNUUihwdl9hLm1k NSwgMSwgMykscHZfYS5tZDUpDQpKT0lOIGJveGVzIGJ4X290aGVyX2EgT04gYnhfb3RoZXJfYS5w cmV2b2lkPShwdjFfYS5pZCk6Om9pZCBBTkQKYnhfb3RoZXJfYS5wcmV2bG9jYWwNCkxFRlQgSk9J TiBib3hfdGFncyBidF9hIE9OIChidF9hLnNpemUsU1VCU1RSKGJ0X2EubWQ1LCAxLCAzKSwKYnRf YS5tZDUpPShwdjFfYS5zaXplLFNVQlNUUihwdjFfYS5tZDUsIDEsIDMpLCBwdjFfYS5tZDUpDQpX SEVSRSBieF9vdGhlcl9hLnByZXZvaWQgPiAwIEFORCBOT1QgYnhfYS5pdGVtaWQgPSBieF9vdGhl cl9hLml0ZW1pZA0KOw0KDQotLSAtLS0tDQotLSBUaGUgZXhhbXBsZXMNCg0KDQpFWFBMQUlOIA0K U0VMRUNUIEVYSVNUUyhzZWxlY3QgMSBGUk9NIG90aGVyX2xvY2F0aW9uIFdIRVJFIGl0ZW1pZD1i b3hlcy5pdGVtaWQpDQpGUk9NIGJveGVzDQpXSEVSRSBib3hlcy5pdGVtaWQgSU4gKDEsMiwzKTsN Cg0KLS0tLQ0KTm90IGNvcHktcGFzdGluZyB0aGUgRVhQTEFJTiBvdXRwdXQsIHRoZSBmaXJzdCBx dWVyeSBoYXMgdHdvIHN1YnBsYW5zLiBUaGUKZmlyc3Qgc3VicGxhbiB1c2VzIGluZGV4ZXMsIGFu ZCB0aGUgc2Vjb25kIHN1YnBsYW4gdXNlcyAgLT4gU2VxIFNjYW4gb24KYm94ZXMgYnhfYV8xIChj b3N0PTAuMDAuLjIyLjEwIHJvd3M9NjA1IHdpZHRoPTgpLg0KDQpUaGUgc2Vjb25kIHF1ZXJ5IGhh cyBubyBzZWNvbmQgc3VicGxhbiwgYW5kIHRoZXJlIGlzIG5vIHNlcXVlbnRpYWwgdGFibGUKc2Nh bi4NCg0KSXQgYXBwZWFycyB0aGVyZSBpcyBhIGJ1ZzogRVhJU1RTKCkgc3VicXVlcmllcyBhcmUg bm90IGhhbmRsZWQgYXMgcGFydCBvZgp0aGUgcXVlcnksIG9yIHBlcmhhcHMgdGhleSdyZSBkb25l IGluIHBhcmFsbGVsIChhdCBleHRyZW1lIGNvc3QpLCBvciBwZXJoYXBzCnNvbWV0aGluZyBlbHNl LiBJbiB0aGlzIGNhc2UsIHRoZXJlJ3Mgbm8gaW5kaWNhdGlvbiBvZiBhIHBhcmFsbGVsIGJyYW5j aCwKYW5kIGBTRVQgbWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVyX2dhdGhlciA9IDA7YCBkb2VzIG5v dCBjaGFuZ2UgdGhlIHBsYW4uCkkndmUgbm90aWNlZCB0aGlzIHByb2JsZW0gYXMgd2VsbCB3aXRo IEpPSU4gKFNFTEVDVC4uLikgc3VicXVlcmllcyAoYnV0IEkKZGlkbid0IG1ha2UgYW4gZXhhbXBs ZSksIHNvIEkgYmVsaWV2ZSB0aGlzIGlzbid0IGFib3V0IEVYSVNUUygpLCBidXQgcmF0aGVyCmFi b3V0IF9hbGxfIHN1YnF1ZXJpZXMgbm93IGJlaW5nIGEgcGVyZm9ybWFuY2UgYmFycmllci4NCg0K QXMgc3VjaCwgSSBjYW4ndCBtaWdyYXRlIGFueXRoaW5nIHdpdGggc3VicXVlcmllcyB0byBQb3N0 Z3JlcyAxMi4gSXMgdGhpcyBhCmJ1Zz8NCg0KDQpFWFBMQUlOIA0KU0VMRUNUIG90aGVyX2xvY2F0 aW9uLmJpdGVtaWQNCkZST00gYm94ZXMNCkpPSU4gb3RoZXJfbG9jYXRpb24gT04gb3RoZXJfbG9j YXRpb24uaXRlbWlkPWJveGVzLml0ZW1pZA0KV0hFUkUgYm94ZXMuaXRlbWlkIElOICgxLDIsMyk7 Cgo= --===============8043899640145160869==--