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 1rjXop-006DgG-Ar for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Mar 2024 05:03:24 +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 1rjXom-008pmJ-Ao for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Mar 2024 05:03:20 +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 1rjXol-008pm8-Me for pgsql-hackers@lists.postgresql.org; Mon, 11 Mar 2024 05:03:20 +0000 Received: from esa11.fujitsucc.c3s2.iphmx.com ([216.71.156.121]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjXoh-003rtQ-AO for pgsql-hackers@lists.postgresql.org; Mon, 11 Mar 2024 05:03:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1710133395; x=1741669395; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=SHt4AXS5Vr+Plt4s92QHcGnsUS4yDT6n8FzayuBdBM8=; b=H52r9TkztZhIsSNAjEkrD/xglZdbbc9Ug1SyOiEKkCSv+iVVh1HuNt8K 41sG0nombrVh0qKGGu30eKRHS84Cd0WgPVZCRO9WPgkyRbVqLm6rzCJSk 7Tzm0HNGKmI2JhFdM0klFzjZLVopXwOGSpZ4E4XXTie/VnclPGYtwsNIV KzxzUTIEd81LYab0b7zYkXmJNbANVa79CEx0qvx1PADZtwZaDQotSx5I4 9I5H7oo+HF+TtFNlJVdDGSpC02R05m5mnhRK12SN6/PKcLZHkHfzsl6PK g1D+8y/wP64OJOfYwJ2bVw0rYhfoTATdW3MDTtrrcl2E6Cjta7qHCif8k Q==; X-IronPort-AV: E=McAfee;i="6600,9927,11009"; a="114364203" X-IronPort-AV: E=Sophos;i="6.07,115,1708354800"; d="scan'208";a="114364203" Received: from mail-japanwestazlp17010000.outbound.protection.outlook.com (HELO OS0P286CU010.outbound.protection.outlook.com) ([40.93.130.0]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 11 Mar 2024 14:03:10 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=JodePL6KsNMGMk67RD1DcIIAfiSYrxbzxPfZU72VrcCXfdOpeCAsEyMHZayXpkh8bNvRyil8W7GGUdMud2NQFPLgM9G48U8BL20oARyqu4lkIrs3VVr2SqoZYR6MkYlLjrt7Ic/yiEPg4YlWCV05BjHldsBFQQ91tRkcK4sUskzN7iJIJV7aIwa7E0JOFYd5tQSpBK2wboX7udjn1U2p1rjXL0h2owJF/OiOcgRn15njgHEXWdmBwPZ117GSkZ25RWMMgR5CoRt6BqFF+oGbUrlF55rBkSnzr9fI4XEKCh+jjkErNCGqAeOJ7ZtFQDIaDWo6gehY9plcc/SA5uRZ/g== 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=SHt4AXS5Vr+Plt4s92QHcGnsUS4yDT6n8FzayuBdBM8=; b=LytQAUfeBi2SJcOUeu2v46s+mnqdmXvkpjygD1su4wj4ZBwdjEnkxdbCd0sOnIlJnSNdiWZIEU+rmoffWM5JIpzsE1Yl6NxYNqb61k4wd/78NbLOgqWBMO7VqMV5fRA5Wf3Xi/Zvbo+hoN/R9IbVDZwFwv48+vqqPYhA8cWP/EmufNQSq3b7tyo9KvVDXb0QTZSUl1sLw3oX9PnN6m15swlja3fnnwVqfJvjUEIcJ1ZixkqwNv48Lp2p5/xE1hXgI4sYlO7pFIfafMhnkENy/gN3KkHxQYswcSrAh7TykSwf0lmdL8kcZRFXH2DTGDjzLmg98rgZGp7dVUTWeWarrw== 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 TYCPR01MB12077.jpnprd01.prod.outlook.com (2603:1096:400:439::5) by OS3PR01MB9672.jpnprd01.prod.outlook.com (2603:1096:604:1f0::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7362.35; Mon, 11 Mar 2024 05:03:07 +0000 Received: from TYCPR01MB12077.jpnprd01.prod.outlook.com ([fe80::7e1a:6993:fe9e:5317]) by TYCPR01MB12077.jpnprd01.prod.outlook.com ([fe80::7e1a:6993:fe9e:5317%3]) with mapi id 15.20.7362.031; Mon, 11 Mar 2024 05:03:07 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'vignesh C' CC: Euler Taveira , "pgsql-hackers@lists.postgresql.org" , Tomas Vondra , Michael Paquier , Peter Eisentraut , Andres Freund , Ashutosh Bapat , Amit Kapila , Shlok Kyal , =?utf-8?B?RmFicsOtemlvIGRlIFJveWVzIE1lbGxv?= Subject: RE: speed up a logical replica setup Thread-Topic: speed up a logical replica setup Thread-Index: AQHYJxwqCwVDEK8rxk6UuFJmWEa5OLBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgACrngCAAM0jQIAPei1wgAAshICAAp5LgIADBLQAgACKXLCABEd0gIABoIwAgAB7ucCAAcm90IAAHJgAgAACwICAAAXhgIAAC7MAgAAh+gCAAIfpEIAAGb3AgACYWmCAAOVegIAAfuxAgAeMDoCAAAXdAIABBpmAgABeF2CACXUbgIAATP9AgAHL3uCAARDPAIAAoFUwgAQywWCAAeMXAIADek5ggAz2jwCABVnHcIADBCkAgADUOwCAANs88IAA3B4AgAO3cwCAAA0skA== Date: Mon, 11 Mar 2024 05:03:07 +0000 Message-ID: References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com> <2edde173-5ff9-45fd-b881-cd04eb13049f@app.fastmail.com> <2231a04b-f2d4-4a4e-b5cd-56be8b002427@app.fastmail.com> <40595e73-c7e1-463a-b8be-49792e870007@app.fastmail.com> <6423dfeb-a729-45d3-b71e-7bf1b3adb0c9@enterprisedb.com> <8d52c226-7e34-44f7-a919-759bf8d81541@enterprisedb.com> 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?NTBfQWN0aW9uSWQ9OWJjMjRjN2QtYzYwYy00MmIzLThkNzEtZDhlZjg3MzVh?= =?utf-8?B?MjY0O01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZXREYXRlPTIwMjQtMDMtMTFUMDQ6NTk6MTRaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?Q?d-81e1-4858-a9d8-736e267fd4c7;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYCPR01MB12077:EE_|OS3PR01MB9672:EE_ x-ms-office365-filtering-correlation-id: 76825a2e-45c9-4037-5ae2-08dc41888a99 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: EyAW4PXYMwTKxOQnjpt3lSeYt+UN8vnsGz0nBy+SxDZyXq+BQJiEI5xnTwktBJguhu+f24uRKpy5ks8jfmKPGrXCmW7m52nvYpR5gMEbXtWZSFqurbjqiTb8JRrRvCrUsE+s9P+89xXsermVWg6ST5DeG4pQoy6ARNCoMBdpeodlbj5sMqq4RwVuq55Zv2dGDUQuiBRVhHDSf4RtbxMjHSijrBIchG0S/qd/R/tgOweMF9wqeLD4lCiommRfpzvTXjA6AMp0wD163S5FjfC0szO8PNnE4wFMTr310eWCMgYUD7FSk0Q+Q0joYi9WLujpBn2chNHxPQlTMKmmqrX0mz+/CCizZNSpf9dF0Nb0KcHl/7R/NV9SA+ncl+6VVYTeCNAb0xZLEO2wqvVnSvQa6RpUP7HDOBpSpVsUU6T2mmX4xp4Uykrg5J2RQFPuynQiCIaU1HGhbRSLsXr97zGsx5U6uvCf5uMduSZbZP02Q5BZpby0r8QI/JudVarbbqqMbGaKrkjhkbY1r0x1KTpUKZ3V61BqKhtiRYGeykMXqmpcoe3xw8hec48brNeOEgkH3Ok2covOt8dLP/3pNwmpp78p5zdIhHHdFkBcFTKJEv1vM8SQafQ/NavKgUKVD7fGcGbqYxOSggNsBbVzYp4PwRMCS1C3286IG19CI/KyQ6XW2wbXYEXIfuKke1ckwfVg x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYCPR01MB12077.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(1800799015)(7416005)(376005)(1580799018)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?aHhlbFpWaTk5citGd3o5NTczekpid0d5NzNWZDlBSWZDRnlYVm1JcmwvcHNV?= =?utf-8?B?RHNSSmREM1dqWHRLYTR0ZXlnaXRCRTVVM3N0b3ZwMWpLNnVTSy9HcUg0cFdo?= =?utf-8?B?SXhBdkMwOGhyTkY1bWNzemx6K0Ftd0hrVEZoemhJQnA3NzFjZWxSMlg5NFlL?= =?utf-8?B?YWJUZ1lqWnpZMTBwcHlVK0NzNVIvOHA5cE54L2hiWWI2L3cwY2FVa1dnKzNK?= =?utf-8?B?K3p4bEgxQUpJTkZtdE83eUtMdGxaZ3dna2hOVEpKa1dPOHRpQTk5WWNpOU9R?= =?utf-8?B?MThSMVBTTEVOQklKc0hsVGNXdWRVNlpKZmVtcWpGdDBJSVBFMmlTRS9mNjZw?= =?utf-8?B?M09LWE84UEhGVXBlRzg0QW1FMGRDU3ZTdHhyT1UxRCs0d2pCYWhtdkZTR1Bx?= =?utf-8?B?MzBPSmlhYlZxUGRMM3kvSzhQRDd2a2szVGlsT1dONndWUU5ub3FWcExyVmw1?= =?utf-8?B?RW44cU1jWVRGU0k3ekJqcVJRTlBTbTh4Z3NpMDFoWkVoMjVZWitqM2VBUlVz?= =?utf-8?B?WitGejZsRXl0YjVTSWtnb3VlRkt2VkpxSmovT3I5QU9jMnZhcHB0bzY4cmJD?= =?utf-8?B?N1VKck9lVTRpQ25LU0IrOUI1VEUyT3hIQnU5K2w4RUoxZldZNHUxd244K1lB?= =?utf-8?B?aS91a3gwVHYvSUFyUmFzQkI4dVY0dExoTzRWOWNYUUVsd0JMRTJSNHNWWHV1?= =?utf-8?B?WjF1U1Y4Q0FNRll1bEd5RlJKR1pWcnRSaGhjd2llbnVPYm1OcGpKb3kxbS9y?= =?utf-8?B?b2NxR3lGZTBMVlZaaXQxN1dtNSsvWUt1cE1VQmxkTC95MWp5VGlPQnBCMi9Z?= =?utf-8?B?eFRycjBJU3RhenZYd2V0WkhZcHFnMTArTHA3Q2t4WW5UQzlpd0FPQzBuNjdC?= =?utf-8?B?OHpkMVpvR2lSeTBhZW44clV1aWlIZllXUzNyQ25OdHlKOGJVMjhGcGZLL3VO?= =?utf-8?B?VHprVUgzVDJJM0xWSHU0SHI5OG9FbStvUW0wUXVrL2c4V1JBaGovVnRWS1h1?= =?utf-8?B?dE5oT0ljRVVIK1hDdUN5TjVTbjV5Q1pJcjQ3UitlbHFXNmZpVzhmcVZVV3du?= =?utf-8?B?eHNLSFlBbUdkdVhCUFJ3ODY3M3FGUUJsMEZjUEx4TWtpNFVYNzhZZzdYYk05?= =?utf-8?B?cFlwMGhmRFAvMEJ1UzZ3VnFuWEp2c1pUQUQ5MkZPYTdtay9FQ0dwdk5rQTVS?= =?utf-8?B?SGJhOXZLSTBhUjM0Qzhob1hOTE1oL0pIUmpCSEdrWnpRMFpydlVsRWRJUm1W?= =?utf-8?B?WVNyaDJFVDRuNzh1anRvL2dVM3hJemdYRkRRUXJQQzg5UDNwVWJkeXJHcCtC?= =?utf-8?B?M0d0a2tqQVVsV3RlOUFxclNsN2pDOWwwU3N2UHlxVkhQWW9BZEFpbDA4WXNW?= =?utf-8?B?UXhONWszalZGbndFc2ZFWTErNlBnTmFYN0dvcnhZbzdqc0phb1Y1VWhhRElr?= =?utf-8?B?aUxmZy9kMWZCTnUzZ3pUOGtzZGJ4Mk93aWdFRDhmZXo0R0ViWFdadW5VMzh2?= =?utf-8?B?QzlRd1R2SUJPVFRvRVZvN0dTcXJxbFVhNEJHbDlhdVkxb2FmZk5tdC82Mk5a?= =?utf-8?B?ME9BODRxYWFOdGQ2K2haK3YwdXZCQnJCdEZKQ3FaS3VRb3pZUWF6YTZ2VVRM?= =?utf-8?B?MTZMUkhoSHUyY1RIbi9rc1NJOGI2QThGUEtTRW1aeDVDUHRXUXBnQk5IRXo2?= =?utf-8?B?YUtxS1gyNmhKQUJiSzdlZGVXUTArQmpzczI4OE5jN3RrNlpiV1pmNlRVcWd0?= =?utf-8?B?RXg4c25GbmRUaFZiOTlaYklJUmlta0x5MlVwM3NjMUl0MXZyZGR3VElGQWNy?= =?utf-8?B?M3J6UlJ5S2Z6ZmlVa3lEOHRQODBkTk9XUVJFK2VRL1RjNm5pOXM5STVuZmNH?= =?utf-8?B?MUM0a2lPdnVJZmxWbGoxQmcvQ3QxbENhS2UzdWp3WlBXaGpiL0Y4MnBXb1lY?= =?utf-8?B?SXBzeXFhbXNiNU12Mm1NSTQxQTd3NHh1M1NBRzAzNDNxRW9JTTZuSWprT0ox?= =?utf-8?B?YndQTTZqWEJiYmw5dUlUaU9PZGhlZEU0WlV1NWsxREgrSkYrSUZFbVBBWXdV?= =?utf-8?B?VHRsSExLc1laTEx3bXVzT3AyYkdWUVVoV2ZuaHBZZS80bStPRnFQM0RnODJt?= =?utf-8?Q?r81+FnciID8vE9luaQ4tRXpJg?= 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: BqFYh4vUJSp3OjfIL5JLTnKFCSDuRQA5010EaVGvr7clvtXDmh5wJHRI6f5vdg2X1HBH8aBAZ5pNl2PCymqGWHFJBgpKoOojzCe+Yk36qjp16INX2klFu+4EVs0y4fWiTjxUdrHMpaS1ervlM/M0m/puer3GEuokq02kSamW02dlIRy7f02v4lOlTtDMroNMTBMFZ7hn/ILR6/CdRHnnmWZsxVmVy3IbNHSCUzaXcHM+rIwSA4qta7Lb+WuZZZ/sVARwuazWxRRipf6L8e2aALCX9xOefkylMLYbzvq7D25xetKigUatJHZBCFBgwkjW5BgfHQjTLUhVGmACua4BSD9Rvm3FGJNhW0Aq9gpQDMJAs8Gh+jngI0GQD+BHBLKKk9yy2g6xd+7pJB2ne79TZFou/j3UfVM4OMqa6NvO5+mh41Jzjy29hJg4W7iumpHCPTTNQZhUJpjvICC01nTu9LlPDSON51H4TRbInOdwbuKf3CPy+y/oA8DzwvIdPgYxADQPDi8Akgy1Gv5pt56JSE/y5uj70Yng5jYGADuwWbbx4FCHhIITLYq3qYXhkADAsLmSmCBnNQTg2ggU5/xRMR8EDIgj5pPUMVS68EWTQ0gcrZZ3SEqRm0woiJLqclpK X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYCPR01MB12077.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 76825a2e-45c9-4037-5ae2-08dc41888a99 X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Mar 2024 05:03:07.5918 (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: y6xDS5ftl06voIWIVWAhfXY7fRbzLMFLTDBVcxUOdmTJqwOAC6/iTawOy10Yz06Sk6XnwBxuSw2u0AEsj25n/X8/25mKcBAyuc6hUZuSaVs= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3PR01MB9672 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBWaWduZXNoLA0KDQpUaGFua3MgZm9yIHVwZGF0aW5nIHRoZSBwYXRjaCwgYnV0IGNmYm90 IHN0aWxsIGdvdCBhbmdyeSBbMV0uDQpOb3RlIHRoYXQgdHdvIGNvbnRhaW5lcnMgKGF1dG9jb25m IGFuZCBtZXNvbikgZmFpbGVkIGF0IGRpZmZlcmVudCBwbGFjZSwNCnNvIEkgdGhpbmsgaXQgaXMg aW50ZW50aW9uYWwgb25lLiBJdCBzZWVtcyB0aGF0IHRoZXJlIG1heSBiZSBhIGJ1ZyByZWxhdGVk IHdpdGggMzItYml0IGJ1aWxkLg0KDQpXZSBzaG91bGQgc2VlIGFuZCBmaXggYXMgc29vbiBhcyBw b3NzaWJsZS4NCg0KWzFdOiBodHRwOi8vY2Zib3QuY3B1dHViZS5vcmcvaGlnaGxpZ2h0cy9hbGwu aHRtbCM0NjM3DQoNCkJlc3QgUmVnYXJkcywNCkhheWF0byBLdXJvZGENCkZVSklUU1UgTElNSVRF RA0KaHR0cHM6Ly93d3cuZnVqaXRzdS5jb20vIA0KDQo=