Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uYx2g-00DvuX-Sd for pgsql-committers@arkaria.postgresql.org; Tue, 08 Jul 2025 01:22:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uYx2e-005W3K-Ob for pgsql-committers@arkaria.postgresql.org; Tue, 08 Jul 2025 01:22:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uYx2e-005W39-BS for pgsql-committers@lists.postgresql.org; Tue, 08 Jul 2025 01:22:41 +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.96) (envelope-from ) id 1uYx2d-0068SG-0F for pgsql-committers@lists.postgresql.org; Tue, 08 Jul 2025 01:22:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=pt3xR1I8gA8iTtZtcbl04s6GLjWw7UB6hz02Q4WBeI0=; b=xhzyhG+lFsvlD/ApDFG6W/5cxG XLkSkZwrNqFP/AC6ovFgY6vcD7/OzWvvKWagp9jC7LvH/apZeC4ddgK+JcWxKxqmjhUy7TF2dCnJM YBn/nqdWgt3LZDjUPCN2OFzeKexCRmT3w73qmoMSNUIAIprbpAUfg8wUdCHP6OmavHQj2NsLSPYIy kS3aiUB16+yUMOE3VANbNEfOW+4ZQcNOQHJepmHj1nfzYL0aM37avePz6Kk+PB/9yD9uHs6ICJOcW HQIP14TRXQjlvQiHt5rDd4qy6eYxhmyREQ+lTQuZwRH2L21o41Ryc9VO1Enub5koF1hHmCH6jTP99 jjOtzfwg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uYx2c-00GyHK-6v for pgsql-committers@lists.postgresql.org; Tue, 08 Jul 2025 01:22:38 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uYx2b-005Blr-0P for pgsql-committers@lists.postgresql.org; Tue, 08 Jul 2025 01:22:37 +0000 Content-Type: multipart/mixed; boundary="===============2472810655060839390==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Consider explicit incremental sort for Append and MergeAppend X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 08 Jul 2025 01:22:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2472810655060839390== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29uc2lkZXIgZXhwbGljaXQgaW5jcmVtZW50YWwgc29ydCBmb3IgQXBwZW5kIGFuZCBNZXJnZUFw cGVuZAoKRm9yIGFuIG9yZGVyZWQgQXBwZW5kIG9yIE1lcmdlQXBwZW5kLCB3ZSBuZWVkIHRvIGlu amVjdCBhbiBleHBsaWNpdApzb3J0IGludG8gYW55IHN1YnBhdGggdGhhdCBpcyBub3QgYWxyZWFk eSB3ZWxsIGVub3VnaCBvcmRlcmVkLgpDdXJyZW50bHksIG9ubHkgZXhwbGljaXQgZnVsbCBzb3J0 cyBhcmUgY29uc2lkZXJlZDsgaW5jcmVtZW50YWwgc29ydHMKYXJlIG5vdCB5ZXQgdGFrZW4gaW50 byBhY2NvdW50LgoKSW4gdGhpcyBwYXRjaCwgZm9yIHN1YnBhdGhzIG9mIGFuIG9yZGVyZWQgQXBw ZW5kIG9yIE1lcmdlQXBwZW5kLCB3ZQpjaG9vc2UgdG8gdXNlIGV4cGxpY2l0IGluY3JlbWVudGFs IHNvcnQgaWYgaXQgaXMgZW5hYmxlZCBhbmQgdGhlcmUgYXJlCnByZXNvcnRlZCBrZXlzLgoKVGhl IHJhdGlvbmFsZSBpcyBiYXNlZCBvbiB0aGUgYXNzdW1wdGlvbiB0aGF0IGluY3JlbWVudGFsIHNv cnQgaXMKYWx3YXlzIGZhc3RlciB0aGFuIGZ1bGwgc29ydCB3aGVuIHRoZXJlIGFyZSBwcmVzb3J0 ZWQga2V5cywgYSBwcmVtaXNlCnRoYXQgaGFzIGJlZW4gYXBwbGllZCBpbiB2YXJpb3VzIHBhcnRz IG9mIHRoZSBjb2RlLiAgSW4gYWRkaXRpb24sIHRoZQpjdXJyZW50IGNvc3QgbW9kZWwgdGVuZHMg dG8gZmF2b3IgaW5jcmVtZW50YWwgc29ydCBhcyBiZWluZyBjaGVhcGVyCnRoYW4gZnVsbCBzb3J0 IGluIHRoZSBwcmVzZW5jZSBvZiBwcmVzb3J0ZWQga2V5cywgbWFraW5nIGl0IHJlYXNvbmFibGUK bm90IHRvIGNvbnNpZGVyIGZ1bGwgc29ydCBpbiBzdWNoIGNhc2VzLgoKTm8gYmFja3BhdGNoIGFz IHRoaXMgY291bGQgcmVzdWx0IGluIHBsYW4gY2hhbmdlcy4KCkF1dGhvcjogUmljaGFyZCBHdW8g PGd1b2ZlbmdsaW51eEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbmRyZWkgTGVwaWtob3YgPGxl cGlob3ZAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogUm9iZXJ0IEhhYXMgPHJvYmVydG1oYWFzQGdt YWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0X1Y3YTJlblRS K1QzcE9ZX1laLUZVOFpzRll5bTJzd096NGpOTXFtU2d5dXdAbWFpbC5nbWFpbC5jb20KCkJyYW5j aAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi81NWE3ODBlOTQ3NmE3NTMzNTRhNmRiODg3ZTkyMTI1Yzc4ODZjYTZk CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0 aC9jb3N0c2l6ZS5jICAgICAgICAgIHwgNTQgKysrKysrKysrKysrKystLS0tLQpzcmMvYmFja2Vu ZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgICAgICAgIHwgNjYgKysrKysrKysrKysrKysr KysrKystLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcGF0aG5vZGUuYyAgICAgICAgICB8 IDczICsrKysrKysrKysrKysrKysrLS0tLS0tLS0tCnNyYy9pbmNsdWRlL29wdGltaXplci9jb3N0 LmggICAgICAgICAgICAgICAgICAgfCAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2lu Y3JlbWVudGFsX3NvcnQub3V0IHwgNDAgKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9pbmhlcml0Lm91dCAgICAgICAgICB8IDEwICsrLS0Kc3JjL3Rlc3QvcmVncmVzcy9z cWwvaW5jcmVtZW50YWxfc29ydC5zcWwgICAgICB8IDI0ICsrKysrKysrKwo3IGZpbGVzIGNoYW5n ZWQsIDIxNyBpbnNlcnRpb25zKCspLCA1MiBkZWxldGlvbnMoLSkKCg== --===============2472810655060839390==--