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 1mx6Cc-0005X2-9A for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Dec 2021 11:42:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mx6Ca-0007CI-77 for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Dec 2021 11:42:36 +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 1mx3ZZ-0007o8-RL for pgsql-bugs@lists.postgresql.org; Tue, 14 Dec 2021 08:54:10 +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 1mx3ZW-0000BU-Ji for pgsql-bugs@lists.postgresql.org; Tue, 14 Dec 2021 08:54:09 +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=Xh822yDrFoD0Rjre5LYIVrOu0SBL8ajDDBXyZ8R8eec=; b=d66kUNmaRmyowop7Q1roJK/krx 5k7UMFNq6w5XTq4aMYjV/P7LrFiYsBMY9KT8xalYpL1S0Cw5uBVutgD9fMnQvG7TqHKDhNaX+NwBY ElFsOcMJhbZaju6GMRP+zE80hurjtKW6AJOeu/y8w7PAIwQ+mdqOo2lQudqcvVX7tw9lalRKapzmS nLoUsC2lQ4Iv2wSC5OnlW6Wke2IlQcQ8ofbKaoEbri49WtjZAFdycm0Lr6DLyH5CuK2Kf4RB1u74i xHu8oJHEUZa/GFhjU3roW45V1Am1MGAMluIWNZSJ1rThnUCI++nRwEuXE57rSC0qn357xWYmRDoCY AX9ClgsA==; 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 1mx3ZU-0006C7-Sv for pgsql-bugs@lists.postgresql.org; Tue, 14 Dec 2021 08:54: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 1mx3ZR-00012L-T4 for pgsql-bugs@lists.postgresql.org; Tue, 14 Dec 2021 08:54:01 +0000 Content-Type: multipart/mixed; boundary="===============1803045071745711184==" MIME-Version: 1.0 Subject: BUG #17336: logtape sort performance and overflow To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ma100@hotmail.com Reply-To: ma100@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 14 Dec 2021 08:53:13 +0000 Message-ID: <17336-fc4e522d26a750fd@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 --===============1803045071745711184== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzMzNgpMb2dnZWQgYnk6ICAgICAgICAgIG1hIGxpYW5nemh1CkVtYWls IGFkZHJlc3M6ICAgICAgbWExMDBAaG90bWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC4x Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zNwpEZXNjcmlwdGlvbjogICAgICAgIAoKSW4gbG9n dGFwZS5jLCAgDQoNCiogRWFjaCAgYHN3YXBfbm9kZXNgICB3aWxsIGV4ZWN1dGUgYXNzaWdubWVu dCBzdGF0ZW1lbnQgdGhyZWUgdGltZXMsIHdoaWxlCndlIG9ubHkgbmVlZCBleGVjdXRlIG9uY2Ug bGlrZSBpbiB0dXBsZXNvcnQuYw0KDQoqIHJpZ2h0X29mZnNldCh1bnNpZ25lZCBpKSBwYXJhbWV0 ZXIgaSBzZWVtZWQgc2hvdWxkIGJlIGB1bnNpZ25lZCBsb25nYA0KDQoNCkhlcmUncyBhIHBhdGNo DQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCmBgYGRpZmYNCmRpZmYg LS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9zb3J0L2xvZ3RhcGUuYwpiL3NyYy9iYWNrZW5kL3V0 aWxzL3NvcnQvbG9ndGFwZS5jDQppbmRleCA0OGJhY2NkLi5jOTZkMWNhIDEwMDY0NA0KLS0tIGEv c3JjL2JhY2tlbmQvdXRpbHMvc29ydC9sb2d0YXBlLmMNCisrKyBiL3NyYy9iYWNrZW5kL3V0aWxz L3NvcnQvbG9ndGFwZS5jDQpAQCAtMzQwLDE2ICszNDAsNiBAQCBsdHNSZWFkRmlsbEJ1ZmZlcihM b2dpY2FsVGFwZSAqbHQpDQogICAgICAgIHJldHVybiAobHQtPm5ieXRlcyA+IDApOw0KIH0NCg0K LXN0YXRpYyBpbmxpbmUgdm9pZA0KLXN3YXBfbm9kZXMobG9uZyAqaGVhcCwgdW5zaWduZWQgbG9u ZyBhLCB1bnNpZ25lZCBsb25nIGIpDQotew0KLSAgICAgICB1bnNpZ25lZCBsb25nIHN3YXA7DQot DQotICAgICAgIHN3YXAgPSBoZWFwW2FdOw0KLSAgICAgICBoZWFwW2FdID0gaGVhcFtiXTsNCi0g ICAgICAgaGVhcFtiXSA9IHN3YXA7DQotfQ0KLQ0KIHN0YXRpYyBpbmxpbmUgdW5zaWduZWQgbG9u Zw0KIGxlZnRfb2Zmc2V0KHVuc2lnbmVkIGxvbmcgaSkNCiB7DQpAQCAtMzU3LDcgKzM0Nyw3IEBA IGxlZnRfb2Zmc2V0KHVuc2lnbmVkIGxvbmcgaSkNCiB9DQoNCiBzdGF0aWMgaW5saW5lIHVuc2ln bmVkIGxvbmcNCi1yaWdodF9vZmZzZXQodW5zaWduZWQgaSkNCityaWdodF9vZmZzZXQodW5zaWdu ZWQgbG9uZyBpKQ0KIHsNCiAgICAgICAgcmV0dXJuIDIgKiBpICsgMjsNCiB9DQpAQCAtNDExLDYg KzQwMSw4IEBAIGx0c0dldEZyZWVCbG9jayhMb2dpY2FsVGFwZVNldCAqbHRzKQ0KICAgICAgICAv KiBzaWZ0IGRvd24gKi8NCiAgICAgICAgcG9zID0gMDsNCiAgICAgICAgaGVhcHNpemUgPSBsdHMt Pm5GcmVlQmxvY2tzOw0KKyAgICAgICBsb25nIHQgPSBoZWFwW3Bvc107DQorDQogICAgICAgIHdo aWxlICh0cnVlKQ0KICAgICAgICB7DQogICAgICAgICAgICAgICAgdW5zaWduZWQgbG9uZyBsZWZ0 ID0gbGVmdF9vZmZzZXQocG9zKTsNCkBAIC00MjYsMTIgKzQxOCwxMyBAQCBsdHNHZXRGcmVlQmxv Y2soTG9naWNhbFRhcGVTZXQgKmx0cykNCiAgICAgICAgICAgICAgICBlbHNlDQogICAgICAgICAg ICAgICAgICAgICAgICBicmVhazsNCg0KLSAgICAgICAgICAgICAgIGlmIChoZWFwW21pbl9jaGls ZF0gPj0gaGVhcFtwb3NdKQ0KKyAgICAgICAgICAgICAgIGlmIChoZWFwW21pbl9jaGlsZF0gPj0g dCkNCiAgICAgICAgICAgICAgICAgICAgICAgIGJyZWFrOw0KDQotICAgICAgICAgICAgICAgc3dh cF9ub2RlcyhoZWFwLCBtaW5fY2hpbGQsIHBvcyk7DQorICAgICAgICAgICAgICAgaGVhcFtwb3Nd ID0gaGVhcFttaW5fY2hpbGRdOw0KICAgICAgICAgICAgICAgIHBvcyA9IG1pbl9jaGlsZDsNCiAg ICAgICAgfQ0KKyAgICAgICBoZWFwW3Bvc10gPSB0Ow0KDQogICAgICAgIHJldHVybiBibG9ja251 bTsNCiB9DQpAQCAtNTE0LDE4ICs1MDcsMjAgQEAgbHRzUmVsZWFzZUJsb2NrKExvZ2ljYWxUYXBl U2V0ICpsdHMsIGxvbmcgYmxvY2tudW0pDQogICAgICAgIC8qIHBsYWNlIGVudHJ5IGF0IGVuZCBv ZiBtaW5oZWFwIGFycmF5ICovDQogICAgICAgIGhlYXBbcG9zXSA9IGJsb2NrbnVtOw0KICAgICAg ICBsdHMtPm5GcmVlQmxvY2tzKys7DQorICAgICAgIGxvbmcgdCA9IGhlYXBbcG9zXTsNCg0KICAg ICAgICAvKiBzaWZ0IHVwICovDQogICAgICAgIHdoaWxlIChwb3MgIT0gMCkNCiAgICAgICAgew0K ICAgICAgICAgICAgICAgIHVuc2lnbmVkIGxvbmcgcGFyZW50ID0gcGFyZW50X29mZnNldChwb3Mp Ow0KDQotICAgICAgICAgICAgICAgaWYgKGhlYXBbcGFyZW50XSA8IGhlYXBbcG9zXSkNCisgICAg ICAgICAgICAgICBpZiAoaGVhcFtwYXJlbnRdIDwgdCkNCiAgICAgICAgICAgICAgICAgICAgICAg IGJyZWFrOw0KDQotICAgICAgICAgICAgICAgc3dhcF9ub2RlcyhoZWFwLCBwYXJlbnQsIHBvcyk7 DQorICAgICAgICAgICAgICAgaGVhcFtwb3NdID0gaGVhcFtwYXJlbnRdOw0KICAgICAgICAgICAg ICAgIHBvcyA9IHBhcmVudDsNCiAgICAgICAgfQ0KKyAgICAgICBoZWFwW3Bvc10gPSB0Ow0KIH0N Cg0KIC8qDQpgYGAKCg== --===============1803045071745711184==--