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 1ugAbY-00GpU8-1W for pgsql-committers@arkaria.postgresql.org; Sun, 27 Jul 2025 23:16:32 +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 1ugAbX-002QyN-6p for pgsql-committers@arkaria.postgresql.org; Sun, 27 Jul 2025 23:16:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ugAbX-002QyE-08 for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:31 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ugAbT-001C43-2Q for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:30 +0000 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 1ugAbR-0037iF-GI for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ugAbR-001379-35 for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:26 +0000 Content-Type: multipart/mixed; boundary="===============5269757615777976208==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix performance regression with flush of pending fixed-numbered X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 27 Jul 2025 23:16:26 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5269757615777976208== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBlcmZvcm1hbmNlIHJlZ3Jlc3Npb24gd2l0aCBmbHVzaCBvZiBwZW5kaW5nIGZpeGVkLW51 bWJlcmVkIHN0YXRzCgpUaGUgY2FsbGJhY2sgYWRkZWQgaW4gZmM0MTVlZGY4Y2E4IHVzZWQgdG8g Y2hlY2sgaWYgdGhlcmUgaXMgYW55IHBlbmRpbmcKZGF0YSB0byBmbHVzaCBmb3IgZml4ZWQtbnVt YmVyZWQgc3RhdGlzdGljcywgZG9uZSBieSBsb29waW5nIGFjcm9zcyBhbGwKdGhlIGJ1aWx0aW4g YW5kIGN1c3RvbSBzdGF0cyBraW5kcyB3aXRoIGEgY2FsbCB0byBoYXZlX2ZpeGVkX3BlbmRpbmdf Y2IsCmlzIHByb3ZpbmcgdG8gYWJsZSB0byBzaG93IGluIHdvcmtsb2FkcyB0aGF0IGRvIG5vdCBy ZXBvcnQgYW55IHN0YXRzCihyZWFkLW9ubHksIG5vIGZ1bmN0aW9uIGNhbGxzLCBubyBXQUwsIG5v IElPLCBldGMpLiAgVGhlIGNvZGUgdXNlZCBpbgp2MTcgd2FzIGNoZWFwZXIgdGhhbiB0aGF0IHdo YXQgSEVBRCBoYXMgaW50cm9kdWNlZCwgcmVseWluZyBvbiB0aHJlZQpib29sZWFuIGNoZWNrcyBm b3IgV0FMLCBTTFJVIGFuZCBJTyBzdGF0cy4KClRoaXMgY29tbWl0IHN3aXRjaGVzIHRoZSBjb2Rl IHRvIHVzZSBhIG1vcmUgZWZmaWNpZW50IGFwcHJvYWNoIHRoYW4KZmM0MTVlZGY4Y2E4LCB3aXRo IGEgc2luZ2xlIGJvb2xlYW4gZmxhZyB0aGF0IGNhbiBiZSBzd2l0Y2hlZCB0byAidHJ1ZSIKYnkg YW55IGZpeGVkLW51bWJlcmVkIHN0YXRzIGtpbmRzIHRvIGZvcmNlIHBnc3RhdF9yZXBvcnRfc3Rh dCgpIHRvIGdvCnRocm91Z2ggb25lIHJvdW5kIG9mIHJlcG9ydHMuICBUaGUgZmxhZyBpcyByZXNl dCBieSBwZ3N0YXRfcmVwb3J0X3N0YXQoKQpvbmNlIGEgZnVsbCByb3VuZCBvZiByZXBvcnRzIGlz IGRvbmUuICBUaGUgZmxhZyBiZWluZyBmYWxzZSBtZWFucyB0aGF0CmZpeGVkLW51bWJlcmVkIHN0 YXRzIGtpbmRzIHNhdyBubyBhY3Rpdml0eSwgYW5kIHRoYXQgdGhlcmUgaXMgbm8gcGVuZGluZwpk YXRhIHRvIGZsdXNoLgoKYWMwMDBmY2E3NDNlIHRvb2sgb25lIHN0ZXAgaW4gaW1wcm92aW5nIHRo ZSBwZXJmb3JtYW5jZSBieSByZWR1Y2luZyB0aGUKbnVtYmVyIG9mIHN0YXRzIGtpbmRzIHRoYXQg dGhlIGJhY2tlbmQgY2FuIGhvbGQuICBUaGlzIGNvbW1pdCB0YWtlcyBhCm1vcmUgZHJhc3RpYyBz dGVwIGJ5IGJyaW5naW5nIGJhY2sgdGhlIGNvZGUgZWZmaWNpZW5jeSB0byB3aGF0IGl0IHdhcwpi ZWZvcmUgdjE4IHdpdGggYSBjaGVhcCBjaGVjayBhdCB0aGUgYmVnaW5uaW5nIG9mIHBnc3RhdF9y ZXBvcnRfc3RhdCgpCmZvciBpdHMgZmFzdC1leGl0IHBhdGguCgpUaGUgY2FsbGJhY2sgaGF2ZV9z dGF0aWNfcGVuZGluZ19jYiBpcyByZW1vdmVkIGFzIGFuIGVmZmVjdCBvZiBhbGwgdGhhdC4KClJl cG9ydGVkLWJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+ClJldmlld2VkLWJ5 OiBCZXJ0cmFuZCBEcm91dm90IDxiZXJ0cmFuZGRyb3V2b3QucGdAZ21haWwuY29tPgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2ViMjI0dWVnc2dhMmhncTdkZnEzcHM1Y2R1aHBxZWo3 aXIyaGp4enpvemp0aHJla3g1QGR5c2VpNmJ1cXRoZQpCYWNrcGF0Y2gtdGhyb3VnaDogMTgKCkJy YW5jaAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBv c3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMTNlYjZiYjc2ZDVkZTFkNWMzYWUzYTgwNjg0ZTZh MGRhNTMxNDgxNwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNj ZXNzL3RyYW5zYW0veGxvZy5jICAgICAgICAgICB8IDEwICsrKysrKwpzcmMvYmFja2VuZC91dGls cy9hY3Rpdml0eS9wZ3N0YXQuYyAgICAgICAgIHwgNTIgKysrKysrKysrKystLS0tLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZpdHkvcGdzdGF0X2JhY2tlbmQuYyB8IDE0ICsr LS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3Bnc3RhdF9pby5jICAgICAgfCAxMCAr LS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZpdHkvcGdzdGF0X3NscnUuYyAgICB8IDEwICst LS0tLQpzcmMvYmFja2VuZC91dGlscy9hY3Rpdml0eS9wZ3N0YXRfd2FsLmMgICAgIHwgMjAgKysr KystLS0tLS0Kc3JjL2luY2x1ZGUvdXRpbHMvcGdzdGF0X2ludGVybmFsLmggICAgICAgICB8IDM0 ICsrKysrKysrKystLS0tLS0tLS0KNyBmaWxlcyBjaGFuZ2VkLCA2MiBpbnNlcnRpb25zKCspLCA4 OCBkZWxldGlvbnMoLSkKCg== --===============5269757615777976208==--