From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: 'Amit Kapila' <amit.kapila16@gmail.com>, Euler Taveira <euler@eulerto.com>
CC: Peter Eisentraut <peter@eisentraut.org>, Shlok Kyal
	<shlok.kyal.oss@gmail.com>, Tomas Vondra <tomas.vondra@enterprisedb.com>,
	"pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>,
	Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>,
	Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
	=?utf-8?B?RmFicsOtemlvIGRlIFJveWVzIE1lbGxv?= <fabriziomello@gmail.com>,
	vignesh C <vignesh21@gmail.com>
Subject: RE: speed up a logical replica setup
Thread-Topic: speed up a logical replica setup
Thread-Index:
 AQHYJxwq4n4kYsNKXkm+6ifSNI1R/bBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgACrngCAAM0jQIAPei1wgAAshICAAp5LgIADBLQAgACKXLCABEd0gIABoIwAgAB7ucCAAcm90IAAHJgAgAACwICAAAXhgIAAC7MAgAAh+gCAAIfpEIAAGb3AgACYWmCAAOVegIAAfuxAgAeMDoCAAAXdAIABBpmAgABeF2CACXUbgIAATP9AgAHL3uCAARDPAIAAoFUwgAQywWCAAeMXAIADek5ggAz2jwCABVnHcIADBCkAgADUOwCAANs88IAH2USAgAB1EYCAAojjAIAALVOAgAIrrICAAwXTAIAEFtAAgABcOwCAASjOAIAFQ9WAgAD1QACAAAa2gIAAEzGAgAAC1vA=
Date: Tue, 26 Mar 2024 04:26:43 +0000
Message-ID:
 <TYCPR01MB12077AED881D4AB12291DED29F5352@TYCPR01MB12077.jpnprd01.prod.outlook.com>
References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com>
 <e390e35e-508e-4eb8-92e4-e6b066407a41@app.fastmail.com>
 <TYCPR01MB12077121263EFF7680486B635F5212@TYCPR01MB12077.jpnprd01.prod.outlook.com>
 <40595e73-c7e1-463a-b8be-49792e870007@app.fastmail.com>
 <6423dfeb-a729-45d3-b71e-7bf1b3adb0c9@enterprisedb.com>
 <TYCPR01MB12077DE77454D68E959E85E35F5272@TYCPR01MB12077.jpnprd01.prod.outlook.com>
 <e8564096-3c4f-4990-ac7d-ba089739b878@app.fastmail.com>
 <CANhcyEW6-dH28gLbFc5XpDTJ6JPizU+t5g-aKUWJBf5W_Zriqw@mail.gmail.com>
 <2f0b73f3-e7c0-4e95-9712-1993442a6b64@app.fastmail.com>
 <CAA4eK1JtnzqYNQ_S+mj_XsPfgk7szxegKiVQq4-8fY1wUcUnpg@mail.gmail.com>
 <34637e7f-0330-420d-8f45-1d022962d2fe@app.fastmail.com>
 <7a970912-0b77-4942-84f7-2c9ca0bc05a5@eisentraut.org>
 <d546c4bb-92d1-4e2d-898f-48234b12ed25@app.fastmail.com>
 <CANhcyEWdTTO71v+GFYUTsOOUvHus1qccg88bRmsU9KykJqjSrQ@mail.gmail.com>
 <44de4e04-db22-40ed-8ba9-46387dc8bf83@app.fastmail.com>
 <3fa9ef0f-b277-4c13-850a-8ccc04de1406@eisentraut.org>
 <CAA4eK1L6HOhT1qifTyuestXkPpkRwY9bOqFd4wydKsN6C3hePA@mail.gmail.com>
 <6aa1b0d7-a4e9-46b1-9990-3ae1d22e1952@app.fastmail.com>
 <CAA4eK1KY98bzJdZ58F5vMjc=indfo1oYk01ESYBUFR-GxTdBHQ@mail.gmail.com>
