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 1leHz0-0004Uz-2z for pgsql-bugs@arkaria.postgresql.org; Wed, 05 May 2021 13:54:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1leHyy-0003cK-Pw for pgsql-bugs@arkaria.postgresql.org; Wed, 05 May 2021 13:54:32 +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 1leHWb-0007L8-II for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 13:25:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1leHWU-0006Tl-LA for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 13:25:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sQzZMuPI08cgilKbkqrH5P2szn6z9Y9E897J4alWuQ0=; b=gcUyGvyeR73/Em0hjTnGFY9TcH ym8DWt7pq15hgYQ//Xqi7obLbrQjwZwDCt6wtMHcmv7EOu3jIam5H/QH7kZ/GbhgJC6Q0cfoyvXv2 FvxEWucF4N7wCxUAS2oKXxXzxLFM8Geybn20dR44aNLjqsPbv3kotgpPOKJ6t/J6uBWSCpRKb1Xxo EKnq03tRF8VaMTDFqguDZxNIkq8nXlQCasHjAVtVVt3dL6MuaKfZcHZXsiNQkDT1olxT+Z13ZbsXP UdfHokwW1MNROdDV+HvFMylCMwxxwIacltf1vzyOV6ufLDMsKJNdS6c64G6WMuli446ctVsk2jRYJ nAqZZnig==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1leHWS-00047Z-V1 for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 13:25:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1leHWQ-0003YX-8i for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 13:25:02 +0000 Content-Type: multipart/mixed; boundary="===============6045357557596841878==" MIME-Version: 1.0 Subject: BUG #16993: Query Planner does not use index for EXISTS-query on a large table with all equal foreign key values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: a.schnabl@synedra.com Reply-To: a.schnabl@synedra.com, pgsql-bugs@lists.postgresql.org Date: Wed, 05 May 2021 13:24:05 +0000 Message-ID: <16993-1298e8dc9c41ab97@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6045357557596841878== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk5MwpMb2dnZWQgYnk6ICAgICAgICAgIEEgU2NobmFibApFbWFpbCBh ZGRyZXNzOiAgICAgIGEuc2NobmFibEBzeW5lZHJhLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEz LjIKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpI ZWxsbywNCg0KSSBjYW4gcmVwcm9kdWNlIGEgcXVlcnkgcGxhbm5lciBwcm9ibGVtIG9uIGEgZnJl c2ggZGVmYXVsdCBpbnN0YWxsYXRpb24gb2YKcG9zdGdyZXMtMTMuMiBvbiBteSBXaW5kb3dzIDEw IG1hY2hpbmUuIEkgYWxzbyBzYXcgaXQgb2NjdXIgb24gb24KcG9zdGdyZXMtMTIuNiBpbnN0YWxs YXRpb25zIG9uIFdpbmRvd3MgMTAgYW5kIENlbnRPUyA4LiBJIHVzZWQgdGhlIGZvbGxvd2luZwp0 YWJsZSBzZXR1cDoNCg0KQ1JFQVRFIFRBQkxFIGRhdGFfbm9kZSAoaWQgQklHSU5UIFBSSU1BUlkg S0VZKTsNCkNSRUFURSBUQUJMRSBkYXRhX2VudHJ5IChpZCBCSUdJTlQgUFJJTUFSWSBLRVksIG5v ZGVfZmsgQklHSU5UIE5PVCBOVUxMLApGT1JFSUdOIEtFWSAobm9kZV9maykgUkVGRVJFTkNFUyBk YXRhX25vZGUgKGlkKSk7DQpDUkVBVEUgSU5ERVggbm9kZV9peCBPTiBkYXRhX2VudHJ5IFVTSU5H IEJUUkVFIChub2RlX2ZrKTsNCklOU0VSVCBJTlRPIGRhdGFfbm9kZSAoaWQpIFNFTEVDVCBnZW5l cmF0ZV9zZXJpZXMoMSwxMCk7DQpJTlNFUlQgSU5UTyBkYXRhX2VudHJ5IChpZCwgbm9kZV9maykg U0VMRUNUIHMsIDIgRlJPTQpnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMDAwMCkgczsNClZBQ1VVTSBB TkFMWVpFIGRhdGFfbm9kZTsNClZBQ1VVTSBBTkFMWVpFIGRhdGFfZW50cnk7DQoNCldpdGggdGhl IGZvbGxvd2luZyBxdWVyeSwgSSBmaWx0ZXIgYWxsIGVudHJpZXMgb2YgdGhlIGRhdGFfbm9kZSB0 YWJsZSAob25seQphIHNpbmdsZSB3aXRoIHRoZSBkYXRhIGdpdmVuIGhlcmUpIHdoaWNoIGFyZSBy ZWZlcmVuY2VkIGJ5IHRoZSBkYXRhX2VudHJ5CnRhYmxlOg0KDQpTRUxFQ1QgKiBGUk9NIGRhdGFf bm9kZQ0KV0hFUkUgRVhJU1RTICgNCiBTRUxFQ1QgMSBGUk9NIGRhdGFfZW50cnkgV0hFUkUgbm9k ZV9mayA9IGRhdGFfbm9kZS5pZA0KKTsNCg0KVGhlIHF1ZXJ5IHRha2VzIGEgZmV3IHNlY29uZHMg dG8gY29tcGxldGUsIGFsdGhvdWdoIEkgZXhwZWN0IGl0IHRvIGJlIG11Y2gKZmFzdGVyIChhcyBz aG93biBiZWxvdywgaXQgY2FuIGJlIHBlcmZvcm1lZCBpbiBsZXNzIHRoYW4gYSBtaWxsaXNlY29u ZCkgZHVlCnRvIHRoZSBub2RlX2l4IGluZGV4LiBFWFBMQUlOIEFOQUxZWkUgc2hvd3MgdGhlIGZv bGxvd2luZyBxdWVyeSBwbGFuOg0KDQpNZXJnZSBKb2luICAoY29zdD0xNzkwNTMuNDEuLjE3OTA1 NC4yNCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTIxNDAuODIwLi4yMTQwLjgyMiByb3dz PTEgbG9vcHM9MSkNCiAgTWVyZ2UgQ29uZDogKGRhdGFfbm9kZS5pZCA9IGRhdGFfZW50cnkubm9k ZV9maykNCiAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBkYXRhX25vZGVfcGtleSBvbiBkYXRh X25vZGUgIChjb3N0PTAuMTQuLjguMjkKcm93cz0xMCB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4w MDYuLjAuMDEwIHJvd3M9MyBsb29wcz0xKQ0KICAgICAgICBIZWFwIEZldGNoZXM6IDANCiAgLT4g IFNvcnQgIChjb3N0PTE3OTA1My4yNy4uMTc5MDUzLjI4IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFs CnRpbWU9MjE0MC44MDUuLjIxNDAuODA2IHJvd3M9MSBsb29wcz0xKQ0KICAgICAgICBTb3J0IEtl eTogZGF0YV9lbnRyeS5ub2RlX2ZrDQogICAgICAgIFNvcnQgTWV0aG9kOiBxdWlja3NvcnQgIE1l bW9yeTogMjVrQg0KICAgICAgICAtPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MTc5MDUzLjI1Li4x NzkwNTMuMjYgcm93cz0xIHdpZHRoPTgpCihhY3R1YWwgdGltZT0yMTQwLjc5Ni4uMjE0MC43OTYg cm93cz0xIGxvb3BzPTEpDQogICAgICAgICAgICAgIEdyb3VwIEtleTogZGF0YV9lbnRyeS5ub2Rl X2ZrDQogICAgICAgICAgICAgIEJhdGNoZXM6IDEgIE1lbW9yeSBVc2FnZTogMjRrQg0KICAgICAg ICAgICAgICAtPiAgU2VxIFNjYW4gb24gZGF0YV9lbnRyeSAgKGNvc3Q9MC4wMC4uMTU0MDUzLjYw IHJvd3M9OTk5OTg2MAp3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMzYuLjk3My4zNzYgcm93cz0x MDAwMDAwMCBsb29wcz0xKQ0KUGxhbm5pbmcgVGltZTogMC4xOTIgbXMNCkV4ZWN1dGlvbiBUaW1l OiAyMTQwLjg3MyBtcw0KDQpOb3RlIHRoYXQgYSBzZXF1ZW50aWFsIHNjYW4gc2NhbiBvbiBkYXRh X2VudHJ5IGlzIHVzZWQgaGVyZSByYXRoZXIgdGhhbiBzb21lCmluZGV4IChvbmx5KSBzY2FucyBv biBub2RlX2l4LiBJZiBJDQoNClNFVCBlbmFibGVfc2Vxc2NhbiA9IGZhbHNlOw0KDQphbmQgRVhQ TEFJTiBBTkFMWVpFIHRoZSBxdWVyeSBhZ2FpbiwgSSBnZXQgdGhlIGZvbGxvd2luZyByZXN1bHQ6 DQoNCk5lc3RlZCBMb29wIFNlbWkgSm9pbiAgKGNvc3Q9MC41Ny4uMTIuODUgcm93cz0xIHdpZHRo PTgpIChhY3R1YWwKdGltZT0wLjg3Ny4uMC45MjAgcm93cz0xIGxvb3BzPTEpDQogIC0+ICBJbmRl eCBPbmx5IFNjYW4gdXNpbmcgZGF0YV9ub2RlX3BrZXkgb24gZGF0YV9ub2RlICAoY29zdD0wLjE0 Li44LjI5CnJvd3M9MTAgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDA2Li4wLjAxMSByb3dzPTEw IGxvb3BzPTEpDQogICAgICAgIEhlYXAgRmV0Y2hlczogMA0KICAtPiAgSW5kZXggT25seSBTY2Fu IHVzaW5nIG5vZGVfaXggb24gZGF0YV9lbnRyeSAgKGNvc3Q9MC40My4uMTc4MTQzLjk4CnJvd3M9 OTk5OTg2MCB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wODkuLjAuMDg5IHJvd3M9MCBsb29wcz0x MCkNCiAgICAgICAgSW5kZXggQ29uZDogKG5vZGVfZmsgPSBkYXRhX25vZGUuaWQpDQogICAgICAg IEhlYXAgRmV0Y2hlczogMA0KUGxhbm5pbmcgVGltZTogMC4zMjggbXMNCkV4ZWN1dGlvbiBUaW1l OiAwLjk1OSBtcw0KDQpEdWUgdG8gdGhlIGh1Z2UgcGVyZm9ybWFuY2UgZ2FwIGJldHdlZW4gdGhl IHBsYW5zLCBJIHRoaW5rIHRoYXQgdGhlIHF1ZXJ5CnBsYW5uZXIgc2hvdWxkIHVzZSB0aGUgbm9k ZV9peCBpbmRleCBoZXJlIGV2ZW4gd2l0aG91dCBlbmFibGVfc2Vxc2NhbiBiZWluZwpzZXQgdG8g ZmFsc2UuCgo= --===============6045357557596841878==--