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.96) (envelope-from ) id 1vXeMV-000QOO-38 for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Dec 2025 11:46:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXeMU-00EbD4-30 for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Dec 2025 11:46:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from <2624345507@qq.com>) id 1vXeMT-00EbCw-2y for pgsql-hackers@lists.postgresql.org; Mon, 22 Dec 2025 11:46:03 +0000 Received: from out162-62-58-216.mail.qq.com ([162.62.58.216]) by magus.postgresql.org with utf8esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from <2624345507@qq.com>) id 1vXeMP-0023zv-2A for pgsql-hackers@postgresql.org; Mon, 22 Dec 2025 11:46:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1766403952; bh=hSvo7yZ1t6facjbh8A2by67TQhSYzShtcAavzq2K158=; h=From:To:Cc:Subject:Date:References:In-Reply-To; b=D1TM8tUKQf1C6swWqesChVbCqb7bdGUw4jgdso2pBKNtusG2aXWCW13oMlHZAVzYF tlZxKyhj4F6EHYzqU8HkkbYpM84Te/C0ORu8cEEZ9wXvfsfAf43fc2nkl4cs3Lkk+C vnGvoCQYgf0yq2065xPHvzDA/b/GVSN1dWkEst7c= X-QQ-XMRINFO: Nq+8W0+stu50tPAe92KXseR0ZZmBTk3gLg== X-QQ-XMAILINFO: MGJQUKeBeYZp2NxPW5GGotejPpOaMb9dWmkgVT6g4fa8gNoN9a+ki38GN/WCpA i7KgXElPc7+OUc6s8R5jEVkEed5SWft5P8OZVZZC/bcMSuiCxCTGRhImwuMSo+rGkRlaoII+apzFa 16OB6c2RhVrMTZ7VilPiDeGRR8eoN0IHwqMRspqRZJyzgofHXBfBT0mxuvnpQeWM6btF446q+UbtM oE2cM2Ydc15RtBvmR6XzI6LWZFCy/uCsP2/fJh8DA9XkbbrbKYdrbvamzbyV3uwv4a4HYP4Gq9nIa mT8U3e8k/7krnGB51DI8xSER8wajQj10PO/Q8kktu+eSRe3r2EgWv5cF4RTnyhian+jIcl+pX6En7 Y1OORSm4iHCu3SPAdBGCxmRJ8j+napgvl6boq14f5x1g1Kxqpbwd9Q9hQZ+DM4ocDYaGpI3K4Rcxf da4CLfDJ9eaGD6nFWyENmJeyw4rAt/FsibNn/Jbr7nb5HaaiX1EQlE4jaEiRJr3MsDI8ACCmSNiLk Loo801kVWEq6tE+DxLgQTcsMbE4y3XkFmhw3wFsAPpIdKRoc3DmxLXU+Dm2pinj+SH8A5EYhMB2w6 8GqMGtb6fvONRbLj+uoYWqXaFlWvcEn8FfY4oHiN8qqrrLRx5kI+XSRvVAZaa7ATcnsBepidgxLf5 6/mFcOUN3t0bQvZGyzuZIwP0OYIa6iiri5yW3UeAfSOnQebKGhk+JPfWFL6TNo+hNqjniuGwukzn2 v+S/JQQcq0UWQETkjmjbST3DEeuuyW/y8pECIUNqtAgH1teDj8Cexh5szBbWCRKd8VklY3/NCJ6ip v2jC9RlDDOihOcWd3x1RlevUjEWX8ofdak1EMmnGwH168V/TSD8OjmUORqygdBJVKj+Bat14MzizE I4VFka0tGtpirobN7ptHNDTpDoveXQF4LEyJIbJWw4WLZ8uDa6XWAG8dvsqyVpwAOK3w+HwsIQurY KfTp59dcbPrg6fcEi82L5OlcAftyINUx6VyuyR/SFWP5N0XGtFHa48T5aV0VoLy8fkwUXndQUB9QH UNaTGitUNS9s0qPU= From: "=?utf-8?B?Y2NhNTUwNw==?=" <2624345507@qq.com> To: "=?utf-8?B?QW1pdCBMYW5nb3Rl?=" Cc: "=?utf-8?B?UG9zdGdyZVNRTC1kZXZlbG9wbWVudA==?=" , "=?utf-8?B?VG9tYXMgVm9uZHJh?=" Subject: Re: Batching in executor Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Date: Mon, 22 Dec 2025 19:45:49 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x References: <68f3771f-91f5-4cb7-b1de-74d9abbf0b96@vondra.me> In-Reply-To: X-QQ-mid: xmseza62-0t1766403949txckypliw List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNClNvbWUgY29tbWVudHMgZm9yIHY0Og0KDQowMDAxDQo9PT09DQoNCjEpIHRhYmxl X3NjYW5fZ2V0bmV4dGJhdGNoKCkNCiJBc3NlcnQoZGlyID09IEZvcndhcmRTY2FuRGlyZWN0 aW9uKTsiIC0+ICJBc3NlcnQoU2NhbkRpcmVjdGlvbklzRm9yd2FyZChkaXIpKTsiDQoNCjIp IGhlYXBnZXR0dXBfcGFnZW1vZGVfYmF0Y2goKQ0KIlR1cGxlRGVzYwl0dXBkZXNjID0ga2V5 ID8gUmVsYXRpb25HZXREZXNjcihyZWwpIDogTlVMTDsiIC0+ICJUdXBsZURlc2MJdHVwZGVz YyA9IFJlbGF0aW9uR2V0RGVzY3IocmVsKTsiDQpJIHRoaW5rIHRoZSBsYXR0ZXIgaXMgZW5v dWdoLg0KDQozKSBoZWFwZ2V0dHVwX3BhZ2Vtb2RlX2JhdGNoKCkNCmBgYA0KCQkJLyogQXJl IHRoZXJlIG1vcmUgdmlzaWJsZSB0dXBsZXMgbGVmdCBvbiB0aGlzIHBhZ2U/ICovDQoJCQls aW5laW5kZXggPSBzY2FuLT5yc19jaW5kZXggKyBkaXI7DQoJCQlsaW5lc2xlZnQgPSAobGlu ZWluZGV4IDw9ICh1aW50MzIpIHNjYW4tPnJzX250dXBsZXMpID8NCgkJCQkoc2Nhbi0+cnNf bnR1cGxlcyAtIGxpbmVpbmRleCkgOiAwOw0KCQkJaWYgKGxpbmVzbGVmdCA+IDApDQoJCQkJ YnJlYWs7CS8qIGNvbnRpbnVlIG9uIHRoaXMgcGFnZSAqLw0KYGBgDQpUaGUgInNjYW4tPnJz X250dXBsZXMiIGlzIGFscmVhZHkgYW4gdWludDMyLg0KDQo0KSBoZWFwZ2V0dHVwX3BhZ2Vt b2RlX2JhdGNoKCkNCmBgYA0KCQlBc3NlcnQobGluZWluZGV4IDw9ICh1aW50MzIpIHNjYW4t PnJzX250dXBsZXMpOw0KYGBgDQpUaGUgInNjYW4tPnJzX250dXBsZXMiIGlzIGFscmVhZHkg YW4gdWludDMyLiBBbmQgSSB0aGluayB0aGlzIHNob3VsZCBiZSAiQXNzZXJ0KGxpbmVpbmRl eCA8IHNjYW4tPnJzX250dXBsZXMpOyIsIHRoZSByZWxhdGVkDQphc3NlcnQgaW4gaGVhcGdl dHR1cF9wYWdlbW9kZSgpIGlzIGFsc28gd3JvbmcuDQoNCjUpIGhlYXBnZXR0dXBfcGFnZW1v ZGVfYmF0Y2goKQ0KSWYgdGhlIHNjYW4ga2V5IGZpbHRlcnMgb3V0IGFsbCB0dXBsZXMgb24g YSBwYWdlLCB3ZSBtYXkgcmV0dXJuIDAgYmVmb3JlIHJlYWNoaW5nIHRoZSBlbmQgb2Ygc2Nh biwgcmlnaHQ/DQoNCjYpIGhlYXBfYmVnaW5fYmF0Y2goKQ0KYGBgDQoJaGIgPSBwYWxsb2Mo c2l6ZW9mKEhlYXBCYXRjaCkpOw0KCWhiLT50dXBkYXRhID0gcGFsbG9jKHNpemVvZihIZWFw VHVwbGVEYXRhKSAqIG1heGl0ZW1zKTsNCmBgYA0KQ2FuIHdlIGp1c3QgdXNlIG9uZSBwYWxs b2MoKSBmb3IgY2FjaGUtZnJpZW5kbHk/DQoNCjAwMDINCj09PT0NCg0KMSkgaGVhcF9tYXRl cmlhbGl6ZV9iYXRjaF9hbGwoKQ0KYGBgDQoJCXNsb3QtPmJhc2UudHRzX2ZsYWdzICY9IH4o VFRTX0ZMQUdfRU1QVFkgfCBUVFNfRkxBR19TSE9VTERGUkVFKTsNCgkJc2xvdC0+YmFzZS50 dHNfdGlkID0gdHVwbGUtPnRfc2VsZjsNCgkJc2xvdC0+YmFzZS50dHNfdGFibGVPaWQgPSB0 dXBsZS0+dF90YWJsZU9pZDsNCgkJc2xvdC0+YmFzZS50dHNfZmxhZ3MgJj0gfihUVFNfRkxB R19TSE9VTERGUkVFIHwgVFRTX0ZMQUdfRU1QVFkpOw0KYGBgDQpSZWR1bmRhbnQgb2YgInNs b3QtPmJhc2UudHRzX2ZsYWdzICY9Ij8NCg0KMikgVHVwbGVCYXRjaENyZWF0ZSgpDQpgYGAN CglpbnNsb3RzID0gcGFsbG9jKHNpemVvZihUdXBsZVRhYmxlU2xvdCAqKSAqIGNhcGFjaXR5 KTsNCglvdXRzbG90cyA9IHBhbGxvYyhzaXplb2YoVHVwbGVUYWJsZVNsb3QgKikgKiBjYXBh Y2l0eSk7DQoJZm9yIChpbnQgaSA9IDA7IGkgPCBjYXBhY2l0eTsgaSsrKQ0KCQlpbnNsb3Rz W2ldID0gTWFrZVNpbmdsZVR1cGxlVGFibGVTbG90KHNjYW5kZXNjLCAmVFRTT3BzSGVhcFR1 cGxlKTsNCg0KCWIgPSAoVHVwbGVCYXRjaCAqKSBwYWxsb2Moc2l6ZW9mKFR1cGxlQmF0Y2gp KTsNCmBgYA0KQ2FuIHdlIGp1c3QgdXNlIG9uZSBwYWxsb2MoKSBmb3IgY2FjaGUtZnJpZW5k bHk/DQoNCjMpIFR1cGxlQmF0Y2hDcmVhdGUoKQ0KYGBgDQoJYi0+b3V0c2xvdHMgPSBvdXRz bG90czsNCgliLT5hY3RpdmVzbG90cyA9IE5VTEw7DQoJYi0+b3V0c2xvdHMgPSBvdXRzbG90 czsNCmBgYA0KUmVkdW5kYW50IG9mICJiLT5vdXRzbG90cyA9IG91dHNsb3RzOyI/DQoNCjQp IFR1cGxlQmF0Y2hSZXNldCgpDQpgYGANCglpZiAoYiA9PSBOVUxMKQ0KCQlyZXR1cm47DQpg YGANClRoaXMgY2FuIG5ldmVyIGhhcHBlbiwgY29udmVydCB0byBhIGFzc2VydCBvciBqdXN0 IGRlbGV0ZSBpdD8NCg0KNSkgU2VxTmV4dEJhdGNoKCkNCiJBc3NlcnQoZGlyZWN0aW9uID09 IEZvcndhcmRTY2FuRGlyZWN0aW9uKTsiIC0+ICJBc3NlcnQoU2NhbkRpcmVjdGlvbklzRm9y d2FyZChkaXJlY3Rpb24pKTsiDQoNCi0tDQpSZWdhcmRzLA0KQ2hhbmdBbyBDaGVuDQo=