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 1kzoYz-0000jk-0g for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jan 2021 22:24:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzoYx-0004sI-T2 for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jan 2021 22:24:23 +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 1kzoP4-000258-Ta for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 22:14:11 +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 1kzoOy-0006Cc-Df for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 22:14:10 +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=4H3rLsG3u6jPFQKvkCB7Fe+vucADJt8yC5OhulI0Uds=; b=K3RNORh5hrR+Nvh0cDMER8aZsW 92RPyXltNDI9W7KwQepFrSNELNcYLNxwAVX1wfeTqV5Nm79ykDOR09l+0DYa3CHUmPTH7PLbq32Da vObAanM7R33fZucxXB1S3UqktGWJ1nKH6o27rRMI8PpoDm8+3Yx/mUb8YNM/NvMkA+e3V0j417vk4 fOI+veuHFU1B2k/yvjZL5/CJChRd6M9Ldp6B9Z0zTlV4c26XCcsOoDqv9QKd9JuS+Q6FUD2TkU9jF q9teJS5slKPPWIda+zvpZ0nPAfrY1rvXtjpZt270x/ymQp7Iu5DR+FPcxafZRY0Dhr/E0T/5TuKMh Ug+yVKsA==; 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 1kzoOx-0003PA-31 for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 22:14:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzoOv-0008T5-T9 for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 22:14:01 +0000 Content-Type: multipart/mixed; boundary="===============3565052677783813948==" MIME-Version: 1.0 Subject: BUG #16824: Planner chooses poor path on query with Merge Join and pagination To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jacobmitash@gmail.com Reply-To: jacobmitash@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 13 Jan 2021 22:13:55 +0000 Message-ID: <16824-cac06100763db5ae@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3565052677783813948== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjgyNApMb2dnZWQgYnk6ICAgICAgICAgIEphY29iIE1pdGFzaApFbWFp bCBhZGRyZXNzOiAgICAgIGphY29ibWl0YXNoQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjEKT3BlcmF0aW5nIHN5c3RlbTogICBBbHBpbmUgTGludXggKERvY2tlciBjb250YWluZXIp CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwNCg0KSSBoYXZlIGJlZW4gd29ya2luZyB3aXRoIHRo aXMgcmVsYXRpdmVseSBzaW1wbGUgcXVlcnkgdGhhdCBpcyB1c2VkIHRvCml0ZXJhdGUgb3ZlciBh IGxhcmdlIHN1YnNldCBvZiByb3dzIGFjcm9zcyB0d28gdGFibGVzLCBvbmUgcGFnZSBhdCBhIHRp bWUuClRoZSBxdWVyeSB3YXMgb3JpZ2luYWxseSB1c2luZyBhbiBPRkZTRVQvTElNSVQgdG8gZXhl Y3V0ZSB0aGUgcGFnaW5nLCB3aGljaAp5b3UgbWlnaHQgZ3Vlc3MgcGVyZm9ybXMgcG9vcmx5IGlu IHRoZSBsYXRlciBwYWdlcy4gSSBjaGFuZ2VkIHRoZSBxdWVyeSB0bwpkbyBwYWdpbmF0aW9uIHVz aW5nIGEgY29tYmluYXRpb24gb2YgT1JERVIgQlkgaWQsIFdIRVJFIGlkID4KaWRfZnJvbV9wcmV2 X3BhZ2UsIGFuZCBMSU1JVCBwYWdlX3NpemUuIEknbSBub3Qgc3VyZSBpZiB0aGF0IHN0cmF0ZWd5 IGhhcyBhCm5hbWUsIGJ1dCBJJ2xsIHJlZmVyIHRvIGl0IGFzICJJRCBwYWdpbmF0aW9uIi4NCg0K TXkgZGF0YXNldCBpbnZvbHZlcyBqdXN0IHR3byB0YWJsZXMsIGRlc2NyaWJlZCBieSB0aGlzIERE TDoNCmBgYA0KLS0gRERMOg0KY3JlYXRlIHRhYmxlIHN1YiAoIC0tIDQuM00gcmVjb3Jkcw0KICAg IHN1YnNjcmlwdGlvbl9pZCAgICAgdmFyY2hhcigyNTUpIC0tIFVVSURzDQogICAgICAgIG5vdCBu dWxsIGNvbnN0cmFpbnQgcGtfc3ViIHByaW1hcnkga2V5LA0KICAgIHN1YnNjcmlwdGlvbl9zdGF0 dXMgdmFyY2hhcigyNTUpIC0tIChBQ1RJVkUsIFBFTkRJTkcsIG9yIENBTkNFTExFRCkNCik7DQoN CmNyZWF0ZSB0YWJsZSBzdWJfaXRlbSAoIC0tIDQuNE0gcmVjb3JkcywgbW9zdGx5IDE6MSB3aXRo IHN1YnNjcmlwdGlvbnMNCiAgICBzdWJzY3JpcHRpb25faXRlbV9pZCB2YXJjaGFyKDI1NSkgLS0g VVVJRHMNCiAgICAgICAgbm90IG51bGwgY29uc3RyYWludCBwa19zdWJfaXRlbSBwcmltYXJ5IGtl eSwNCiAgICBzdWJzY3JpcHRpb25faWQgICAgICB2YXJjaGFyKDI1NSkgLS0gRksgdG8gc3ViDQog ICAgICAgIGNvbnN0cmFpbnQgZmtfc3ViX2l0ZW1fc3ViX2lkIHJlZmVyZW5jZXMgc3ViLA0KICAg IGl0ZW1fcmVmICAgICAgICAgICAgIHZhcmNoYXIoMjU1KSAtLSAyNSBjaGFyYWN0ZXIgc3RyaW5n cywgbW9zdGx5IHRoZQpzYW1lDQopOw0KYGBgDQoNCkFuZCBoZXJlJ3MgdGhlIHF1ZXJ5IEkndmUg YmVlbiB1c2luZyB0byBzZWxlY3QgcGFnZXMgd2hpbGUgdGVzdGluZwpwZXJmb3JtYW5jZS4gVGhl IGxpdGVyYWwgdmFsdWUgb2YgdGhlIHN1YnNjcmlwdGlvbl9pZCBpcyB0byByZXByZXNlbnQKZ3Jh YmJpbmcgYSBwYWdlIGluIHRoZSBtaWRkbGUgb2YgdGhlIGRhdGEuDQpgYGANCi0tIFF1ZXJ5OiBH cmFiIGEgcGFnZSBmcm9tIHRoZSBtaWRkbGUNCkVYUExBSU4gQU5BTFlaRQ0KU0VMRUNUIHMuc3Vi c2NyaXB0aW9uX2lkLCAqDQpGUk9NIHN1YiBzDQogICAgSk9JTiBzdWJfaXRlbSBzaSBPTiBzLnN1 YnNjcmlwdGlvbl9pZCA9IHNpLnN1YnNjcmlwdGlvbl9pZCBBTkQKc2kuaXRlbV9yZWYgPSAnMTAw MTEwNzU5OTk5OTkxMDIyMjAwMTAwMCcNCldIRVJFIHMuc3Vic2NyaXB0aW9uX3N0YXR1cyA9ICdB Q1RJVkUnDQogIEFORCBzLlNVQlNDUklQVElPTl9JRCA+ICc3Y2ExY2Y2Yi0yNDUyLTRkMWItYmQw My0xYmE2OGI2M2I1MjgnDQpPUkRFUiBCWSBzLnN1YnNjcmlwdGlvbl9pZA0KTElNSVQgNTA7DQpg YGANCg0KTXkgdW5kZXJzdGFuZGluZyBvZiB0aGlzIElEIHBhZ2luYXRpb24gaXMgdGhhdCBpdCBz aG91bGQgYmUgdmVyeSBxdWljayBhcyBpdApuZWVkcyBvbmx5IGZpbmQgdGhlIElEIGluIHRoZSBp bmRleCwgYW5kIHRoZW4gc2NhbiB0aGUgbmV4dCA1MCBlbnRyaWVzLgpIb3dldmVyLCB0aGUgZXhl Y3V0aW9uIHRpbWUgaXMgc2xvdzoNCmBgYA0KTGltaXQgIChjb3N0PTIuNDEuLjMyNS43NiByb3dz PTUwIHdpZHRoPTE3OSkgKGFjdHVhbAp0aW1lPTEwMzM2LjA5NS4uMTAzNDAuMzg5IHJvd3M9NTAg bG9vcHM9MSkNCiAgLT4gIE1lcmdlIEpvaW4gIChjb3N0PTIuNDEuLjc2NTgzMi45NiByb3dzPTEx ODQyMSB3aWR0aD0xNzkpIChhY3R1YWwKdGltZT0xMDMzNi4wODYuLjEwMzM5LjkwMCByb3dzPTUw IGxvb3BzPTEpDQogICAgICAgIE1lcmdlIENvbmQ6ICgocy5zdWJzY3JpcHRpb25faWQpOjp0ZXh0 ID0KKHNpLnN1YnNjcmlwdGlvbl9pZCk6OnRleHQpDQogICAgICAgIC0+ICBJbmRleCBTY2FuIHVz aW5nIHBrX3N1YiBvbiBzdWIgcyAgKGNvc3Q9MC41Ni4uMjcwNjQ4LjIxCnJvd3M9NjMyOTEzIHdp ZHRoPTQ1KSAoYWN0dWFsIHRpbWU9MC4wMjUuLjEuNjQzIHJvd3M9OTAgbG9vcHM9MSkNCiAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKChzdWJzY3JpcHRpb25faWQpOjp0ZXh0ID4KJzdjYTFjZjZi LTI0NTItNGQxYi1iZDAzLTFiYTY4YjYzYjUyOCc6OnRleHQpDQogICAgICAgICAgICAgIEZpbHRl cjogKChzdWJzY3JpcHRpb25fc3RhdHVzKTo6dGV4dCA9ICdBQ1RJVkUnOjp0ZXh0KQ0KICAgICAg ICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiAyMTENCiAgICAgICAgLT4gIEluZGV4IFNj YW4gdXNpbmcgaWR4X3N1Yl9pdGVtX3N1Yl9pZF9idHJlZSBvbiBzdWJfaXRlbSBzaSAKKGNvc3Q9 MC41Ni4uNDkwMzg1Ljk5IHJvd3M9ODEzMTUxIHdpZHRoPTk4KSAoYWN0dWFsIHRpbWU9MC4wMTYu LjgyNjAuNTg2CnJvd3M9MzkzMDU4IGxvb3BzPTEpDQogICAgICAgICAgICAgIEZpbHRlcjogKChp dGVtX3JlZik6OnRleHQgPQonMTAwMTEwNzU5OTk5OTkxMDIyMjAwMTAwMCc6OnRleHQpDQogICAg ICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDE3NDI0NzUNClBsYW5uaW5nIFRpbWU6 IDAuMzA5IG1zDQpFeGVjdXRpb24gVGltZTogMTAzNDAuNjkxIG1zDQpgYGANCg0KSnVzdCBmaWRk bGluZyBhcm91bmQsIEkgc2F3IHRoYXQgcGVyZm9ybWFuY2Ugc2lnbmlmaWNhbnRseSBpbXByb3Zl ZCB3aGVuIEkKcmFuOiBTRVQgZW5hYmxlX21lcmdlam9pbiA9IE9GRjsNCmBgYA0KTGltaXQgIChj b3N0PTEuMTEuLjQ0Ni45NyByb3dzPTUwIHdpZHRoPTE3OSkgKGFjdHVhbCB0aW1lPTAuMTUwLi40 LjM1MQpyb3dzPTUwIGxvb3BzPTEpDQogIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MS4xMS4uMTA1 NTk2NC41OSByb3dzPTExODQyMSB3aWR0aD0xNzkpIChhY3R1YWwKdGltZT0wLjE0MC4uMy44NTAg cm93cz01MCBsb29wcz0xKQ0KICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBwa19zdWIgb24g c3ViIHMgIChjb3N0PTAuNTYuLjI3MDY0OC4yMQpyb3dzPTYzMjkxMyB3aWR0aD00NSkgKGFjdHVh bCB0aW1lPTAuMDY0Li4wLjg5OCByb3dzPTkwIGxvb3BzPTEpDQogICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICgoc3Vic2NyaXB0aW9uX2lkKTo6dGV4dCA+Cic3Y2ExY2Y2Yi0yNDUyLTRkMWItYmQw My0xYmE2OGI2M2I1MjgnOjp0ZXh0KQ0KICAgICAgICAgICAgICBGaWx0ZXI6ICgoc3Vic2NyaXB0 aW9uX3N0YXR1cyk6OnRleHQgPSAnQUNUSVZFJzo6dGV4dCkNCiAgICAgICAgICAgICAgUm93cyBS ZW1vdmVkIGJ5IEZpbHRlcjogMjExDQogICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9z dWJfaXRlbV9zdWJfaWRfYnRyZWUgb24gc3ViX2l0ZW0gc2kgCihjb3N0PTAuNTYuLjEuMjMgcm93 cz0xIHdpZHRoPTk4KSAoYWN0dWFsIHRpbWU9MC4wMTMuLjAuMDE2IHJvd3M9MQpsb29wcz05MCkN CiAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChzdWJzY3JpcHRpb25faWQpOjp0ZXh0ID0KKHMu c3Vic2NyaXB0aW9uX2lkKTo6dGV4dCkNCiAgICAgICAgICAgICAgRmlsdGVyOiAoKGl0ZW1fcmVm KTo6dGV4dCA9CicxMDAxMTA3NTk5OTk5OTEwMjIyMDAxMDAwJzo6dGV4dCkNCiAgICAgICAgICAg ICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMA0KUGxhbm5pbmcgVGltZTogMC4xOTYgbXMNCkV4 ZWN1dGlvbiBUaW1lOiA0LjYyMyBtcw0KYGBgDQoNCkkgb3JpZ2luYWxseSBhc2tlZCBhYm91dCB0 aGlzIG9uIHRoZSBEQkEgU3RhY2tFeGNoYW5nZS4gSSBoYWQgdHdvIHF1ZXN0aW9ucwp0byB3aGlj aCBJJ2xsIHN1bW1hcml6ZSBoZXJlOg0KDQoxLiBXaHkgaXMgdGhlIE1lcmdlIEpvaW4gcGVyZm9y bWluZyBzbyBzbG93bHk/DQpJdCBzZWVtcyB0byBiZSBiZWNhdXNlIHRoZSBwbGFubmVyIGRvZXNu J3QgcmVjb2duaXplIHRoYXQgaXQgY2FuIGFwcGx5IHRoZQpzdWJzY3JpcHRpb25faWQgaW5kZXgg Y29uZGl0aW9uIG9uIHRoZSBpbm5lciB0YWJsZS4gSWYgSSBleHBsaWNpdGx5IHRlbGwgaXQ6CiJB TkQgc2kuc3Vic2NyaXB0aW9uX2lkID4gJzdjYTEuLi4nIiwgdGhlbiBpdCBhcHBsaWVzIGFuIGlu ZGV4IGNvbmRpdGlvbiBhbmQKaXMgYWxtb3N0IGluc3RhbnQuDQoyLiBXaHkgZG9lcyB0aGUgcGxh bm5lciBiZWxpZXZlIHRoYXQgTWVyZ2UgSm9pbiAoYXMtaXMpIGlzIG9wdGltYWwgaGVyZT8NCkkg ZG9uJ3QgaGF2ZSBhbiBhbnN3ZXIgZm9yIHRoaXMuIFBvdGVudGlhbGx5IGEgYnVnIHJlbGF0ZWQg dG8gdGhlIHByZXZpb3VzCmFuc3dlcj8NCg0KU28gSSB0aGluayB0aGVyZSdzIHR3byB0aGluZ3Mg Z29pbmcgb24gaGVyZSB0aGF0IG1heSBvciBtYXkgbm90IGJlCmNsYXNzaWZpZWQgYXMgYnVnczoN CjEuIFVzaW5nIE1lcmdlIEpvaW4sIHRoZSBwbGFubmVyIGRvZXMgbm90IGFwcGx5IGFuIGluZGV4 IGNvbmRpdGlvbiB0byB0aGUKaW5uZXIgdGFibGUgdGhhdCBjb3VsZCBiZSBpbXBsaWVkIGZyb20g dGhlIGNsYXVzZSBvbiB0aGUgb3V0ZXIgdGFibGUuDQoyLiBJbiB0aGUgc2FtZSBzY2VuYXJpbywg dGhlIHBsYW5uZXIncyBjb3N0IGVzdGltYXRpb24gaXMgZ3Jvc3NseSBkaWZmZXJlbnQKZnJvbSB0 aGUgYWN0dWFsIGV4ZWN1dGlvbiB0aW1lLgoK --===============3565052677783813948==--