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 1vnGUD-004PXI-1n for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Feb 2026 13:30:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vnGUB-004tZC-2G for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Feb 2026 13:30:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vnGUA-004tZ3-28 for pgsql-hackers@lists.postgresql.org; Tue, 03 Feb 2026 13:30:31 +0000 Received: from out162-62-57-252.mail.qq.com ([162.62.57.252]) by makus.postgresql.org with utf8esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vnGU4-00000000MXz-3hzx for pgsql-hackers@postgresql.org; Tue, 03 Feb 2026 13:30:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1770125417; bh=AIr+2fzBuO42AxSf95lAlrrNSFm9OCtw5pb8+LDtGEA=; h=From:To:Cc:Subject:Date:References:In-Reply-To; b=MK3a2RbunW8dPdjVaWW58X1YlcmYzkJg6RR0SDj3irYpw/pYXdbkrFdxPMX/HY2OM fKFMIF1H2JlFYdk4cqc7nRlGZOHG2JzV6jAn2+SrPKoXu50h3z/9SgkDsNcnkR2Qdm xYTNbZ1RMvHSJQr5ATieD/wgYGIShGe9FIWhtmj8= X-QQ-XMRINFO: NS+P29fieYNwqS3WCnRCOn9D1NpZuCnCRA== X-QQ-XMAILINFO: MMvVzQSdFuTp8PfZOwgNkTXRc/tAMDQ4ROIdDCp5x8sKXg+hexO7kmoId9RwiY DTk2+OZFeGgsJLUmp10wzqR675i1vKqR5Zr/0OzG7hu7Q4pjWNc8UUzTuR4NGO+1+8LnYsVw3zTpJ NBzI1FjLLy0yGiz3HbybryzSu6eQC2E9Vh06Y9sKxRAEbmSQsDtbkOADVyTzJSSd32Z727eAF8vvy hc9qS8Bo4S/PO5rhzvTszq5rM7UTZ/iFYK8ldoyKS+BDwsGCdwfY/ofOSG0KEnyfhN+Zl4Q6RiCfi YXLU1n/NvJeD2PuRZeRNlThQUH8C4WdIBDU9RfgC8UJiD/C+KkHUpH7RkcDs8vJc979qm8Y1NJIDZ 4McnRm9j158Jdf0qu+lEo3/txlV2waB1fLk1PPsw3azn5FhtgX1u5hqZ5YzxBRR2XSn7BH+bDIqKk M5voDAVkK1jEiffEgOzz0/npy87imQXq9vKGPpIenzpt62YxKmKZ9YDzWOTudazvBkhrRfhpwI3CV aex9vN1yVxXG0swdk39GPgtIvC6q1HXuHaYeT6Q/TQDKcDeNC4GOBd6LQ+qe1TUG3TzkL+808g0dh zMoQBd01xU0tfFfloUwR8Ejb0n53mlexv8LhXfqK7DG1t+zRlS9zPa0DSNZXYDQHWWCdM7K8AHzVJ 4F4AKQUQ8HkeuSJ7VP8f6aRbTmYACJk5Av4KBEvjyrWmp7sE+Xyv2BMu+Z2NYxNVcwdWhYFwMGQTo NLJGX3S+/9GOQy7CCo2PsArEapPjTvmP4BNCFr9Fen905Ny6uHLcBsQTAmmh7VHZbUh6ElomcAqOg JYmNi0IlK5lraVQSO94x1z1Jm0U7AWHHdVtKZ+cHxDoXFzczto89GLwBcLRx1GG/O4AHfKdfCr6HP sNp5K2SpR/0PyoTxkmfDdG3IkGqajrwZEUVNjAtIUYPna0L0m4oIpov46u9QiAvFpX2vi1qHsVGON XaYbBHWAsWAyXcAWdiJxZxvYkZoFRDU35RFY14jvSd4DxvAXIfXezqTTozDWceDbK4Gx+rIxwt774 ogV+w2UJdsLLfmFRhq2CpIdk6HQFpgrLoDOl8dfYlB8prOk8= From: "=?utf-8?B?Y2NhNTUwNw==?=" To: "=?utf-8?B?SnVud2FuZyBaaGFv?=" , "=?utf-8?B?QW1pdCBMYW5nb3Rl?=" Cc: "=?utf-8?B?RGFuaWlsIERhdnlkb3Y=?=" <3danissimo@gmail.com>, "=?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: Tue, 3 Feb 2026 21:30:15 +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-0t1770125415thdyb9vje List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNClNvbWUgY29tbWVudHMgZm9yIHY1Og0KDQowMDAxDQo9PT09DQoNCjEpIGhlYXBf YmVnaW5fYmF0Y2goKQ0KDQpgYGANCgkvKiBTaW5nbGUgYWxsb2NhdGlvbiBmb3IgSGVhcEJh dGNoIGhlYWRlciArIHR1cGRhdGEgYXJyYXkgKi8NCglhbGxvY19zaXplID0gc2l6ZW9mKEhl YXBCYXRjaCkgKyBzaXplb2YoSGVhcFR1cGxlRGF0YSkgKiBtYXhpdGVtczsNCgloYiA9IHBh bGxvYyhhbGxvY19zaXplKTsNCgloYi0+dHVwZGF0YSA9IChIZWFwVHVwbGVEYXRhICopICgo Y2hhciAqKSBoYiArIHNpemVvZihIZWFwQmF0Y2gpKTsNCmBgYA0KDQpEbyB3ZSBuZWVkIGEg TUFYQUxJR04oKSBoZXJlIHRvIGF2b2lkIHVuYWxpZ25lZCBhY2Nlc3M/IFNvbWV0aGluZyBs aWtlIHRoaXM6DQoNCmBgYA0KCS8qIFNpbmdsZSBhbGxvY2F0aW9uIGZvciBIZWFwQmF0Y2gg aGVhZGVyICsgdHVwZGF0YSBhcnJheSAqLw0KCWFsbG9jX3NpemUgPSBNQVhBTElHTihzaXpl b2YoSGVhcEJhdGNoKSkgKyBzaXplb2YoSGVhcFR1cGxlRGF0YSkgKiBtYXhpdGVtczsNCglo YiA9IHBhbGxvYyhhbGxvY19zaXplKTsNCgloYi0+dHVwZGF0YSA9IChIZWFwVHVwbGVEYXRh ICopICgoY2hhciAqKSBoYiArIE1BWEFMSUdOKHNpemVvZihIZWFwQmF0Y2gpKSk7DQpgYGAN Cg0KT3IgaG93IGFib3V0IGp1c3QgdXNpbmcgemVyby1sZW5ndGggYXJyYXk6DQoNCmBgYA0K dHlwZWRlZiBzdHJ1Y3QgSGVhcEJhdGNoDQp7DQoJQnVmZmVyCQkJYnVmOw0KCWludAkJCQlt YXhpdGVtczsNCglpbnQJCQkJbml0ZW1zOw0KCUhlYXBUdXBsZURhdGEJdHVwZGF0YVtGTEVY SUJMRV9BUlJBWV9NRU1CRVJdOw0KfSBIZWFwQmF0Y2g7DQoNCi8vIGFuZA0KaGIgPSBwYWxs b2Mob2Zmc2V0b2YoSGVhcEJhdGNoLCB0dXBkYXRhKSArIHNpemVvZihIZWFwVHVwbGVEYXRh KSAqIG1heGl0ZW1zKTsNCmBgYA0KDQoyKSBwZ3N0YXRfY291bnRfaGVhcF9nZXRuZXh0X2Jh dGNoKCkNCg0KYGBgDQojZGVmaW5lIHBnc3RhdF9jb3VudF9oZWFwX2dldG5leHRfYmF0Y2go cmVsLCBuKQkJCQkJCVwNCglkbyB7CQkJCQkJCQkJCQkJCQkJXA0KCQlpZiAocGdzdGF0X3No b3VsZF9jb3VudF9yZWxhdGlvbihyZWwpKQkJCQkJCVwNCgkJCShyZWwpLT5wZ3N0YXRfaW5m by0+Y291bnRzLnR1cGxlc19yZXR1cm5lZCArPSBuOwkJXA0KCX0gd2hpbGUgKDApDQpgYGAN Cg0KIis9IG4iIC0+ICIrPSAobikiLCBqdXN0IGxpa2UgcGdzdGF0X2NvdW50X2luZGV4X3R1 cGxlcygpLg0KDQowMDAyDQo9PT09DQoNCjEpIFR1cGxlQmF0Y2hDcmVhdGUoKQ0KDQpgYGAN CgkvKiBTaW5nbGUgYWxsb2NhdGlvbiBmb3IgVHVwbGVCYXRjaCArIGluc2xvdHMgKyBvdXRz bG90cyBhcnJheXMgKi8NCglhbGxvY19zaXplID0gc2l6ZW9mKFR1cGxlQmF0Y2gpICsgMiAq IHNpemVvZihUdXBsZVRhYmxlU2xvdCAqKSAqIGNhcGFjaXR5Ow0KCWIgPSBwYWxsb2MoYWxs b2Nfc2l6ZSk7DQoJaW5zbG90cyA9IChUdXBsZVRhYmxlU2xvdCAqKikgKChjaGFyICopIGIg KyBzaXplb2YoVHVwbGVCYXRjaCkpOw0KCW91dHNsb3RzID0gKFR1cGxlVGFibGVTbG90ICoq KSAoKGNoYXIgKikgYiArIHNpemVvZihUdXBsZUJhdGNoKSArDQoJCXNpemVvZihUdXBsZVRh YmxlU2xvdCAqKSAqIGNhcGFjaXR5KTsNCmBgYA0KDQpEbyB3ZSBuZWVkIGEgTUFYQUxJR04o KSBoZXJlIHRvIGF2b2lkIHVuYWxpZ25lZCBhY2Nlc3M/DQoNCjIpIFR1cGxlQmF0Y2hSZXNl dCgpDQoNCmBgYA0KCWZvciAoaW50IGkgPSAwOyBpIDwgYi0+bWF4c2xvdHM7IGkrKykNCgl7 DQoJCUV4ZWNDbGVhclR1cGxlKGItPmluc2xvdHNbaV0pOw0KCQlpZiAoZHJvcF9zbG90cykN CgkJCUV4ZWNEcm9wU2luZ2xlVHVwbGVUYWJsZVNsb3QoYi0+aW5zbG90c1tpXSk7DQoJfQ0K YGBgDQoNCkV4ZWNEcm9wU2luZ2xlVHVwbGVUYWJsZVNsb3QoKSB3aWxsIGNhbGwgRXhlY0Ns ZWFyVHVwbGUoKSwgc28gRXhlY0NsZWFyVHVwbGUoKSB3aWxsIGJlDQpjYWxsZWQgdHdpY2Ug aWYgZHJvcF9zbG90cyBpcyB0cnVlLCBJIHRoaW5rIHdlIGNhbiBhdm9pZCB0aGlzLg0KDQoz KSBTY2FuQ2FuVXNlQmF0Y2hpbmcoKQ0KDQpJbiBoZWFwX2JlZ2luc2NhbigpLCB3ZSBtYXkg ZGlzYWJsZSBwYWdlLWF0LWEtdGltZSBtb2RlOg0KDQpgYGANCgkvKg0KCSAqIERpc2FibGUg cGFnZS1hdC1hLXRpbWUgbW9kZSBpZiBpdCdzIG5vdCBhIE1WQ0Mtc2FmZSBzbmFwc2hvdC4N CgkgKi8NCglpZiAoIShzbmFwc2hvdCAmJiBJc01WQ0NTbmFwc2hvdChzbmFwc2hvdCkpKQ0K CQlzY2FuLT5yc19iYXNlLnJzX2ZsYWdzICY9IH5TT19BTExPV19QQUdFTU9ERTsNCmBgYA0K DQpJdCBzZWVtcyB0aGF0IFNjYW5DYW5Vc2VCYXRjaGluZygpIGRpZG4ndCBjb25zaWRlciB0 aGlzLg0KDQo0KSBzdHJ1Y3QgVHVwbGVCYXRjaA0KDQpgYGANCglzdHJ1Y3QgVHVwbGVUYWJs ZVNsb3QgKippbnNsb3RzOyAvKiBzbG90cyBmb3IgdHVwbGVzIHJlYWQgImludG8iIGJhdGNo ICovDQoJc3RydWN0IFR1cGxlVGFibGVTbG90ICoqb3V0c2xvdHM7IC8qIHNsb3RzIGZvciB0 dXBsZXMgZ29pbmcgIm91dCBvZiINCgkJCQkJCQkJCSAgICogYmF0Y2ggKi8NCglzdHJ1Y3Qg VHVwbGVUYWJsZVNsb3QgKiphY3RpdmVzbG90czsNCmBgYA0KDQpJIHRoaW5rIHdlIGNhbiBy ZW1vdmUgdGhlIHdvcmQgInN0cnVjdCIuDQoNCjUpIEV4ZWNTY2FuRXh0ZW5kZWRCYXRjaFNs b3QoKQ0KDQpgYGANCgkJLyogR2V0IG5leHQgaW5wdXQgc2xvdCBmcm9tIGN1cnJlbnQgYmF0 Y2gsIG9yIHJlZmlsbCAqLw0KCQlpZiAoIVR1cGxlQmF0Y2hIYXNNb3JlKGIpKQ0KCQl7DQoJ CQlpZiAoIWFjY2Vzc0JhdGNoTXRkKG5vZGUpKQ0KCQkJCXJldHVybiBOVUxMOw0KCQl9DQpg YGANCg0KSSB0aGluayB3ZSBjYW5ub3QganVzdCByZXR1cm4gTlVMTCBoZXJlLCBzZWUgY29t bWVudHMgaW4gRXhlY1NjYW5FeHRlbmRlZCgpOg0KDQpgYGANCgkJLyoNCgkJICogaWYgdGhl IHNsb3QgcmV0dXJuZWQgYnkgdGhlIGFjY2Vzc010ZCBjb250YWlucyBOVUxMLCB0aGVuIGl0 IG1lYW5zDQoJCSAqIHRoZXJlIGlzIG5vdGhpbmcgbW9yZSB0byBzY2FuIHNvIHdlIGp1c3Qg cmV0dXJuIGFuIGVtcHR5IHNsb3QsDQoJCSAqIGJlaW5nIGNhcmVmdWwgdG8gdXNlIHRoZSBw cm9qZWN0aW9uIHJlc3VsdCBzbG90IHNvIGl0IGhhcyBjb3JyZWN0DQoJCSAqIHR1cGxlRGVz Yy4NCgkJICovDQoJCWlmIChUdXBJc051bGwoc2xvdCkpDQoJCXsNCgkJCWlmIChwcm9qSW5m bykNCgkJCQlyZXR1cm4gRXhlY0NsZWFyVHVwbGUocHJvakluZm8tPnBpX3N0YXRlLnJlc3Vs dHNsb3QpOw0KCQkJZWxzZQ0KCQkJCXJldHVybiBzbG90Ow0KCQl9DQpgYGANCg0KQW5kIHdo eSBub3QganVzdCB3cml0ZSB0aGlzIGZ1bmN0aW9uIGxpa2UgRXhlY1NjYW5FeHRlbmRlZCgp IGFuZCBFeGVjU2NhbkZldGNoKCk/DQoNCi0tDQpSZWdhcmRzLA0KQ2hhbmdBbyBDaGVuDQo=