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 1rujqq-007LE5-F7 for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 02:07:45 +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 1rujqo-00BfHY-Ts for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 02:07:42 +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 1rujqo-00BfHO-Ij for pgsql-hackers@lists.postgresql.org; Thu, 11 Apr 2024 02:07:42 +0000 Received: from esa4.fujitsucc.c3s2.iphmx.com ([68.232.151.214]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rujql-000IOR-Nf for pgsql-hackers@lists.postgresql.org; Thu, 11 Apr 2024 02:07:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1712801259; x=1744337259; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=5/P4rHInnE+yca7L4wx+z20v62E1nivOLirtoESvqoE=; b=Mn1bJQ67sXpvRdFKWeqpuDmSxEtaFUp5XyvHsqKayWdX1diuXuD4PLNe jI3OUO29bAKlXvAJTzvtjx7DnkUFWufJqC+xZp4JSk5OyuOKhJ852masU 7zMUisyUpsiJ3cqS2yArSd0Db07AiqgY8hXm1HV9EmGt4EEF3e4os+zJR L8tYEM2H7Kmd7TwxUxEHoliGN5vIaPI1ZJnFNSlvXPQayOOdMtHF9S39z ub4IGDmHGbsGdmPqGzjEWg3tAz9ag3UKw/L6pmMoFD2bzOzKOK++GGE5O cSVtDJ3otMSPceg9EPq2HZXdEBXUFsHJOhTKgeSCZaGKRu9HkGDZQNA+b w==; X-IronPort-AV: E=McAfee;i="6600,9927,11039"; a="29515821" X-IronPort-AV: E=Sophos;i="6.07,192,1708354800"; d="scan'208";a="29515821" Received: from mail-tycjpn01lp2169.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.169]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 11 Apr 2024 11:07:37 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=cCmVYN95gWl70W+1lEjVYtMzCJFTBWQMVJgnsDj/bcewCcp1lPLsHQPloJYdd76+JZPwuYKWk3XCkNKTGxTj+jj4V2RbSfV5Af8UlqNI6kYe4dKWCp7+WzaczpmM/NQnfsst89yukDpq/JMhRQhIYDeeI+POFbCtdw2h/sI4hjSUujDOzOzxirvV/oapHNX7J5SmVtO/KNWQPngkdt++BMXJtWeVZrwxl3f4dyaYoJAZrkK1oP08qHFcGCzxBqiKrARzo5yWiyQpI8Q14Snts5hgGj7MC8gGYy4gGBLWRoLda4sVnAQQAeMIutShmb6FPCaGqFDRXz761WGNCH51wA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=5/P4rHInnE+yca7L4wx+z20v62E1nivOLirtoESvqoE=; b=AeGJU6WSaQtT+jN8ShrZ8T9TIjIsdzOIJo9oMV13HRx933DhR5VZjA5UQ09khLYMtdgsuUYPkTYFTZvSvpc0Z7FEC2pnxBwmBfUznlEMW9T5/N1g4W75jhQIRCz1F549gPnryv+mSQzwMMtpyDBYcuuanSI+Ho6Xlx5h3Xuyfpm+cVPH8RuzM77gGVUH6rJjqSMtt2oX1g2dxpHFPABrxnbZKzdRUARk7buh0uPKZ5ox9Us0ScBCeOtOojsUJ92MwjiHR3RbnOEvz1fEXLPEjT+LDldcPHreCJY26RL7z3jinAqk/6ylZhxmdwpw7PxYIPE3ryRYORfFDeUZI4S3Uw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none Received: from OSBPR01MB2552.jpnprd01.prod.outlook.com (2603:1096:604:18::11) by TYWPR01MB8495.jpnprd01.prod.outlook.com (2603:1096:400:173::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7409.55; Thu, 11 Apr 2024 02:07:34 +0000 Received: from OSBPR01MB2552.jpnprd01.prod.outlook.com ([fe80::656c:d8ef:d10b:2b69]) by OSBPR01MB2552.jpnprd01.prod.outlook.com ([fe80::656c:d8ef:d10b:2b69%4]) with mapi id 15.20.7409.042; Thu, 11 Apr 2024 02:07:34 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Amit Kapila' , Ajin Cherian CC: =?utf-8?B?0JTQsNCy0YvQtNC+0LIg0JLQuNGC0LDQu9C40Lk=?= , Heikki Linnakangas , "pgsql-hackers@lists.postgresql.org" Subject: RE: Slow catchup of 2PC (twophase) transactions on replica in LR Thread-Topic: Slow catchup of 2PC (twophase) transactions on replica in LR Thread-Index: AQHahlBB4N3zaCXydEanrlXe3l/fU7FXl9SAgAH0loCAB9iSAIAA94hQ Date: Thu, 11 Apr 2024 02:07:33 +0000 Message-ID: References: <8fab8-65d74c80-1-2f28e880@39088166> <99df2-65d8d200-1-63c26880@172687752> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9OWZkMTI3YTMtNjRhMi00MzBiLTk0NTQtZDQ4ZDI2Nzc1?= =?utf-8?B?MjRjO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFROKAiztNU0lQ?= =?utf-8?B?X0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9T?= =?utf-8?B?ZXREYXRlPTIwMjQtMDQtMTFUMDI6MDQ6MjNaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?Q?d-81e1-4858-a9d8-736e267fd4c7;?= x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OSBPR01MB2552:EE_|TYWPR01MB8495:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 1SQ6c5a9PlSsdyXfOURhUG0+lThEmP9KS3tYcJO068JkK9qvWpn4sllZmmwpVmRkqMQao+yRNad14E9xKHOoic+TYWZTtBZ3hMxhhrMApdX51+dQKn9BTjG9gOfQbsoPRCHJpv4vyHIL0GBbhJ5cMJrxjE/bq5xWrgGPn6kEl4o1O0Y0NGiePx6oqRST11n5hrUTFHfh2T8QlJAVUVYCHks+NLyHRb8k0YoRnW9L+2CDxgQ+NiQFSRrgu3lXg2tSMtAmyTyrYtPnlIadzfD5VC1ojUfIO/MPuReXymncb/uNxkHj7k/SY/h7qte86LO0Yjvto0oFG3ZA/NVHuW2no8+Wds6lEnt5eCWgqwcVQtBshPdUvXWckZLAu6xuETgJGnamOYBW4ahzIayBE+/IV7Sh6vC/JaHDmV/FFkOhzr8sDGX69HXAX6ZAcG356qu9EUb9Y+uUCcvHEamDYHLESCFGgDPaxLm5zietCZ58+CJitd49ltmjMvT13DQTIFPM+V2UKIcD1iVgo+3VYcowKeUTBIMceNEc4QqWsU+gE7XoTJR5qLY2zTHiGyLA6MpvINr50DQ3zCdBLVCSBPEvm6PwPOuZAfh+gmBE3wobsJqe0USzJOk/gjdAwZfSLoLYItB+M/ZYWB2Ze6TFm1SFTlVHqjwHVaRl9IM9WEDYgto= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSBPR01MB2552.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366007)(376005)(1800799015)(1580799018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?QVptVmR0STlBR2dCTjBndjF3VXl6Q3NKTVRPbitHL2NjaVloSXRXb1NPeExx?= =?utf-8?B?dVhPUVNQSDErelRVTFhjaVJtQko4QTRTaDNXMGc3QjRHUitZQzZpbzQvN24w?= =?utf-8?B?WHhPRlYwUWp1ZndvWXpDU1B4QTVRZjRDN0hxaFFmcWNUN3k0RWF2VTZZUDVj?= =?utf-8?B?blJwenlNUC9pY1RBRjRrcDZ0VmJRSnlqMFdJQ0dWVzZFeGozWDZYMjk2N2ov?= =?utf-8?B?OUlBSUJmZGlQMzBlaGJ3Wkx0ZTZQTU5wQ29XSUV5K0lyREhjcFkvdVNzZXg0?= =?utf-8?B?T09zZERvK2FQWWFvc0hUMm9kU1QySkwrMGo1NkdadnNlSHVDNk9LL1lUMmdp?= =?utf-8?B?TWI4SGU1ZStaZDNYWVpxc0NYZ2tDV1E4bVh4WHkzYzlEZ2M0c0h5RjhqNGNo?= =?utf-8?B?ajl1dGxmV2NOWEI3ODZHMWxYQ0dnaVB2WS9TUnJ0MGd2eUVGVHY2cG9uSmdR?= =?utf-8?B?YndIZ1RpdkF2SU5EaXl3OHVUcFNpYWc0c200eXVZbU1jaVFXWEJSNHNZSDBD?= =?utf-8?B?RDA5a0VhNGJDYjgxM1gyRUxweEsyd2Y3OS9CdUszNER6WjNIMjQ4YUVVejRZ?= =?utf-8?B?bjRzZVg4cWdKcnVjWkZRbDdHQzNjNno1Q3ltSUNXUUxVUGRkbm1zdjlaR2tt?= =?utf-8?B?dTc4Y0NWS1FvaUxTblR2SXlYTDUzZllKYkZzTTN3cmFlQ2FuWGQwcXFYeng2?= =?utf-8?B?dHAwOTVtNHNUTEZvYUErbkF0ZHRpNzhnclJWUmVPdDNnTWtkODRucy9TOW9J?= =?utf-8?B?RG5JOXFKTzdHZFpMNGxZNi96MVl6MDVLeHBKaEhkaTVBaVkxaVVWd09tcFJ0?= =?utf-8?B?MzVRaDIvam50cUM3c0hOWnh4SUJLNStRSmZWUkxqUHU2ZUZ3Uk9obW9VWnFJ?= =?utf-8?B?Nmhwc3JNeFhjSjA1bzBORGtTeUc0ajVpbVdWKzRPcVV0MmF1V0tZNjJzTDg1?= =?utf-8?B?WGpsemQ1WFFGTjUyVU1NTkJPeUg4WFFVWkhQWW5BQ3ZhNjlKSHRCaUZEUFhQ?= =?utf-8?B?enJ2TXdSZFVGR1Y5bXM5eFJwVDIvN2dUM0xKWGdkVUJPeTJTWUE1Z2IzMXNL?= =?utf-8?B?MkVMZ2lVYUU4Vmc0MUVwaW4rWm9vSjVMUjhUSjhUQ2lLNGdqZ3hWc1VSOTcw?= =?utf-8?B?TU1MNUk2MHNzcEc1anZvaWcwSCtwczZXWi90RWF3eXdjc2g3OXlDd3g2NGw3?= =?utf-8?B?MU1KWTFMR1VpNjFxdE1QdEZWRjRMd2dsM0hqM0cyMFU1UFNlR3FMR2JRWnBk?= =?utf-8?B?ZGsrOGNwNXU2ZVVKSzdzRGI1dEQ5UGhGYmF2NjF5V1dZT2h2WjRwTVgwSGJl?= =?utf-8?B?M3Z2c1Y3Q09VOHlHWUxlNGNsMGYrM04rUm8yKy9UZ3JYNFZKUGY5OHRGUGNq?= =?utf-8?B?cEx5R2RrcEh0VTVzc3NsV3NMc0tzbDVjcE1tUDFPS2VTbExESnMzVndZdDk5?= =?utf-8?B?WUFoVGZHR3hPbTBFVzJQQXREMHpacjdSK3hLdE1xcUwwVzVCWlE1M0hzVHpI?= =?utf-8?B?V1JERXYydENPeGhLWnltUVZ5Q2M4d1ZITllyVEdVeUxkZXh5UnVpZGp5MmJR?= =?utf-8?B?eGsyNEZlSzV6WFdtekhUVW5PUGpRY1pZNnY5cEZtb3BWUHMyWkkydWdYUnpq?= =?utf-8?B?RUFlc0E0aEx6SEJ2QmlyVWU3N3dmMzdFUUpvMG42VGJHdmJ3aldSMnVQSitv?= =?utf-8?B?MURxVTA3VDBMTk84OVNmdGZNSjZUeHZoYnVwZXhnLzk5QjNkTFprQXJVVzRm?= =?utf-8?B?Y0lEZnhNMFEzNFZrQ0xFa0tqQnZLTG1FVzl6bDAxSTNDNWF1SzJESjhSbmRI?= =?utf-8?B?aS9YUTgxaUxORm1EcnE1bDF4WmZXQ1BDMXhnUldnL010Y1FncHNiTmN2NXBX?= =?utf-8?B?ek1CMFlLUDROQ01MdEZuZkhIN2VGdXdqNFRTNVJsU2ZHQ3JaK0Y5S0dHVS9C?= =?utf-8?B?NTBQSStWYnQ2MWF1dWUzOUVlOUdvUnhJcWVyY0h3OW5YNnd0OFJ3MDJHN0w4?= =?utf-8?B?bEg2VmJUaWxoVXkzL3FmeTJhWDdibzVFelF4U0xqdnZIOFlWVFhJdTVMKyto?= =?utf-8?B?WTJFbXlQcUxjUWZLMFJGakJHMU1ESVdURHoxR0J3RG1ZaE1IK0V4WnUxR3Q2?= =?utf-8?B?SXh4bXVFbzA2RkdNSW9PZ1ZYV1JNKzBOQmVOa2VBSWwwelc1QXpIc2EzWkZ5?= =?utf-8?B?elE9PQ==?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: UlpkKDSGSzBqW5/+pHRn9DymueEWRzEL7U7K5H6TLXqrMu2ZRYPXKsQOcKJ8A228WvG2bUUQ/r+SGyIMWBqbKQUCj/LL+crH7fhU2cGULe62v/KqlQTgFVdDm9QiRvLqqe6gdkljXd5NvFi+PpJaqtnvADIrCKWxbzFWYAf4MK6w67hoXnTZmBxkBp87PsjdtBah885JKpuw4I8EvoEBKG6SkqUXnhMn8+fzHnqhakQggxDTYJeyi+C/aSqCNDXNqNxdGzEYYuWUJHqkHc75SrGwPKbPwUEHm4f6dmD+VqcTpW1EEXKKan2kw40u3prVBIQg9YR+WTQCuagr7iZXDgvIBW2cOKgE7nNA7LbBPazs+a478hJr6p+Cz3NRS8aqzWUjXWFnRN+CrBuiNMQX8ZemMsyWVSnuuOlQYAjoj5Ldyydzh/S2IBL97EJZ2P6+nykMZe1X1hv49BZIrRPChL9p+v5Wl2KIMg4AP2OYtZe7stAf9z1XhO7G0z4TqAxlCoZ9+nrDDPPrYtRqI/mPrWOJPhUw4Nn08B+4elTz4nX2bdjyV1oidik3+9HRAGyx5h5YZmy2e29o6DaBJSr2ArYCRR1c+cEG+XFnNvoPTaue1/6jxFw6ICRkyz1VWNiR X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSBPR01MB2552.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 011abe87-abc2-40e8-d32f-08dc59cc269c X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Apr 2024 02:07:33.5153 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: QVykFnYB/AvLesjcfOVCVAmpjHOIj48fjW4dvn+HrQwRYNj5hl54XtQ1+Yu2vGVc9R/GLoICXGApesap/OMPSjmZ7z6dOfVfzjhfiSmQkqE= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWPR01MB8495 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBBbWl0LA0KDQo+IE9uZSBuYWl2ZSBpZGVhIGlzIHRoYXQgb24gdGhlIHB1Ymxpc2hlciB3 ZSBjYW4gcmVtZW1iZXIgd2hldGhlciB0aGUNCj4gcHJlcGFyZSBoYXMgYmVlbiBzZW50IGFuZCBp ZiBzbyB0aGVuIG9ubHkgc2VuZCBjb21taXRfcHJlcGFyZWQsDQo+IG90aGVyd2lzZSBzZW5kIHRo ZSBlbnRpcmUgdHJhbnNhY3Rpb24uIE9uIHRoZSBzdWJzY3JpYmVyLXNpZGUsIHdlDQo+IHNvbWVo b3csIG5lZWQgdG8gZW5zdXJlIGJlZm9yZSBhcHBseWluZyB0aGUgZmlyc3QgY2hhbmdlIHdoZXRo ZXIgdGhlDQo+IGNvcnJlc3BvbmRpbmcgdHJhbnNhY3Rpb24gaXMgYWxyZWFkeSBwcmVwYXJlZCBh bmQgaWYgc28gdGhlbiBza2lwIHRoZQ0KPiBjaGFuZ2VzIGFuZCBqdXN0IHBlcmZvcm0gdGhlIGNv bW1pdCBwcmVwYXJlZC4gT25lIGRyYXdiYWNrIG9mIHRoaXMNCj4gYXBwcm9hY2ggaXMgdGhhdCBh ZnRlciByZXN0YXJ0LCB0aGUgcHJlcGFyZSBmbGFnIHdvdWxkbid0IGJlIHNhdmVkIGluDQo+IHRo ZSBtZW1vcnkgYW5kIHdlIGVuZCB1cCBzZW5kaW5nIHRoZSBlbnRpcmUgdHJhbnNhY3Rpb24gYWdh aW4uIE9uZSB3YXkNCj4gdG8gYXZvaWQgdGhpcyBvdmVyaGVhZCBpcyB0aGF0IHRoZSBwdWJsaXNo ZXIgYmVmb3JlIHNlbmRpbmcgdGhlIGVudGlyZQ0KPiB0cmFuc2FjdGlvbiBjaGVja3Mgd2l0aCBz dWJzY3JpYmVyIHdoZXRoZXIgaXQgaGFzIGEgcHJlcGFyZWQNCj4gdHJhbnNhY3Rpb24gY29ycmVz cG9uZGluZyB0byB0aGUgY3VycmVudCBjb21taXQuIEkgdW5kZXJzdGFuZCB0aGF0DQo+IHRoaXMg aXMgbm90IGEgZ29vZCBpZGVhIGV2ZW4gaWYgaXQgd29ya3MgYnV0IEkgZG9uJ3QgaGF2ZSBhbnkg YmV0dGVyDQo+IGlkZWFzLiBXaGF0IGRvIHlvdSB0aGluaz8NCg0KQWx0ZXJuYXRpdmUgaWRlYSBp cyB0aGF0IHdvcmtlciBwYXNzIGEgbGlzdCBvZiBwcmVwYXJlZCB0cmFuc2FjdGlvbiBhcyBuZXcN Cm9wdGlvbiBpbiBTVEFSVF9SRVBMSUNBVElPTi4gVGhpcyBjYW4gcmVkdWNlIHRoZSBudW1iZXIg b2YgaW50ZXItbm9kZQ0KY29tbXVuaWNhdGlvbnMsIGJ1dCBzb21ldGltZXMgdGhlIGxpc3QgbWF5 IGJlIGh1Z2UuDQoNCkJlc3QgUmVnYXJkcywNCkhheWF0byBLdXJvZGENCkZVSklUU1UgTElNSVRF RA0KaHR0cHM6Ly93d3cuZnVqaXRzdS5jb20vIA0K