In-Reply-To:
 <CAA4eK1KY98bzJdZ58F5vMjc=indfo1oYk01ESYBUFR-GxTdBHQ@mail.gmail.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels:
 =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?=
 =?utf-8?B?NTBfQWN0aW9uSWQ9YmMxYTM3MGItYTE5ZS00NmM3LWE2MGQtODlhMDZmZDYx?=
 =?utf-8?B?OWJlO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?=
 =?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?ZXREYXRlPTIwMjQtMDMtMjZUMDQ6MTY6MTdaO01TSVBfTGFiZWxfYTcyOTVj?=
 =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?=
 =?utf-8?Q?d-81e1-4858-a9d8-736e267fd4c7;?=
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: TYCPR01MB12077:EE_|TYAPR01MB5867:EE_
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info:
 tkd/a4R8OzLq9FmoyWfqZ3QzSEq8tLi2VKkRSrAYVZE3J7TkvkOhy09GAciPmGjBB+LWdGLeLHE58AYCmF4SQp11d2EyjcYygmuwtE43SUxppZFBhAkDVUjUm5vP6NlSLUc8xHhtUj4jwIX4PcW5+mpU9u3oV+0nMjevfAJlieVnlYUS66xEuEEn4IQ+KtECF/M2dzhHi/4VH9o6EbGs6gwFtGQPqtEf/vg8giKkA3hjg3oRl7w1cjR/pDkQf58Ab8oyddcENdYdF0f0lq6RqmKIaa67fmis2HW3gCuGCeMhW2VW0GsrbP+BFIqeUxwwxqvX+iyCCvNKogFF1T9xg4+OZl4QEko836FmkeDF/OnNkNdGm4tSgQano79ZrtHXlauOWN0HWeU6Cpte/yeGcHKydlmqks8v7T0yQwFdWqMYITWevUUxysbEhn0LKqbd38F9yvOW0dm/s2SPt80enoLt3seZLzmC/HFp43jTQ/LiZYUSpXXo+Z/qmrbNr9Yi/QehdyScJZvvIggpE3NkKaZgUQ+nZ5tAtvO0OF2NBa2F09CFkJWaIz/KCLPobUfwGt9/bmV4U/APLLn3iKgR4zA6w5mwZ6BRSRUYGPMA6Owg0dadDjXPg6h7s9dcwMwRu81pM61qKBSlhK7iLLVLAaPySMdeQhypiVOyT93oR4E=
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)(366007)(376005)(1580799018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?utf-8?B?TnNpNEkyTUlaYUpqbmpxZndxOVFqTjAxNEhmSHJEN01PaUJCbk1LMjk4K3FB?=
 =?utf-8?B?WnlOTUxzeTlEbzhnWVBISzZjbDB5YjJTRXBtSUgrWHR1TW1MdUtpOHNncjBn?=
 =?utf-8?B?ZzlTU0lJYlpQNzVhV1hCNXZNSld4S2l6bUx3MGpwUmtNWnlyajZnNEs1elpM?=
 =?utf-8?B?L2JpeFd1SldMUWZCanpLV0o5bExNREFheXY0dDVzaDdWU2kvUXpFaHF4MVZR?=
 =?utf-8?B?N0FtMGNRSGlQMGxzMFgwYVMwK0dKdnlYcWVGaDM2b2FNN2M1Q2FIcUtzSldR?=
 =?utf-8?B?SHlmc1VIaVJaL2hyVzZIcTViMCtydmNlME5HVCtRaVpDWnFVYnkyS01DcGdG?=
 =?utf-8?B?NUlZM3FBdGQ4OWZzeGovWEtlZnEwVkFvR0hqeDRMRU44bjhqcUdPS3F4aENM?=
 =?utf-8?B?MURGN0tvalB3SnMzeGZrOWVXdUlEWmlRYWhVMm85c3Z0SHBnOWVjUTBSeGIz?=
 =?utf-8?B?ODVndnJTbFBmNjUxQWhjeUxBUWgraFB6S0lVcXpBb3h0cWxMd2Q2VWFNVk4w?=
 =?utf-8?B?a2VhTVhHVTE0akUwbytBYW13SkZkdTdnelptRFRWZytTNDhaK0pnLzA2WFpn?=
 =?utf-8?B?bFVNV3I4WVRSaU8yRXRlaTZ6VGQwQWNpcWo4bEhQNmFEUm9lcnFIMVk3MXNF?=
 =?utf-8?B?blp1V2tjcW8yck1qZHc4aWRBOWw5bDhzRDJ1dFU3MEx6V2xUZEFqY2FOcU5T?=
 =?utf-8?B?VE1VUEVSNTdCVGZENTFpTEV2dEIxelFpbGhpR2d6MkQxMEU5RWxXdFoxQ0gw?=
 =?utf-8?B?ajBHeXFIYVhUSlRBQTU1WHBLV2VLbEkzdHZvS2ljUWNmSFBXUkdCWElDUTc4?=
 =?utf-8?B?am9PZFRIakVMM0lOY3QwZ2lEWTBHZmNEcTVieXpVWm0vNTc3eU03aUpUa2c0?=
 =?utf-8?B?SVltOFEvZnZHUzk2MlVpQkQwUng0ZjFmMnBEdzAvTDM5cHlVeFNMY0I2WVBU?=
 =?utf-8?B?N0F5cmZlT0ZmTjYzYnlpSHdPODNWcFgzTG9jL2paZlF5VHZBTk1ibkJEcG5h?=
 =?utf-8?B?c0lFRERZaTJidUpzMDZrcGIyNHcxK05BRWhPaXU4bDZWOG5wbk5Mcnh1OWp0?=
 =?utf-8?B?NnViTHl1dzI2clhBNWhyWExEdE1LTHo0M3F0WklzWXZheEoyK1UxRjR4a0hp?=
 =?utf-8?B?RnZWaktVVkh0Vk1LRXpWSkpZRHdBdFNzUWVaMVN3T0dGeWpseGE3QjlyMUdX?=
 =?utf-8?B?NkRjak1RUTFycmhaTWVGUjQwdUE4SVNjVUk0ay9oS2p3RW9NNVNDc01TNzJY?=
 =?utf-8?B?am1KdFZNbExmdGluZlduNTNkbkhabGhUWkJHZjgxclpnMmlFb3pTL2dMbWR6?=
 =?utf-8?B?UFVIUFk2OFVpQ3E3ZFgvMjhPbVk5b0w5RkE0VUdIekZFK1dwN1RqeWZPVVNW?=
 =?utf-8?B?UGVHQStCRzlzTWRUTjZ4WlBFL1pySjYrOWE1Zk93UmRWQ2RGeUxOYVMvZmpL?=
 =?utf-8?B?Zmh5RzZTQWxjQ1Z0UVZQT3g4cmJCWm5wTnhzYmMxOXJoVmFoK2NFV0JOMTFh?=
 =?utf-8?B?Q2wwVXk4ZkdYNkNOZysyc29ScGhyejB3anE4aTVkMUV2U05YQmdtMFhzOE8w?=
 =?utf-8?B?S092ZFZwNDZtb3hxMTZhQS9SQnlMUDNFNFVidDFIWFdEcHdWNnJ3KzlHb1lO?=
 =?utf-8?B?SE14LzBtVnNqZlVHMzE1RDdGanpPd0w2elQwYW55akZvT3BxRnNidGxmcTZS?=
 =?utf-8?B?TkVyTE5CWmFxN1M0VHdEUE5IUmt4RG1qSU9hbFQ4ZnRzWVVPWm5kY01OTGhL?=
 =?utf-8?B?akZIUFVUQjlBWUpsdVMyU1hMNmhFbExpcWVMOGZqc3UvRktTd3JOZ2Fxb3d3?=
 =?utf-8?B?ZXM5bG1RNnc4NGRXZjdqVkY4LzBRbE1rN1kzM0t3d3M4WWFHOVNzWG5oMXF0?=
 =?utf-8?B?Q0FvRXZVN3p6VVVjdE1mMTFZcE81MnFJQVRTVm94Z3IzcXo1TkNvWlZDQUls?=
 =?utf-8?B?VVVJb1UvV2phelVNd1RKZlQzSDhDOHJVYXZSNVFGNHU4aGdSaW81Z0twbVU1?=
 =?utf-8?B?bWl4THQvUFZvRG1nTTYzT3kzL2hHQjkxQU02dWNJWFdDOXVnY056ejVHSnFv?=
 =?utf-8?B?akc5bGtzcDRPMndUbC85MFRVTmtYTHBEcTN3cXRndElaNjVTdkdrMU16aS9X?=
 =?utf-8?B?SFRQWXR3QVFwUDZwRXVma2srWmFXL0dISVEvMEVBWEJidHQwY3NKcjlQa2V5?=
 =?utf-8?B?YWc9PQ==?=
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:
	JPoBwpp/bf76Zcs5VwykxU9la0tgmUiZ7FOamDSgBwWnJYnIvBoMlkcjPdSLkw9NxCL86SZ20/dfuv9CUlGXNu75xVE52+yJ2T0jXzxxZF4S1zFFjGFNggOthTz0cXUPvSHvsqqqWfv+sYQUTIKkH/3iSLXtq7P8MIHu1FKHbseFBmCA3vG5L2aqy9yv5AcpCY3500DPwBbBIrbvQMn1wys+650VZk01xkex5l8FPrrqjcznM0WAW+LWhfTcaeMvqwL5eoQyzxSBAkqVbcYIgpYKoRi6E8UDDRcMOOs+Ym3CYAHwHXWrH5d3fp+2rH5sFxqW6F8zS/v1KYDxLdkgRIljn4vurSyc2C5HA74hcm5K2vXKhfaLMfTmOMyiju+Nkvx4jjCs9tK39kCaXP2SSDjk/3n+A0qfsqh6OyVZeahUH7TMNMo0jrivAohxkTAUb6zw9jCanYds6Uu6QjJOhhde/3DZWK355Xk9I10uKo11YC5OCUxsqsThTLwlEQKWmqAL3+gJxNzGYtRVJ/DGLIgFNy1onItqPYzZyO8mM/JKezScUGtd8w7p99rLa1eVAIZnpEPWXWxbn8atPZQUo72g12n3SHAjPB4m3Iia0eTvg0/LuLROunEMocDIiekN
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: c8d61ef8-bc23-49f6-79e6-08dc4d4cf110
X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Mar 2024 04:26:43.6952
 (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: 0pwP5P/uK4n7RPuPi6s8Zz1Ol3+/FkOWCiGQ+ry1EMee9NqfxaxMYG/mXI4U0QzU24o+cwzyFr3ycPJL1j7gAHHHjkk7LEQ8eRT+c6vEUtI=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB5867
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/TYCPR01MB12077AED881D4AB12291DED29F5352%40TYCPR01MB12077.jpnprd01.prod.outlook.com>
Precedence: bulk

RGVhciBBbWl0LCBFdWxlciwNCg0KPiANCj4gVGhpcyBvbmx5IGRyb3BzIHRoZSBwdWJsaWNhdGlv
bnMgY3JlYXRlZCBieSB0aGlzIHRvb2wsIG5vdCB0aGUNCj4gcHJlLWV4aXN0aW5nIG9uZXMgdGhh
dCB3ZSBkaXNjdXNzZWQgaW4gdGhlIGxpbmsgcHJvdmlkZWQuDQoNCkFub3RoZXIgY29uY2VybiBh
cm91bmQgaGVyZSBpcyB0aGUgY2FzZSB3aGljaCBwcmltYXJ5IHN1YnNjcmliZXMgY2hhbmdlcyBm
cm9tIG90aGVycy4NCkFmdGVyIHRoZSBjb252ZXJzaW9uLCBuZXcgc3Vic2NyaWJlciBhbHNvIHRy
aWVzIHRvIGNvbm5lY3QgdG8gYW5vdGhlciBwdWJsaXNoZXIgYXMNCndlbGwgLSB0aGlzIG1heSBs
ZWFkIGNvbmZsaWN0cy4gVGhpcyBjYXVzZXMgYmVjYXVzZSBib3RoIGxhdW5jaGVyL3dvcmtlcnMg
c3RhcnQNCmFmdGVyIHJlY292ZXJ5IGZpbmlzaGVzLiBTbywgYmFzZWQgb24gdGhlIEFzaHV0b3No
J3MgcG9pbnQsIHNob3VsZCB3ZSByZW1vdmUNCnN1Y2ggcmVwbGljYXRpb24gb2JqZWN0cz8NCg0K
QmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBMSU1JVEVEDQpodHRwczovL3d3
dy5mdWppdHN1LmNvbS8gDQoNCg==