From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
	"'fabriziomello@gmail.com'" <fabriziomello@gmail.com>, Euler Taveira
	<euler@eulerto.com>
CC: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>,
	vignesh C <vignesh21@gmail.com>, Michael Paquier <michael@paquier.xyz>, Peter
 Eisentraut <peter@eisentraut.org>, Andres Freund <andres@anarazel.de>,
	Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Amit Kapila
	<amit.kapila16@gmail.com>, Shlok Kyal <shlok.kyal.oss@gmail.com>
Subject: RE: speed up a logical replica setup
Thread-Topic: speed up a logical replica setup
Thread-Index:
 AQHYJxwqCwVDEK8rxk6UuFJmWEa5OLBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgACrngCAAM0jQIAPei1wgAAshICAAp5LgIADBLQAgACKXLCABEd0gIABoIwAgAB7ucCAAcm90IAAHJgAgAACwICAAAXhgIAAC7MAgAAh+gCAAIfpEIAAGb3A
Date: Thu, 1 Feb 2024 03:26:25 +0000
Message-ID:
 <TY3PR01MB9889F3C46DC76CE77B91FB58F5432@TY3PR01MB9889.jpnprd01.prod.outlook.com>
References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com>
 <CAFcNs+qAMdzd_73gwo3UE_25h+E-sHiV2paxfDgz=xw2y7hogw@mail.gmail.com>
 <TY3PR01MB9889D0FF89D502539340EA03F5432@TY3PR01MB9889.jpnprd01.prod.outlook.com>
In-Reply-To:
 <TY3PR01MB9889D0FF89D502539340EA03F5432@TY3PR01MB9889.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels:
 =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?=
 =?utf-8?B?NTBfQWN0aW9uSWQ9YzQ1OGQ3OGEtZmIwZC00YTFlLTg0MTAtMWQyZjQyYzM1?=
 =?utf-8?B?YzcyO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?=
 =?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?ZXREYXRlPTIwMjQtMDItMDFUMDE6NDU6NTRaO01TSVBfTGFiZWxfYTcyOTVj?=
 =?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: TY3PR01MB9889:EE_|OS3PR01MB9605:EE_
