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 1l6AUG-0000lZ-8c for pgsql-bugs@arkaria.postgresql.org; Sun, 31 Jan 2021 11:01: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 1l6ATh-0008Ng-1Z for pgsql-bugs@arkaria.postgresql.org; Sun, 31 Jan 2021 11:01:13 +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 1l68kI-0004qd-0b for pgsql-bugs@lists.postgresql.org; Sun, 31 Jan 2021 09:10:14 +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 1l68k9-0008Fr-Ms for pgsql-bugs@lists.postgresql.org; Sun, 31 Jan 2021 09:10: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=y8WV7FvUL0c7Gx6Kca9wGX+AFugru080K/b1Q5ivx2s=; b=eDrhK59M3kgk3OvsIMhPpPx4gq 2I1odGWpMf2VgSu2N+krd6KnTPsY8RggyxLGhZXMTYN3Re8PNbTcR6w8essS8ky7Njc/wT1XhEjwc ZCxU6c1Tgw1rMr0iJ3+1Sm+ALiBhebeNXV+NtCSOQsvaLaoU3kzkjW1JxbB3Xj4/8UimPK0RuOa5w t29h9VjNDKv0RanDKAq2GrCMMQhdkzk0zVrLy+P2b8QXX/L+mdeOZ3ZkYQXYO4J4aW9/0BjuJm3ZU ycDnlZDlA+xGtbKhcuMorogPjLBi2sLzf3Ahc+9oP2hw0E0nvEAQUFPGcqJ8Q11UknhrREquuTWVD US6lCoeg==; 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 1l68k7-0008UM-C0 for pgsql-bugs@lists.postgresql.org; Sun, 31 Jan 2021 09:10: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 1l68k5-0005Yw-Sh for pgsql-bugs@lists.postgresql.org; Sun, 31 Jan 2021 09:10:01 +0000 Content-Type: multipart/mixed; boundary="===============2365433147395081414==" MIME-Version: 1.0 Subject: BUG #16846: "retrieved too many tuples in a bounded sort" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: contact@yorhel.nl Reply-To: contact@yorhel.nl, pgsql-bugs@lists.postgresql.org Date: Sun, 31 Jan 2021 09:09:49 +0000 Message-ID: <16846-ae49f51ac379a4cb@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 --===============2365433147395081414== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg0NgpMb2dnZWQgYnk6ICAgICAgICAgIFlvcmFuIEhlbGluZwpFbWFp bCBhZGRyZXNzOiAgICAgIGNvbnRhY3RAeW9yaGVsLm5sClBvc3RncmVTUUwgdmVyc2lvbjogMTMu MQpPcGVyYXRpbmcgc3lzdGVtOiAgIEdlbnRvbyB4ODZfNjQKRGVzY3JpcHRpb246ICAgICAgICAK CkkgaGF2ZSBhIHF1ZXJ5IHRoYXQgZmFpbHMgYXMgZm9sbG93czoNCg0KPiBTRUxFQ1QgaWQgRlJP TSByZWxlYXNlcyBXSEVSRSBtaW5hZ2UgPSAxOCBBTkQgcmVsZWFzZWQgPD0gMjAyMTAxMzEgQU5E IGlkCklOKFNFTEVDVCBpZCBGUk9NIHJlbGVhc2VzX2xhbmcgV0hFUkUgbGFuZyA9ICdqYScpIE9S REVSIEJZIHJlbGVhc2VkIERFU0MsCmlkIExJTUlUIDUwOyANCkVSUk9SOiAgWFgwMDA6IHJldHJp ZXZlZCB0b28gbWFueSB0dXBsZXMgaW4gYSBib3VuZGVkIHNvcnQNCkxPQ0FUSU9OOiAgdHVwbGVz b3J0X2dldHR1cGxlX2NvbW1vbiwgdHVwbGVzb3J0LmM6MjEwMw0KDQpFWFBMQUlOIG91dHB1dCBv ZiB0aGUgcXVlcnkgaXMgYXMgZm9sbG93czoNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgIAogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogTGltaXQgIChjb3N0PTQuMDku LjQyLjYxIHJvd3M9NTAgd2lkdGg9OCkNCiAgIC0+ICBJbmNyZW1lbnRhbCBTb3J0ICAoY29zdD00 LjA5Li4yNTU2OS4yMSByb3dzPTMzMTg0IHdpZHRoPTgpDQogICAgICAgICBTb3J0IEtleTogcmVs ZWFzZXMucmVsZWFzZWQgREVTQywgcmVsZWFzZXMuaWQNCiAgICAgICAgIFByZXNvcnRlZCBLZXk6 IHJlbGVhc2VzLnJlbGVhc2VkDQogICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuNTgu LjI0MjcyLjMzIHJvd3M9MzMxODQgd2lkdGg9OCkNCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBT Y2FuIEJhY2t3YXJkIHVzaW5nIHJlbGVhc2VzX3JlbGVhc2VkIG9uIHJlbGVhc2VzIAooY29zdD0w LjI5Li45MjcxLjU1IHJvd3M9NDUyMjUgd2lkdGg9OCkNCiAgICAgICAgICAgICAgICAgICAgIElu ZGV4IENvbmQ6IChyZWxlYXNlZCA8PSAyMDIxMDEzMSkNCiAgICAgICAgICAgICAgICAgICAgIEZp bHRlcjogKG1pbmFnZSA9IDE4KQ0KICAgICAgICAgICAgICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1 c2luZyByZWxlYXNlc19sYW5nX3BrZXkgb24gcmVsZWFzZXNfbGFuZwogKGNvc3Q9MC4yOS4uMC4z MyByb3dzPTEgd2lkdGg9NCkNCiAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgoaWQg PSByZWxlYXNlcy5pZCkgQU5EIChsYW5nID0KJ2phJzo6bGFuZ3VhZ2UpKQ0KKDEwIHJvd3MpDQoN ClRoZSBwcm9ibGVtIGlzIHZlcnkgZGF0YS1kZXBlbmRlbnQsIGNoYW5naW5nIGFueSB2YWx1ZSBp biB0aGUgcXVlcnkgd2lsbAptYWtlIGl0IHN1Y2NlZWQuIEhlcmUncyBhbiBFWFBMQUlOIEFOQUxZ WkUgdGhhdCBzdWNjZWVkcyB3aXRoIGEgc2xpZ2h0bHkKbW9kaWZpZWQgJ3JlbGVhc2VkJyBjb21w YXJpc29uLiBJIGRvbid0IGtub3cgaWYgdGhpcyBpcyByZWxldmFudCwgYnV0IHRoZQpyb3dzIGVz dGltYXRlIGlzIGEgbGl0dGxlIG9mZi4gSSBkaWQgcnVuIGEgVkFDVVVNIEFOQUxZWkUuDQoNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgClFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICANCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBMaW1pdCAgKGNvc3Q9NC4wOS4u NDIuNjEgcm93cz01MCB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC45MzMuLjEuMDU2IHJvd3M9NTAK bG9vcHM9MSkNCiAgIC0+ICBJbmNyZW1lbnRhbCBTb3J0ICAoY29zdD00LjA5Li4yNTU2OS4yMSBy b3dzPTMzMTg0IHdpZHRoPTgpIChhY3R1YWwKdGltZT0wLjkzMy4uMS4wNTAgcm93cz01MCBsb29w cz0xKQ0KICAgICAgICAgU29ydCBLZXk6IHJlbGVhc2VzLnJlbGVhc2VkIERFU0MsIHJlbGVhc2Vz LmlkDQogICAgICAgICBQcmVzb3J0ZWQgS2V5OiByZWxlYXNlcy5yZWxlYXNlZA0KICAgICAgICAg RnVsbC1zb3J0IEdyb3VwczogMSAgU29ydCBNZXRob2Q6IHF1aWNrc29ydCAgQXZlcmFnZSBNZW1v cnk6IDI4a0IgClBlYWsgTWVtb3J5OiAyOGtCDQogICAgICAgICBQcmUtc29ydGVkIEdyb3Vwczog OSAgU29ydCBNZXRob2RzOiB0b3AtTiBoZWFwc29ydCwgcXVpY2tzb3J0IApBdmVyYWdlIE1lbW9y eTogMjVrQiAgUGVhayBNZW1vcnk6IDI1a0INCiAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNv c3Q9MC41OC4uMjQyNzIuMzMgcm93cz0zMzE4NCB3aWR0aD04KSAoYWN0dWFsCnRpbWU9MC4xNDku LjAuOTkxIHJvd3M9NzcgbG9vcHM9MSkNCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIEJh Y2t3YXJkIHVzaW5nIHJlbGVhc2VzX3JlbGVhc2VkIG9uIHJlbGVhc2VzIAooY29zdD0wLjI5Li45 MjcxLjU1IHJvd3M9NDUyMjUgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDI5Li4wLjQ4MSByb3dz PTI2OApsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHJlbGVhc2Vk IDw9IDIwMjEwMTI4KQ0KICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAobWluYWdlID0gMTgp DQogICAgICAgICAgICAgICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiAxNTcNCiAgICAg ICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgcmVsZWFzZXNfbGFuZ19wa2V5IG9u IHJlbGVhc2VzX2xhbmcKIChjb3N0PTAuMjkuLjAuMzMgcm93cz0xIHdpZHRoPTQpIChhY3R1YWwg dGltZT0wLjAwMi4uMC4wMDIgcm93cz0wCmxvb3BzPTI2OCkNCiAgICAgICAgICAgICAgICAgICAg IEluZGV4IENvbmQ6ICgoaWQgPSByZWxlYXNlcy5pZCkgQU5EIChsYW5nID0KJ2phJzo6bGFuZ3Vh Z2UpKQ0KICAgICAgICAgICAgICAgICAgICAgSGVhcCBGZXRjaGVzOiAwDQogUGxhbm5pbmcgVGlt ZTogMC42NDcgbXMNCiBFeGVjdXRpb24gVGltZTogMS4xMjAgbXMNCigxNiByb3dzKQ0KDQpTYWRs eSBJJ3ZlIG5vdCBiZWVuIGFibGUgdG8gY3JlYXRlIGEgbWluaW11bSB3b3JraW5nIGV4YW1wbGUs IGJ1dCBJIGhhdmUKYmVlbiBhYmxlIHRvIHJlcHJvZHVjZSB0aGlzIG9uIG91ciBwdWJsaWMgZGF0 YWJhc2UgZHVtcHMuIEkndmUgbWFkZSBhbgpleGNlcnB0IG9mIHRoZSBkYXRhYmFzZSB3aXRoIG9u bHkgdGhlIHR3byByZWZlcmVuY2VkIHRhYmxlczoKaHR0cHM6Ly9zLnZuZGIub3JnL3Uvdm5kYi1y ZWxlYXNlcy10ZXN0LTIwMjEwMTMxLnNxbC5neiAofjUuNU1CIGNvbXByZXNzZWQpLgpJIGNhbiBy ZXByb2R1Y2UgdGhlIGVycm9yIG9uIHRoYXQgZGF0YWJhc2Ugd2l0aCB0aGUgYWJvdmUgcXVlcnku DQoNCihUaGF0IGRhdGEgaXMgcGFydCBvZiB0aGUgIm5lYXItY29tcGxldGUgZGF0YWJhc2UgZHVt cCIgZG9jdW1lbnRlZCBhdApodHRwczovL3ZuZGIub3JnL2QxNCM1IC0gdGhlIGlzc3VlIGNhbiBh bHNvIGJlIHJlcHJvZHVjZWQgb24gdGhlIGZ1bGwgZHVtcAphZnRlciBkb2luZyBhICJDUkVBVEUg SU5ERVggcmVsZWFzZXNfcmVsZWFzZWQgT04gcmVsZWFzZXMgKHJlbGVhc2VkKSIpCgo= --===============2365433147395081414==--