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 1ugAdJ-00GprO-UP for pgsql-committers@arkaria.postgresql.org; Sun, 27 Jul 2025 23:18:22 +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 1ugAdJ-002SNY-3O for pgsql-committers@arkaria.postgresql.org; Sun, 27 Jul 2025 23:18:21 +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-002QyJ-8q 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-001C42-2c for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:31 +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-0037iE-GK 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-001377-32 for pgsql-committers@lists.postgresql.org; Sun, 27 Jul 2025 23:16:26 +0000 Content-Type: multipart/mixed; boundary="===============8836132046289460580==" 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 --===============8836132046289460580== 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 YW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi83OTM5MjhjMmQ1YWM4ZTYwZTFlNDA1NGZhM2I5ODYzNjk3Nzc4 OTZkCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJh bnNhbS94bG9nLmMgICAgICAgICAgIHwgMTAgKysrKysrCnNyYy9iYWNrZW5kL3V0aWxzL2FjdGl2 aXR5L3Bnc3RhdC5jICAgICAgICAgfCA1MiArKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC91dGlscy9hY3Rpdml0eS9wZ3N0YXRfYmFja2VuZC5jIHwgMTQgKystLS0tLS0K c3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZpdHkvcGdzdGF0X2lvLmMgICAgICB8IDEwICstLS0tLQpz cmMvYmFja2VuZC91dGlscy9hY3Rpdml0eS9wZ3N0YXRfc2xydS5jICAgIHwgMTAgKy0tLS0tCnNy Yy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3Bnc3RhdF93YWwuYyAgICAgfCAyMCArKysrKy0tLS0t LQpzcmMvaW5jbHVkZS91dGlscy9wZ3N0YXRfaW50ZXJuYWwuaCAgICAgICAgIHwgMzQgKysrKysr KysrKy0tLS0tLS0tLQo3IGZpbGVzIGNoYW5nZWQsIDYyIGluc2VydGlvbnMoKyksIDg4IGRlbGV0 aW9ucygtKQoK --===============8836132046289460580==--