x-ms-office365-filtering-correlation-id: cc9c6451-9eff-44a6-4e20-08dc22d59235
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info:
 l5Ws32ipzpnbkESCry8bBvK5onOn2omVyYx+UV0DQi+gU1YXBv8e8W6xyK1bfc6Z6/Cb0HHCeeq1n11f5xNelgTuky3e6OX0j5Out+JJtsmEQ/dt67U071MLOsWlfU50jq5u4J1+opqUZeIAq/37SHTZqO9k+EOdJoKFnbXTtW/G5KueRKkqS0t/23CFmiayqSl3jHc+ZYVFpgsVFZQWn1yM/x9TOH36ckNoRGIYRvEfa962BIXoTSJJOLSz/5dh1L75XLvUE51mQB35jeH72GrGbssHbGErKIvS+Ix40hva3MkL/xTu1+vzY/IJblYx2/sHSdZOqmzo+IUR2imHo5WffEQmHyFeLO8ZxdcIe9ZRdvOUqVwVggagzHxT6hJTW5v66BebPwwXvVftaRAAHul36tQavr4qvWkA7BlP03vn+f/0e/mUc+vVCV/ttS5RB45uYdoiqhrFGHxRFpnxjznmB5CiJShISn6YZAc11x7RnmWi6ZkaWpei8Cm45SEAPaMowSQkipll59tRyoKfMFScGlaXgCwPTlEJZPy+OcdSTAk3tyzn8iX9AIUbU/Ih+pwFZqgbaRGYpA3fBO8bsiacVvbB252xoDzXT2+I1Pe0Q62sjZZ6NrW1aaTt2yjOLAtP8tMESA99I1Ic3l1xIPGu/8JgEJQQBSlBvtjfXtI=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY3PR01MB9889.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(39860400002)(396003)(376002)(136003)(346002)(366004)(230922051799003)(64100799003)(1800799012)(451199024)(186009)(1590799021)(7696005)(1580799018)(85182001)(83380400001)(6506007)(122000001)(41300700001)(86362001)(33656002)(82960400001)(99936003)(38100700002)(478600001)(4744005)(110136005)(76116006)(316002)(66574015)(26005)(4326008)(64756008)(66446008)(66476007)(9686003)(66556008)(54906003)(966005)(66946007)(52536014)(7416002)(8936002)(5660300002)(2906002)(71200400001)(2940100002)(8676002)(38070700009)(55016003)(491001);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?utf-8?B?RGcrVnhuZldQUXNqN085U0tRaUd3QVppMXZ4N0I0UkFLQzlYVlA0WThtb0Jp?=
 =?utf-8?B?ZXpuU1FOSzFCTVNKSFh2bjI0Um42aGlLK1JXVDFHMWpGZk9IblJwR1NtT2x3?=
 =?utf-8?B?ZS9QN2pCSkxGbjVvZnd2ZlMvZlJ6NUNCc1lldHl2VTd1K0tvcUp0bE9zc3Vj?=
 =?utf-8?B?b2pncWcxZ3Flb0dqTHd1bUlBMW1vS0Q2aTZGaHdMK1NLOUE5dHQ5UEI0UVBr?=
 =?utf-8?B?NU9pSWZBL3p0Vk1Pc3B3R3VFSjJuNjlwMUovVHVHUzI3eC95aTNQaHE2cE1O?=
 =?utf-8?B?TnM3SXlvODR3d0UwMkhuZzJiQVF3bTNHZUZSMEVBRW5OdHdXRGRGUmVLb2Ux?=
 =?utf-8?B?R3RKU004M2E1YVFwbG9FMzcrckFUcWI0S0JPZk9aKzZrbTVvYXRFeHdSdzNR?=
 =?utf-8?B?ckNxTGlTZXBqZWNaMjFGY01wYkdtcnFXeWptUFg1UmpScFB0SXc0eHZuVlE4?=
 =?utf-8?B?eXR2alEwRWVRdTVxUVZkR0hzNHZCTVNpMTlFbUdvRmxwblZGWUd2MVhUeHJZ?=
 =?utf-8?B?R0JWSHRuZUgzOURwSThPMWRpOWcwMTk0ZHhyOTU2TXhzaGM2WEVZbXF2L2xJ?=
 =?utf-8?B?MmtkZGVGcmxWR2xueGJZajIzRVk3dHlIUEZUOHZRbHdBZGxkdjJqK0gzUkNs?=
 =?utf-8?B?MzZwRUhmTnJlc0JCQmlVaHhCUHU0NjM2QXo1TS9jRS9KQThmWVpRNkREazF6?=
 =?utf-8?B?NEJNSkVoQlF1dzBBYk1PRXNuaUREYzV6MGFDMlMrZjNUSFdsMzJQQnpCRzFo?=
 =?utf-8?B?MHFENytvaE9aZGkwV2diRTIvUDhiaDU2eG1zRVpGM1poSVlEU2NiRXViSzlT?=
 =?utf-8?B?UVpKZ3YwZ2w2Y25MY0dxVU9wK0xhRGFjRThjcWhtQ21DY0V6Z2ZWY0plTHZw?=
 =?utf-8?B?dmRqYkhBMVN3UnlVVGg3UnRQbFN3TnBtRkQrVmJsNEg1R1ZOaVRoeUJXSjI2?=
 =?utf-8?B?YWp4a1QweFQyNFBtNU13azM5a1oxWDJTckJDeHc1N0VRRWpSaytOcW42UnJ2?=
 =?utf-8?B?M2NkR3g0aW01dnh1QjMzc1FCMjJRbXdoV1dJVFdQQXZGeGNQaEh6amZmL0dC?=
 =?utf-8?B?V1dKS0lhT2xLa1pzb2pvdnZpai81aVFEc25OY2RKODhjRzB3SzI2ZklLaXlm?=
 =?utf-8?B?YWtnN2lCQTNBemlmQ3RxT1p0VHYwanBGQnA4ZGJHSTZ5UWR3REMveXJlOWRs?=
 =?utf-8?B?emVMZUVHQ1hBSVZnK2MwaFJWMmdDRlJPUVg1azZhRENtd3RlYmxEVGNLVllr?=
 =?utf-8?B?d1NLWHJ3aWtDTDUwRzFyMnlxU0ZVSzVUMGJlczZLUHVNcEJyKzRBbEZSWmpX?=
 =?utf-8?B?VlVRMzR3MkdvREM3R2FyckZaczRPMytLZDk1RUh6dHk1NWxFVi9vQkhYNDZ2?=
 =?utf-8?B?OEFmbm5zMk1jRmZPeXdkZzhKd1NiaGZ6bXE5T2hmb1NvRWY5ekJUY3FycHZ4?=
 =?utf-8?B?MW5mODhVdEgzR2lieG5WcmpQUXk0MjNCeW1HL3ptcmRId0hJbGRhajBWNXhI?=
 =?utf-8?B?OEJ5QnNST202Q01WeW5hSS84MVJ0MERzdmMyWXRsL3Z1ME9RVEhtTnN6Y1JR?=
 =?utf-8?B?cUpOaU5JVlg0OUFOZGxUZDA4UUFOcmtkNnlOTFpUWTZxRmhSNlFxTkZaQ09N?=
 =?utf-8?B?S2lSNXQ4bytqQlBMMVArKzRsRmVkMk1neHZObExCeWJDQ09NeFk4Y3E2TXVW?=
 =?utf-8?B?ZnNqUWNyT2pIWlBTKzhYd3FEcXJncUJkYVF6MkVxRnJsaUdOU0Y0b3I2cWZz?=
 =?utf-8?B?Z1FKS01vV0Y1d0dLcndrbWJOVHlkRUV1aTBoNUhTdExLMis5ZTlXSnlNSEpP?=
 =?utf-8?B?M25SRFo3REFCUUZuTFVTK2YwZG5OaG4vb0QyTXM3T2U1YUM2d2loUlkraERl?=
 =?utf-8?B?R3pyZkFaREJlZStjRHpNSzB6MlpjWDJSdXBWdzg0V1lndlJ3MklCYnF6QTZr?=
 =?utf-8?B?dllSdU1YNFVHTzJucVVib0tGZ05vdG5zQ0Jab1lrYnM0NzY4ZER1NzNyQTRF?=
 =?utf-8?B?T0xtUWx2b1pqNEJuL0g4NUFzNXU4NVNXdlgwdnNBTDMzeEZWaUFhYmFsTnNv?=
 =?utf-8?B?Vml1N3ljZmhkR25kZzlQUnBqcXpkY1BMRlBFUXEwdEFSYk5GYmN0Qk10ejVx?=
 =?utf-8?B?UkdsRXpBNzdtSkltVVlQWnU5TFlnSm5sOWQvL09paVhoSnFNbHZGQ2hjWnli?=
 =?utf-8?B?VHc9PQ==?=
