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 1whn7p-000QBx-0F for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 11:41: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 1whn7l-00CoYL-2t for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 11:41:02 +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.96) (envelope-from ) id 1whgor-00AvFp-0f for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 04:57:05 +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.98.2) (envelope-from ) id 1whgop-00000000GRb-3hGm for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 04:57:05 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1whgoo-000tNz-38 for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 04:57:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whgoo-000kyB-2J for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 04:57:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: xact_rollback spikes when logical walsender exits To: pgsql-hackers@lists.postgresql.org From: jihyun bahn Cc: Nik Samokhvalov Date: Thu, 09 Jul 2026 04:56:34 +0000 User-Agent: pgcommitfest X-cfsender: ichibahn In-Reply-To: References: Message-ID: <178357299471.9403.9243858144101333619.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIG5vdCB0ZXN0ZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICB0ZXN0ZWQsIHBh c3NlZAoKSGkgTmlrb2xheSwNCg0KSSB0ZXN0ZWQgdGhlIHYzIHBhdGNoZXMgb24gbWFzdGVyIChj b21taXQgZTAxYjIzYikgb24gVWJ1bnR1IDI2LjA0LA0KZ2NjIDE1LjIuMCwgY29uZmlndXJlZCB3 aXRoIC0tZW5hYmxlLWNhc3NlcnQgLS1lbmFibGUtZGVidWcNCi0tZW5hYmxlLXRhcC10ZXN0cy4N Cg0KMDAwMToNCg0KQXBwbGllcyBjbGVhbmx5IGFuZCBidWlsZHMgd2l0aG91dCBuZXcgd2Fybmlu Z3MuIFRvIHZlcmlmeSB0aGF0IHRoZSBuZXcNClRBUCB0ZXN0IGFjdHVhbGx5IGNhdGNoZXMgdGhl IGJ1ZywgSSBmaXJzdCBhZGRlZCBvbmx5DQp0LzAzOV9wdWJsaXNoZXJfeGFjdF9yb2xsYmFjay5w bCBvbiB0b3Agb2YgdW5wYXRjaGVkIG1hc3RlcjogaXQgZmFpbHMgYXMNCmludGVuZGVkICh0aGUg eGFjdF9yb2xsYmFjayBkZWx0YSB3YXMgNSwgZXhwZWN0ZWQgMCkuIFdpdGggdGhlIGZ1bGwNCnBh dGNoIGFwcGxpZWQgaXQgcGFzc2VzIDMvMy4gbWFrZSBjaGVjayAoMjQ1IHRlc3RzKSBhbmQgdGhl IGZ1bGwNCnN1YnNjcmlwdGlvbiBzdWl0ZSAoNDAgZmlsZXMgLyA1ODggdGVzdHMpIHBhc3Mgd2l0 aCAwMDAxIGFwcGxpZWQuDQoNCkkgYWxzbyByZXByb2R1Y2VkIHRoZSBwcm9ibGVtIGF0IGEgbGFy Z2VyIHNjYWxlOiAxMDAwIGF1dG9jb21taXQgSU5TRVJUcw0KZGVjb2RlZCBieSBhIHN1YnNjcmlw dGlvbiwgdGhlbiBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIERJU0FCTEUuDQpQdWJsaXNoZXIgcGdf c3RhdF9kYXRhYmFzZSAoeGFjdF9jb21taXQsIHhhY3Rfcm9sbGJhY2spLCByZWFkIHZpYQ0KdGVt cGxhdGUxIGNvbm5lY3Rpb25zLCBhdXRvdmFjdXVtIG9mZjoNCg0KICAgICAgICAgICAgICAgICAg ICAgICBtYXN0ZXIgICAgICAgIDAwMDENCiAgICBiZWZvcmUgRElTQUJMRSAgICAgMTAxMywgMCAg ICAgICAxMDEzLCAwDQogICAgYWZ0ZXIgRElTQUJMRSAgICAgIDEwMTUsIDEwMDAgICAgMTAxNSwg MA0KDQpPbiB1bnBhdGNoZWQgbWFzdGVyIHRoZSB3YWxzZW5kZXIgZXhpdCBhZGRzIGV4YWN0bHkg b25lIHNwdXJpb3VzDQpyb2xsYmFjayBwZXIgZGVjb2RlZCB0cmFuc2FjdGlvbjsgd2l0aCAwMDAx IHRoZSBkZWx0YSBpcyAwIGFuZCBldmVyeQ0Kb3RoZXIgY291bnRlciBpcyBpZGVudGljYWwuIE9w ZXJhdGlvbmFsbHkgdGhpcyBpcyBleGFjdGx5IHRoZQ0KZmFsc2UtcG9zaXRpdmUgYWxlcnQgcGF0 dGVybjogdGhlIHNwaWtlIGxhbmRzIG9uIHJvdXRpbmUgYWN0aW9ucw0KKHN1YnNjcmlwdGlvbiBk aXNhYmxlLCBzbG90IGRyb3AsIHJlc3RhcnRzKSB3aGlsZSBhY3R1YWwgcm9sbGJhY2tzIGFyZQ0K emVyby4gRWFjaCBkZWNvZGVkIHRyYW5zYWN0aW9uIHdhcyBhbHJlYWR5IGNvdW50ZWQgb25jZSBp biB4YWN0X2NvbW1pdA0KYnkgdGhlIGNvbW1pdHRpbmcgY2xpZW50IGJhY2tlbmQsIGFuZCB0aGUg cm9sbGJhY2sgdGhhdCBhcHBlYXJzIGxhdGVyDQpiZWxvbmdzIHRvIHRoZSB3YWxzZW5kZXIncyBv d24gaW50ZXJuYWwgY2F0YWxvZy1hY2Nlc3MgdHJhbnNhY3Rpb24gLS0NCnNvIG1vbml0b3Jpbmcg ZW5kcyB1cCBzZWVpbmcgb25lIGNvbW1pdCBwbHVzIG9uZSByb2xsYmFjayBmb3Igd29yaw0KdGhh dCBpbiBmYWN0IGNvbW1pdHRlZCBjbGVhbmx5LiBTaW5jZSBib3RoIG9wdGlvbiAyIGFuZCBvcHRp b24gMw0KZGlzY3Vzc2VkIHVwdGhyZWFkIGltcGx5IGV4Y2x1ZGluZyB0aGVzZSBpbnRlcm5hbCBh Ym9ydHMsIDAwMDEgc2VlbXMNCnJlYXNvbmFibGUgdG8gcHJvY2VlZCB3aXRoIGFzIGEgbmFycm93 IGJhY2stcGF0Y2hhYmxlIGZpeCB3aGlsZSB0aGUNCndpZGVyIGRlZmluaXRpb25hbCBxdWVzdGlv biBpcyBzZXR0bGVkIGFyb3VuZCAwMDAyLg0KDQowMDAyIChkcmFmdCk6DQoNCkJ1aWxkcyBvbiB0 b3Agb2YgMDAwMSBhbmQgYmVoYXZlcyBhcyBkZXNjcmliZWQ7IG1ha2UgaW5zdGFsbGNoZWNrLXdv cmxkDQphbHNvIHBhc3NlcyB3aXRoIGJvdGggcGF0Y2hlcyBhcHBsaWVkLiBJIG1lYXN1cmVkIHRo ZQ0Kc3Vic2NyaWJlci1zaWRlIHZpc2liaWxpdHkgY2hhbmdlIHRoZSBjb21taXQgbWVzc2FnZSBj YWxscyBvdXQ6DQpiZXR3ZWVuIGEgYmFzZWxpbmUgdGFrZW4gYWZ0ZXIgaW5pdGlhbCB0YWJsZSBz eW5jIGFuZCBhIHJlYWRpbmcgdGFrZW4NCmFmdGVyIGNhdGNodXAgKGJlZm9yZSBkaXNhYmxpbmcg dGhlIHN1YnNjcmlwdGlvbiksIHN1YnNjcmliZXINCnhhY3RfY29tbWl0IG1vdmVzIGJ5ICsxMDAx IG9uIG1hc3Rlci8wMDAxIC0tIHRoZSAxMDAwIHJlcGxheWVkDQp0cmFuc2FjdGlvbnMgcGx1cyBv bmUgZnVydGhlciBjb21taXQgZnJvbSBhIG5vbi1jbGllbnQgYmFja2VuZCAtLSBhbmQNCmJ5IDAg d2l0aCAwMDAyLiBUaGUgc3Vic2VxdWVudCBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIERJU0FCTEUg c2Vzc2lvbg0KYWRkcyArMiB0byB4YWN0X2NvbW1pdCBpbiBhbGwgY2FzZXMsIGFzIGV4cGVjdGVk IGZvciBhIHJlZ3VsYXIgY2xpZW50DQpiYWNrZW5kLg0KDQpPbmUgbW9yZSBkYXRhIHBvaW50IGlu IGZhdm9yIG9mIHRoZSBuYXJyb3dlciBkZWZpbml0aW9uOiBvbg0KbWFzdGVyLzAwMDEsIGRpc2Fi bGluZyB0aGUgc3Vic2NyaXB0aW9uIGFsc28gYWRkcyArMSB0byBzdWJzY3JpYmVyDQp4YWN0X3Jv bGxiYWNrLiBUaGF0IGFwcGVhcnMgdG8gYmUgbWF5YmVfcmVyZWFkX3N1YnNjcmlwdGlvbigpLCB3 aGljaA0Kc3RhcnRzIGEgdHJhbnNhY3Rpb24gdG8gcmVyZWFkIHBnX3N1YnNjcmlwdGlvbiwgbm90 aWNlcyB0aGUNCnN1YnNjcmlwdGlvbiB3YXMgZGlzYWJsZWQsIGFuZCBwcm9jX2V4aXQoKXMgZnJv bSB3aXRoaW4gdGhhdA0KdHJhbnNhY3Rpb24sIHNvIHRoZSBzaHV0ZG93biBhYm9ydCBvZiBhbiBp bnRlcm5hbCBjYXRhbG9nLXJlYWQNCnRyYW5zYWN0aW9uIGlzIGNvdW50ZWQgLS0gdGhlIHNhbWUg cGF0dGVybiBhcyB0aGUgd2Fsc2VuZGVyIGNhc2UsIG9uDQp0aGUgc3Vic2NyaWJlciBzaWRlLiAw MDAyIHJlbW92ZXMgdGhhdCBhcyB3ZWxsLg0KDQpBcyBhIERCQSB3aG8gd2F0Y2hlcyB0aGVzZSBj b3VudGVycyBhY3Jvc3MgYSBmbGVldDogKzEgdG8gb3B0aW9uIDMuDQp4YWN0X2NvbW1pdC94YWN0 X3JvbGxiYWNrIGFyZSByZWFkIGFzICJhcmUgYXBwbGljYXRpb24gdHJhbnNhY3Rpb25zDQpoZWFs dGh5IiwgYW5kIGJhY2tncm91bmQtcHJvY2VzcyBub2lzZSBtYWtlcyB0aGUgY29tbWl0L3JvbGxi YWNrIHJhdGlvDQpoYXJkZXIgdG8gdHJ1c3QuDQoNCk9uZSBxdWVzdGlvbiBvbiBvYnNlcnZhYmls aXR5IGFmdGVyIDAwMDI6IHN1YnNjcmliZXIgeGFjdF9jb21taXQgaXMNCnRvZGF5IHRoZSBvbmx5 IGNoZWFwIHByb3h5IGZvciBsb2dpY2FsLXJlcGxpY2F0aW9uIGFwcGx5IHRocm91Z2hwdXQgaW4N CnRyYW5zYWN0aW9ucy4gcGdfc3RhdF9zdWJzY3JpcHRpb25fc3RhdHMgY3VycmVudGx5IGV4cG9z ZXMgZXJyb3IgYW5kDQpjb25mbGljdCBjb3VudHMgYnV0IG5vIGFwcGxpZWQtY29tbWl0IGNvdW50 LCBhbmQgcGdfc3RhdF9zdWJzY3JpcHRpb24NCmlzIExTTi1iYXNlZC4gV291bGQgaXQgbWFrZSBz ZW5zZSB0byBwb2ludCBhdCBhbiBhbHRlcm5hdGl2ZSBpbiB0aGUNCmRvY3MsIG9yIGNvdWxkIGFu IGFwcGx5LWNvbW1pdCBjb3VudGVyIGluIHBnX3N0YXRfc3Vic2NyaXB0aW9uX3N0YXRzIGJlDQp3 b3J0aCBjb25zaWRlcmluZyBhcyBhIGZvbGxvdy11cD8NCg0KSWYgaXQgaGVscHMsIEkgd291bGQg YmUgaGFwcHkgdG8gZHJhZnQgYSBUQVAgdGVzdCBmb3IgMDAwMiBhbG9uZyB0aGUNCmxpbmVzIG9m IDAwMDEncyB0ZXN0IChjbGllbnQgYmFja2VuZCBjb3VudGVkOyBhdXRvdmFjdXVtLCB3YWxzZW5k ZXIsDQphbmQgYXBwbHkgd29ya2VyIGV4Y2x1ZGVkKS4NCg0KVGVzdGVkLWJ5OiBKaWh5dW4gQmFo biA8cnJpbmcwNzI3QGdtYWlsLmNvbT4NCg0KQmVzdCByZWdhcmRzLA0KSmloeXVuIEJhaG4=