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 1q6ZnN-0006PN-RJ for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Jun 2023 16:44: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 1q6ZnM-00033V-N2 for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Jun 2023 16:44:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q6UgW-0007et-D3 for pgsql-bugs@lists.postgresql.org; Tue, 06 Jun 2023 11:17:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q6UgT-000WEb-E9 for pgsql-bugs@lists.postgresql.org; Tue, 06 Jun 2023 11:17:07 +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=26AJJWkVyqTDpzkuUQdp6LY/MzaqmInlC9FAGPxWolg=; b=SBrH4kWTD+l2ds+/SaJTDKq6Pz cMrWcWGDjmM3L3D/Nd4cZtPvDFPZsRp0nnHkxf9W78oy/vJT1jVckUkWmRd+mQJhfziy1NI/kXKtq i5MvZrsb/5g0Miid49PP02u6tvHOQHxjDelCSOD3WiqZqBGEQgZwLyYE2rEAGQlxWIrRMeiuwq+6H QbqsqEIyuZqzDwnwWFQuzdqPNLFuzWWw5WbLZxeZAmOf6WIRlo2NePY2YgOWKhiM5zRpM5zSoJjdN IxDz3wT82beXmnwGY+uq2yKa9KbjTlqYOFq4aaQHfcIZQSpAT9yjMgRDTThr9q5S0FuP0kNp/5SCt vCaQ6TTw==; 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 1q6UgS-0004g6-PQ for pgsql-bugs@lists.postgresql.org; Tue, 06 Jun 2023 11:17:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1q6UgP-001Xlo-2x for pgsql-bugs@lists.postgresql.org; Tue, 06 Jun 2023 11:17:02 +0000 Content-Type: multipart/mixed; boundary="===============7370286034786637320==" MIME-Version: 1.0 Subject: BUG #17964: Missed query planner optimization To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mathiaskunter@gmail.com Reply-To: mathiaskunter@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 06 Jun 2023 11:16:47 +0000 Message-ID: <17964-cdeb9e3f89c18393@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 --===============7370286034786637320== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk2NApMb2dnZWQgYnk6ICAgICAgICAgIE1hdGhpYXMgS3VudGVyCkVt YWlsIGFkZHJlc3M6ICAgICAgbWF0aGlhc2t1bnRlckBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNC44Ck9wZXJhdGluZyBzeXN0ZW06ICAgeDg2XzY0LXBjLWxpbnV4LWdudQpEZXNjcmlw dGlvbjogICAgICAgIAoKSW4gdGhlIGV4YW1wbGUgYmVsb3csIHRoZSBxdWVyeSBwbGFubmVyIHVz ZXMgYSBzZXF1ZW50aWFsIHNjYW4gKHF1ZXJ5IDEpCmV2ZW4gdGhvdWdoIGl0IGNvdWxkIHVzZSBh biBpbmRleCBzY2FuIChxdWVyeSAyKS4NCg0KQ1JFQVRFIFRBQkxFIHRhYmxlMSAoaWQgU0VSSUFM IE5PVCBOVUxMLCBuYW1lIFZBUkNIQVIsIENPTlNUUkFJTlQKdGFibGUxX3BrZXkgUFJJTUFSWSBL RVkgKGlkKSk7DQpDUkVBVEUgVEFCTEUgdGFibGUyIChpZCBTRVJJQUwgTk9UIE5VTEwsIG5hbWUg VkFSQ0hBUiwgQ09OU1RSQUlOVAp0YWJsZTJfcGtleSBQUklNQVJZIEtFWSAoaWQpKTsNCkNSRUFU RSBUQUJMRSB0YWJsZTMgKGlkIElOVEVHRVIgTk9UIE5VTEwpOw0KDQpJTlNFUlQgSU5UTyB0YWJs ZTEgKGlkLCBuYW1lKSBTRUxFQ1QgZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwKSwKbWQ1KHJhbmRv bSgpOjp0ZXh0KTsNCklOU0VSVCBJTlRPIHRhYmxlMiAoaWQsIG5hbWUpIFNFTEVDVCBnZW5lcmF0 ZV9zZXJpZXMoMSwgMTAwMDApLAptZDUocmFuZG9tKCk6OnRleHQpOw0KSU5TRVJUIElOVE8gdGFi bGUzIChpZCkgVkFMVUVTICgxNTM4KSwoODgzNiksKDU0ODYpLCgzNDY0KSwoMjY3Myk7DQoNCkFO QUxZWkU7DQoNCkVYUExBSU4gQU5BTFlaRSBTRUxFQ1QgaWQsIG5hbWUgRlJPTSAoU0VMRUNUIGlk LCBuYW1lIEZST00gdGFibGUxIFVOSU9OClNFTEVDVCBpZCwgbmFtZSBGUk9NIHRhYmxlMikgQVMg cQ0KV0hFUkUgaWQgSU4gKFNFTEVDVCBpZCBGUk9NIHRhYmxlMyk7DQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkhhc2ggU2Vt aSBKb2luICAoY29zdD03NjkuMTEuLjEyMjcuMTcgcm93cz01MDAgd2lkdGg9MzYpIChhY3R1YWwK dGltZT0xMC45NTIuLjE1LjA5NCByb3dzPTEwIGxvb3BzPTEpDQrigIfigIdIYXNoIENvbmQ6ICh0 YWJsZTEuaWQgPSB0YWJsZTMuaWQpDQrigIfigIctPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9NzY4 LjAwLi45NjguMDAgcm93cz0yMDAwMCB3aWR0aD0zNikgKGFjdHVhbAp0aW1lPTEwLjc1Ny4uMTMu NTk3IHJvd3M9MjAwMDAgbG9vcHM9MSkNCuKAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh0dyb3VwIEtl eTogdGFibGUxLmlkLCB0YWJsZTEubmFtZQ0K4oCH4oCH4oCH4oCH4oCH4oCH4oCH4oCHQmF0Y2hl czogMSAgTWVtb3J5IFVzYWdlOiAyNTc3a0INCuKAh+KAh+KAh+KAh+KAh+KAh+KAh+KAhy0+ICBB cHBlbmQgIChjb3N0PTAuMDAuLjY2OC4wMCByb3dzPTIwMDAwIHdpZHRoPTM2KSAoYWN0dWFsCnRp bWU9MC4wMTAuLjQuMTM1IHJvd3M9MjAwMDAgbG9vcHM9MSkNCuKAh+KAh+KAh+KAh+KAh+KAh+KA h+KAh+KAh+KAh+KAh+KAh+KAh+KAhy0+ICBTZXEgU2NhbiBvbiB0YWJsZTEgIChjb3N0PTAuMDAu LjE4NC4wMCByb3dzPTEwMDAwCndpZHRoPTM3KSAoYWN0dWFsIHRpbWU9MC4wMDkuLjEuMjg4IHJv d3M9MTAwMDAgbG9vcHM9MSkNCuKAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KA h+KAhy0+ICBTZXEgU2NhbiBvbiB0YWJsZTIgIChjb3N0PTAuMDAuLjE4NC4wMCByb3dzPTEwMDAw CndpZHRoPTM3KSAoYWN0dWFsIHRpbWU9MC4wMTAuLjEuMzM2IHJvd3M9MTAwMDAgbG9vcHM9MSkN CuKAh+KAhy0+ICBIYXNoICAoY29zdD0xLjA1Li4xLjA1IHJvd3M9NSB3aWR0aD00KSAoYWN0dWFs IHRpbWU9MC4wMTQuLjAuMDE1CnJvd3M9NSBsb29wcz0xKQ0K4oCH4oCH4oCH4oCH4oCH4oCH4oCH 4oCHQnVja2V0czogMTAyNCAgQmF0Y2hlczogMSAgTWVtb3J5IFVzYWdlOiA5a0INCuKAh+KAh+KA h+KAh+KAh+KAh+KAh+KAhy0+ICBTZXEgU2NhbiBvbiB0YWJsZTMgIChjb3N0PTAuMDAuLjEuMDUg cm93cz01IHdpZHRoPTQpIChhY3R1YWwKdGltZT0wLjAwOS4uMC4wMTAgcm93cz01IGxvb3BzPTEp DQpQbGFubmluZyBUaW1lOiAwLjQ0NCBtcw0KRXhlY3V0aW9uIFRpbWU6IDE1LjI1NyBtcw0KDQpF WFBMQUlOIEFOQUxZWkUgU0VMRUNUIGlkLCBuYW1lIEZST00gKFNFTEVDVCBpZCwgbmFtZSBGUk9N IHRhYmxlMSBVTklPTgpTRUxFQ1QgaWQsIG5hbWUgRlJPTSB0YWJsZTIpIEFTIHENCldIRVJFIGlk IElOICgxNTM4LDg4MzYsNTQ4NiwzNDY0LDI2NzMpOw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpIYXNoQWdncmVnYXRlICAo Y29zdD01MS4yMy4uNTEuMzMgcm93cz0xMCB3aWR0aD0zNikgKGFjdHVhbAp0aW1lPTAuMDY1Li4w LjA2NyByb3dzPTEwIGxvb3BzPTEpDQrigIfigIdHcm91cCBLZXk6IHRhYmxlMS5pZCwgdGFibGUx Lm5hbWUNCuKAh+KAh0JhdGNoZXM6IDEgIE1lbW9yeSBVc2FnZTogMjRrQg0K4oCH4oCHLT4gIEFw cGVuZCAgKGNvc3Q9MC4yOS4uNTEuMTggcm93cz0xMCB3aWR0aD0zNikgKGFjdHVhbCB0aW1lPTAu MDI1Li4wLjA1Nwpyb3dzPTEwIGxvb3BzPTEpDQrigIfigIfigIfigIfigIfigIfigIfigIctPiAg SW5kZXggU2NhbiB1c2luZyB0YWJsZTFfcGtleSBvbiB0YWJsZTEgIChjb3N0PTAuMjkuLjI1LjUx IHJvd3M9NQp3aWR0aD0zNykgKGFjdHVhbCB0aW1lPTAuMDI0Li4wLjAzOCByb3dzPTUgbG9vcHM9 MSkNCuKAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh+KAh0luZGV4IENvbmQ6 IChpZCA9IEFOWQooJ3sxNTM4LDg4MzYsNTQ4NiwzNDY0LDI2NzN9Jzo6aW50ZWdlcltdKSkNCuKA h+KAh+KAh+KAh+KAh+KAh+KAh+KAhy0+ICBJbmRleCBTY2FuIHVzaW5nIHRhYmxlMl9wa2V5IG9u IHRhYmxlMiAgKGNvc3Q9MC4yOS4uMjUuNTEgcm93cz01CndpZHRoPTM3KSAoYWN0dWFsIHRpbWU9 MC4wMDYuLjAuMDE3IHJvd3M9NSBsb29wcz0xKQ0K4oCH4oCH4oCH4oCH4oCH4oCH4oCH4oCH4oCH 4oCH4oCH4oCH4oCH4oCHSW5kZXggQ29uZDogKGlkID0gQU5ZCignezE1MzgsODgzNiw1NDg2LDM0 NjQsMjY3M30nOjppbnRlZ2VyW10pKQ0KUGxhbm5pbmcgVGltZTogMC4xNzAgbXMNCkV4ZWN1dGlv biBUaW1lOiAwLjA5NyBtcw0KDQoNClRoZSByZXN1bHRzIGFyZSBhbHNvIHByb3ZpZGVkIGFzIFNR TCBmaWRkbGVzIGhlcmU6DQpodHRwczovL2RiZmlkZGxlLnVrL3hvN2Z1ZzFvDQpodHRwczovL3d3 dy5kYi1maWRkbGUuY29tL2YvaVVzZnBkUDJlRDhZdGROMkVtN1p5dS8wCgo= --===============7370286034786637320==--