Content-Type: multipart/mixed;
	boundary="_002_TY3PR01MB9889F3C46DC76CE77B91FB58F5432TY3PR01MB9889jpnp_"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0:
	CfuH7FqZ8+yIlqwsjKg4R4MxThjR4UwM0E3+sBaUM7wyxTEOQvS7i8ZQo6kqwJncRhGDnfaYj3GEeQ3aAgKA9kBxAtXfCoVwI1VKCYHr+2LpZPpmh8UlgXufAGe0rRREhgJS7IIUZeJKcS9CSrmt1clCIxpzaj4sioWvhUoRWTXtUljXHrke6xExc+HVRGJZY3j8NNaEITXc378tU+I0UBeObWQETvqLEuUAroL4YMTdeOB3Itu2aLejaEpqoUvXS5g+LmFLopZh037hY/AuGDOh2r0E9QJgVVQmn9+L2hYalAhW+20TUl2aaXzFn+0uDrblfClEYX9caF9JfU7P5RW2EBBhjUncPX+eDMGGwOE49oAu9PYlzQotniPtRHUFR2ETapDmPLXBaf+qy6F5rO6kqgq8hsa4K6OerLSlpixr5CGrunXEEBbSt0d6FAMVo68ATSX5LeJujquviqzhDwoWM5C/SZVM/iRbQQES7Vy/X2lV5mjDPyxXQWEg3FF/1RsxJIWjUYRkEmbuuq5lnPfhN/TasI9J53XD84iZlhmCcGxyhijHW/MfFN7F7Lj53Y2N0VWj/mCU4L7vlON9++Xo7dluhs/bzVSCxyq3SUsuxclr0CnCY55IedI1QuVL
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TY3PR01MB9889.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: cc9c6451-9eff-44a6-4e20-08dc22d59235
X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2024 03:26:25.5537
 (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: pGVYEJdy/v1cYHNCAOG/LrylCOM3WmizkSVqenLJF8NQiI19MNSzZRJ3bBoEj7evIvkmlBcayYMoV0ugnZKFnFxvUGh/JCFlh6ESZZbeGpg=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3PR01MB9605
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/TY3PR01MB9889F3C46DC76CE77B91FB58F5432%40TY3PR01MB9889.jpnprd01.prod.outlook.com>
Precedence: bulk

--_002_TY3PR01MB9889F3C46DC76CE77B91FB58F5432TY3PR01MB9889jpnp_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

RGVhciBGYWJyw616aW8sIEV1bGVyLA0KDQpJIHRoaW5rIHlvdSBzZXQgdGhlIHByaW1hcnlfc2xv
dF9uYW1lIHRvIHRoZSBzdGFuZGJ5IHNlcnZlciwgcmlnaHQ/DQpXaGlsZSByZWFkaW5nIGNvZGVz
LCBJIGZvdW5kIGJlbG93IGxpbmUgaW4gdjExLTAwMDEuDQpgYGANCglpZiAocHJpbWFyeV9zbG90
X25hbWUgIT0gTlVMTCkNCgl7DQoJCWNvbm4gPSBjb25uZWN0X2RhdGFiYXNlKGRiaW5mb1swXS5w
dWJjb25uaW5mbyk7DQoJCWlmIChjb25uICE9IE5VTEwpDQoJCXsNCgkJCWRyb3BfcmVwbGljYXRp
b25fc2xvdChjb25uLCAmZGJpbmZvWzBdLCB0ZW1wX3JlcGxzbG90KTsNCgkJfQ0KYGBgDQoNCk5v
dyB0aGUgdGVtcF9yZXBsc2xvdCBpcyB0ZW1wb3Jhcnkgb25lLCBzbyBpdCB3b3VsZCBiZSByZW1v
dmVkIGF1dG9tYXRpY2FsbHkuDQpUaGlzIGZ1bmN0aW9uIHdpbGwgY2F1c2UgdGhlIGVycm9yOiBy
ZXBsaWNhdGlvbiBzbG90ICJwZ19jcmVhdGVzdWJzY3JpYmVyXyV1X3N0YXJ0cG9pbnQiIGRvZXMg
bm90IGV4aXN0Lg0KQWxzbywgdGhlIHBoeXNpY2FsIHNsb3QgaXMgc3RpbGwgcmVtYWluZWQgb24g
dGhlIHByaW1hcnkuIA0KSW4gc2hvcnQsICJ0ZW1wX3JlcGxzbG90IiBzaG91bGQgYmUgInByaW1h
cnlfc2xvdF9uYW1lIi4NCg0KUFNBIGEgc2NyaXB0IGZpbGUgZm9yIHJlcHJvZHVjaW5nLg0KDQpC
ZXN0IFJlZ2FyZHMsDQpIYXlhdG8gS3Vyb2RhDQpGVUpJVFNVIExJTUlURUQNCmh0dHBzOi8vd3d3
LmZ1aml0c3UuY29tLyANCg0K

--_002_TY3PR01MB9889F3C46DC76CE77B91FB58F5432TY3PR01MB9889jpnp_
Content-Type: application/octet-stream; name="test_0201.sh"
Content-Description: test_0201.sh
Content-Disposition: attachment; filename="test_0201.sh"; size=1094;
	creation-date="Thu, 01 Feb 2024 03:24:36 GMT";
	modification-date="Thu, 01 Feb 2024 03:26:24 GMT"
Content-Transfer-Encoding: base64

IyEvYmluL2Jhc2gKCiMgc2V0IC1lCgpwb3J0X3B1Yj01NDMxCnBvcnRfc3ViPTU0MzIKYmluZGly
PS91c3IvbG9jYWwvcGdzcWwvYmluLwoKZWNobyAnQ2xlYW4gdXAnCgpwZ19jdGwgc3RvcCAtRCBk
YXRhX04yCnBnX2N0bCBzdG9wIC1EIGRhdGFfTjEKCnJtIC1yIGRhdGFfKiAqbG9nCgplY2hvICdT
ZXQgdXAnCgppbml0ZGIgLUQgZGF0YV9OMSAtVSBwb3N0Z3JlcwoKY2F0IDw8IEVPRiA+PiBkYXRh
X04xL3Bvc3RncmVzcWwuY29uZgp3YWxfbGV2ZWwgPSBsb2dpY2FsCnBvcnQgPSAkcG9ydF9wdWIK
bG9nX21pbl9kdXJhdGlvbl9zdGF0ZW1lbnQgPSAwCm1heF93YWxfc2VuZGVycyA9ICc4JwptYXhf
cmVwbGljYXRpb25fc2xvdHMgPSAnNicKaG90X3N0YW5kYnlfZmVlZGJhY2sgPSAnb24nCm1heF9w
cmVwYXJlZF90cmFuc2FjdGlvbnMgPSAnMTAnCm1heF9sb2Nrc19wZXJfdHJhbnNhY3Rpb24gPSAn
NTEyJwpFT0YKCnBnX2N0bCAtRCBkYXRhX04xIHN0YXJ0IC13IC1sIE4xLmxvZwoKKAogICAgZWNo
byAtZSAiQ1JFQVRFIFRBQkxFIHRibCAoYSBpbnQgcHJpbWFyeSBrZXkpOyIKICAgIGVjaG8gLWUg
IklOU0VSVCBJTlRPIHRibCBWQUxVRVMgKGdlbmVyYXRlX3NlcmllcygxLDEwKSk7IgopIHwgcHNx
bCAtVSBwb3N0Z3JlcyAtcCAkcG9ydF9wdWIKCnBnX2Jhc2ViYWNrdXAgLVggc3RyZWFtIC1TICdw
aHlzaWNhbF9zbG90JyAtQyAtRCBkYXRhX04yIC1VIHBvc3RncmVzIC1wICRwb3J0X3B1YiAtUgoK
Y2F0IDw8IEVPRiA+PiBkYXRhX04yL3Bvc3RncmVzcWwuY29uZgpwb3J0ID0gJHBvcnRfc3ViCnBy
aW1hcnlfc2xvdF9uYW1lID0gJ3BoeXNpY2FsX3Nsb3QnCkVPRgoKKAogICAgZWNobyAtZSAiSU5T
RVJUIElOVE8gdGJsIFZBTFVFUyAoZ2VuZXJhdGVfc2VyaWVzKDExLCAyMCkpOyIKKSB8IHBzcWwg
LVUgcG9zdGdyZXMgLXAgJHBvcnRfcHViCgpwZ19jdGwgc3RhcnQgLUQgZGF0YV9OMiAtbCBOMi5s
b2cKCnBnX2NyZWF0ZXN1YnNjcmliZXIgLWQgcG9zdGdyZXMgLXIgLUQgZGF0YV9OMi8gLVAgInVz
ZXI9cG9zdGdyZXMgcG9ydD0kcG9ydF9wdWIiIC1TICJ1c2VyPXBvc3RncmVzIHBvcnQ9JHBvcnRf
c3ViIiAtdiAtdgo=

--_002_TY3PR01MB9889F3C46DC76CE77B91FB58F5432TY3PR01MB9889jpnp_--