From: "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>, Marcos Pegoraro
	<marcos@f10.com.br>
CC: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: RE: Initial COPY of Logical Replication is too slow
Thread-Topic: Initial COPY of Logical Replication is too slow
Thread-Index: 
 AQHcZqqZNqfLv16B3UeDy2S4lB2IWbUp2xSAgDAuDwCACy6hgIAvDagAgAN0IYCABUmPoA==
Date: Tue, 3 Mar 2026 10:22:29 +0000
Message-ID: 
 <TY4PR01MB16907733B75A99117F013AFCA947FA@TY4PR01MB16907.jpnprd01.prod.outlook.com>
References: 
 <CAB-JLwbBFNuASyEnZWP0Tck9uNkthBZqi6WoXNevUT6+mV8XmA@mail.gmail.com>
 <CAD21AoA6i2ui8FMZeuU_KxX4t-fM8G==zTW2Dp6-goujttrpew@mail.gmail.com>
 <CAB-JLwZpp=7c9_r0beWWJxRh2BS_2Vvth8UDv7H57DBeaqggVg@mail.gmail.com>
 <CAD21AoDT3sL2COprsRumM9zEpL1Bk5VWboK4V2mRnjGua8xfeA@mail.gmail.com>
 <CAD21AoDQM62GOtaTzD_CVMSsFhv6o9c0Au1dSM1QuxeKFkWAKw@mail.gmail.com>
 <CAD21AoCz7HjEr3oeb=haK31YHxHZLcvD_wx_a-+xLPKywq++3A@mail.gmail.com>
In-Reply-To: 
 <CAD21AoCz7HjEr3oeb=haK31YHxHZLcvD_wx_a-+xLPKywq++3A@mail.gmail.com>
Accept-Language: en-AS, ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?=
 =?utf-8?B?NTBfQWN0aW9uSWQ9MGI3ZWI4MGYtY2I0ZC00MTFhLThlYWItZmZkMTAzODZm?=
 =?utf-8?B?ZWRmO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?=
 =?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?ZXREYXRlPTIwMjYtMDMtMDNUMDg6MzI6MDdaO01TSVBfTGFiZWxfYTcyOTVj?=
 =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?=
 =?utf-8?B?ZC04MWUxLTQ4NTgtYTlkOC03MzZlMjY3ZmQ0Yzc7TVNJUF9MYWJlbF9hNzI5?=
 =?utf-8?B?NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfVGFnPTEwLCAzLCAw?=
 =?utf-8?Q?,_1;?=
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: TY4PR01MB16907:EE_|TYWPR01MB10968:EE_
x-ms-office365-filtering-correlation-id: 9860a6ec-d36f-41cd-4890-08de790ec63d
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|376014|1800799024|366016|38070700021|1580799027;
x-microsoft-antispam-message-info: 
 7zPVgO3++9NJo1zeujx+jsTS9ug3TZvkj3xQS28GZ2uxgHXf21y8pOhpuF1RaSuGUJULL5sYQtLOPTTxvoo450u0tHhJWsqJ6jPnD+yl9cI5b0F4obEwSxcO+Cct9D7Skx/KCo8Cs18k43hBd0R+nepmYSqGeCQEF9ytNlgSOCdrJwGLMXril1+ROdbDEKfXQ16tNHkW3LPPXYEe7r5aQx+/Q3oIya5P4WM1/aqvsPdYKbfr7/ewA/YO266cVUQk5t2ZJfC1M6w9HEJpmKsuVukZN/G0FSzanjxHwUDiXEOIx0k27+S2MyQhMBHEhihV4MNoNzC7Hc25ndqJ0S6+HQkSoc/r/buHJgJ+gddOAtm9RbGD5AeZWmT+XJpxKLCcMVG0NMumSxrvJBo8+jy+bi8rfcmb/iGd+iNf1K8Rhdsex21VBE7i++OZyKsusiA8o9KVyRqNqUYPAWOVzK0e/wawdR4Ylp73qm1w/x42RCyVXGOcFDl9fIFwFvLsEyLs00dKkRYOFcGIF91jN71fmXfSiVGTYqEurLEiFI1qLWI1LPulZP4rGvQxg0mgdyJHWXEGEepHkcqOW+mR7FNHPIFxWy819Zw4RBMziY0TZnhOeigZ3affsaIjS20DLiWBgjnIOm0ozb3kzXzXzB2jC9uymyurZFI0AhkBF+tm+gW8G9/LUxj9EBpDMH0JC50h+7LhLtvDVnZFzXNHr2zGbrmK7DAMBoL1FY2eO7kxSJfqpdfWA7c6ibFhaMTQtNj8JjcOTLoImWTW6BZ2i30OGfVREW6Zvx/WL/rinpBbzsuaXW1tFKi/p0UHWGcj+nZ0
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY4PR01MB16907.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700021)(1580799027);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?utf-8?B?YmVzVmNQaDZocU1YaXlrUWVqM0JOakkxZkJCTnBuaW4rTkx4U1ppeDljcFpp?=
 =?utf-8?B?Y2NqTS8xZ2RiMlo0NE5od2pkV2thWEZnaDhXNWRIek1aN3R3ejkxbHZ3cmFv?=
 =?utf-8?B?aUtmSTQvbDk0MUJQVXROT2toelk0VFVsZGszVmpOeUtFLzlNT3M5bE9sY25r?=
 =?utf-8?B?VFlkTDB5WUl5YW1vd2dLR0V6a1RDSWNWMmVnWklEK1o4Y3c1MnlaTWQ1citL?=
 =?utf-8?B?RFFyd2w0c3BWWVUxRHBKZlM4d3dSVDhPSzJQK2Ywc2FOQTkreUQ3ZE13YTVE?=
 =?utf-8?B?enFLbUZMdTdHUE9YYUV3TjBTYzc2YWVkMTJoUEVLU0tzMWFwaExqSXJvSTlV?=
 =?utf-8?B?M05hamxFaE5hUFExVGFpOXFiRHJRem1ITStqejBpTTdFS2doSGJQR3RSTVdN?=
 =?utf-8?B?dStWQWk2S3RNSzZYZWQycHA4MXp2eEZnNEw5b0tXL1cvek8yUVBDRzlXWDJO?=
 =?utf-8?B?dWtneWF6TER3TEFuRDZScjdrc0FSTjd3QWV1MXFuY3g4MGxsNXJzSURRTjdY?=
 =?utf-8?B?MnhVSnc1YmVWZnRYYkpyWnhJTkJGTTN0Sm5pT0MrZldUL25MeXgrZWlGOURt?=
 =?utf-8?B?UmhTd2g4ekdLSVNJTVY0L1V1VGduNG5LTUl0cWZaK3hGZkptQWRxaG43QUZp?=
 =?utf-8?B?cEVWQTk2TjFuQTRITHZtS2NoUXVkclpIYWF3cytqVlNSZm11cjRXTTA2UHhW?=
 =?utf-8?B?cU0yc3ZJNlFDNmlDbHRYeE02dGkrMFgzTVgxOGltZmNnVVlXU0N6elRPNzBL?=
 =?utf-8?B?Szg4MnAwTGNndExCdVJBNGwyMFZNRlo5OGdzbVh4MnR0aWxFVTk3MENjcWlH?=
 =?utf-8?B?YkZ4UnlVdExJaVJ4Q01VWDJOeGJYaWxhT21CVkRwZTgxU0hnM3VaM2FKNm96?=
 =?utf-8?B?bXJrT0pLbVlFcFlHTDNZQWFOMjBSK3JmTWVvTDgwbnBJekJyUU8xanZZcVV5?=
 =?utf-8?B?UzdZS0k5M0lZUFgyelZrMGQwb0czU3UxNDN4aDJFK0R5MS9oYm8xZjRUV0hq?=
 =?utf-8?B?MVo3bHQ2dWRXWklLMVFpaU0yTEM3RHlyYmoyOWF5UVBWVGZNOG1EdFE2Q0Fr?=
 =?utf-8?B?VDNiOFhQVG5KUmpMVCtHTmlBbTJ4REk2RUJpZUJaOExpVVFiOGFSdWRFaElF?=
 =?utf-8?B?bmNGTHU1ajJWTWowbTdCaGdXVCtRaHc0OHM0dTJHb0pDcXA3QVZRVEZHSUFt?=
 =?utf-8?B?cWI1SnVyV0dxcHRBY0dncXRRREE5a01ZdW1yUUZyckxDYTcrV0tDVi82WC9P?=
 =?utf-8?B?bWF4WjZybGphaE5pTUY5NSs5VkhBSkVLWnpCaFozZkZKUUlMaVBqYURsa1R2?=
 =?utf-8?B?Si95STRxaVZmZzljNEdic3dRNVdGUWpJQ0phanZwTERtVGY5ekd4NFIyRWxF?=
 =?utf-8?B?b21SY1c2OEFURzFGZHh5TWwwR1dyV2hFbTdwcStPcy85dnBuU1k1M1RLdmp2?=
 =?utf-8?B?RHorTnoxVnNibml0M2N6YkNSOHNPWHU5YlVicnlCVTY4c0hxblJBdy9LOUJz?=
 =?utf-8?B?SW1oVFI1aTM3VDRFd0hod3o2MkNqMHh3alZ0WE16cGZ3Rm9RMVRuRFovcFI3?=
 =?utf-8?B?bDJUZjlPWWw2aW1ITHpSYnJrTDcrTTlKaEZDNjQrTWtrQ20yQi93VElUM2Fp?=
 =?utf-8?B?TFlnZGVxRVdsMjRYV1pSRGhnV2k0TDl0b2FUTXdKblAxeStwMnlhQmlqenhC?=
 =?utf-8?B?cU12WTYzOHIxRmlIZ3pEQnhYU0JOYzl4NHpEbWdDc0g1SU4wLzV3aVZwZWJa?=
 =?utf-8?B?QTlPalZJQnhqTm1RN2hwTXdmZVBVL2hQVTB6NHpKTktjNDRsTzIyeDdqa0tK?=
 =?utf-8?B?cW4vZ2ZjcnZSMkdrM2poRlF5YTA4NVppK1dMMTMweFVpUFZ1Q0loOEFzRkQ4?=
 =?utf-8?B?bXU1SmJiT0xBdEZ6WWZRNFcybDRjM0NRZUxMQ1J4MXZYSldIaEZkNy9Jd3pu?=
 =?utf-8?B?OGFkd2w5emhCMmZnQzh0RkpNV0FqOWp0SnF3M1VhUzJxWXc0dlJ3RVM3VnFU?=
 =?utf-8?B?SExKMTBkaHEvSytzSi8yYUFIWXNOV2hLc3VNQlAxbUkwQ3ZmSTJ1T3c4L1hD?=
 =?utf-8?B?bXFUeld4eTl1WVpCeU12SlBxaXdoam84Y1VGWUp1a0w2Sy9IRTRLbkhrRFEx?=
 =?utf-8?B?ak02WUd6bEsyc2NPWXpyYjA4SzdSUmwzN0piZjFLbFhOeUFXRjljUHA2WW1O?=
 =?utf-8?B?a3hRYmVrMUtiQ0Z2YlhuMG0wZmIyNUd5d25VekxZMjllMWRENE15NHNNc0pt?=
 =?utf-8?B?NzBtUmRKSnV1c3QvZ3dBeXkvendvSEhTd2NZb3crTEFTSE5BaEZmVU1QZlhS?=
 =?utf-8?B?NzVGNjUvYWVZUzR5MGswcEUyU3ZpanFmZmh2ZU9zWFplYmpIQ1FyUT09?=
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
MIME-Version: 1.0
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TY4PR01MB16907.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 9860a6ec-d36f-41cd-4890-08de790ec63d
X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Mar 2026 10:22:29.5156
 (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: 
 +xrPFLyDyL0730CLEWZ6ydjE6elye3DWNuGiiCdm4YDNfBuyoI0c3TyWx3hm57Q61l7trR23IS1FqbdyJdwT0w==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWPR01MB10968
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/TY4PR01MB16907733B75A99117F013AFCA947FA%40TY4PR01MB16907.jpnprd01.prod.outlook.com>
Precedence: bulk

T24gU2F0dXJkYXksIEZlYnJ1YXJ5IDI4LCAyMDI2IDc6NDggQU0gTWFzYWhpa28gU2F3YWRhIDxz
YXdhZGEubXNoa0BnbWFpbC5jb20+IHdyb3RlOg0KPiBUbzogTWFyY29zIFBlZ29yYXJvIDxtYXJj
b3NAZjEwLmNvbS5icj4NCj4gQ2M6IFBvc3RncmVTUUwgSGFja2VycyA8cGdzcWwtaGFja2Vyc0Bs
aXN0cy5wb3N0Z3Jlc3FsLm9yZz4NCj4gU3ViamVjdDogUmU6IEluaXRpYWwgQ09QWSBvZiBMb2dp
Y2FsIFJlcGxpY2F0aW9uIGlzIHRvbyBzbG93DQo+IA0KPiBBbm90aGVyIHZhcmlhbnQgb2YgdGhp
cyBhcHByb2FjaCBpcyB0byBleHRlbmQNCj4gcGdfZ2V0X3B1YmxpY2F0aW9uX3RhYmxlKCkgc28g
dGhhdCBpdCBjYW4gYWNjZXB0IGEgcmVsaWQgdG8gZ2V0IHRoZSBwdWJsaWNhdGlvbg0KPiBpbmZv
cm1hdGlvbiBvZiB0aGUgc3BlY2lmaWMgdGFibGUuIEkndmUgYXR0YWNoZWQgdGhlIHBhdGNoIGZv
ciB0aGlzIGlkZWEuIEknbQ0KPiBnb2luZyB0byBhZGQgcmVncmVzc2lvbiB0ZXN0IGNhc2VzLg0K
PiANCj4gcGdfZ2V0X3B1YmxpY2F0aW9uX3RhYmxlKCkgaXMgYSBWQVJJQUNJRCBhcnJheSBmdW5j
dGlvbiBzbyB0aGUgcGF0Y2ggY2hhbmdlcw0KPiBpdHMgc2lnbmF0dXJlIHRvIHt0ZXh0W10gWywg
b2lkXX0sIGJyZWFraW5nIHRoZSB0b29sIGNvbXBhdGliaWxpdHkuIEdpdmVuIHRoaXMNCj4gZnVu
Y3Rpb24gaXMgbW9zdGx5IGFuIGludGVybmFsLXVzZSBmdW5jdGlvbiAod2UgZG9uJ3QgaGF2ZSB0
aGUgZG9jdW1lbnRhdGlvbg0KPiBmb3IgaXQpLCBpdCB3b3VsZCBwcm9iYWJseSBiZSBva2F5IHdp
dGggaXQuIEkgZmluZCBpdCdzIGNsZWFyZXIgdGhhbiB0aGUgb3RoZXINCj4gYXBwcm9hY2ggb2Yg
aW50cm9kdWNpbmcgcGdfZ2V0X3B1YmxpY2F0aW9uX3RhYmxlX2luZm8oKS4gRmVlZGJhY2sgaXMg
dmVyeQ0KPiB3ZWxjb21lLg0KDQpUaGFua3MgZm9yIHVwZGF0aW5nIHRoZSBwYXRjaC4NCg0KSSBo
YXZlIGZldyBjb21tZW50cyBmb3IgdGhlIGZ1bmN0aW9uIGNoYW5nZToNCg0KMS4NCg0KSWYgd2Ug
Y2hhbmdlIHRoZSBmdW5jdGlvbiBzaWduYXR1cmUsIHdpbGwgaXQgYWZmZWN0IHVzZSBjYXNlcyB3
aGVyZSB0aGUNCnB1Ymxpc2hlciB2ZXJzaW9uIGlzIG5ld2VyIGFuZCB0aGUgc3Vic2NyaWJlciB2
ZXJzaW9uIGlzIG9sZGVyID8gRS5nLiwgd2hlbg0KcHVibGlzaGVyIGlzIHBhc3NpbmcgdGV4dCBz
dHlsZSBwdWJsaWNhdGlvbiBuYW1lIHRvIHBnX2dldF9wdWJsaWNhdGlvbl90YWJsZXMoKS4NCg0K
QmVzaWRlcywgZm9yIHVwZ3JhZGUgc2NlbmFyaW9zIHdoZXJlIHRoZSBwdWJsaXNoZXIgdmVyc2lv
biBpcyBvbGRlciwgSSB0aGluaw0KdGhlIHBhdGNoIG5lZWRzIHRvIGFkZCB2ZXJzaW9uIGNoZWNr
cyB0byBhdm9pZCBwYXNzaW5nIHRoZSByZWxpZCB0bw0KcGdfZ2V0X3B1YmxpY2F0aW9uX3RhYmxl
cy4NCg0KMi4NCg0KSW4gdGhlIGZvbGxvd2luZyBleGFtcGxlLCBJIGV4cGVjdGVkIGl0IHRvIG91
dHB1dCBhIHRhYmxlIHdpdGggdmFsaWQgcm93DQpmaWx0ZXIsIGJ1dCBpdCByZXR1cm5zIDAgcm93
IGFmdGVyIGFwcGx5aW5nIHRoZSBwYXRjaC4NCg0KQ1JFQVRFIFRBQkxFIG1lYXN1cmVtZW50cyAo
DQogICAgY2l0eV9pZCAgICAgICAgIGludCBub3QgbnVsbCwNCiAgICBsb2dkYXRlICAgICAgICAg
ZGF0ZSBub3QgbnVsbCwNCiAgICBwZWFrdGVtcCAgICAgICAgaW50LA0KICAgIHVuaXRzYWxlcyAg
ICAgICBpbnQNCikgUEFSVElUSU9OIEJZIFJBTkdFIChsb2dkYXRlKTsNCg0KLS0gQ3JlYXRlIHBh
cnRpdGlvbnMNCkNSRUFURSBUQUJMRSBtZWFzdXJlbWVudHNfMjAyM19xMSBQQVJUSVRJT04gT0Yg
bWVhc3VyZW1lbnRzDQogICAgRk9SIFZBTFVFUyBGUk9NICgnMjAyMy0wMS0wMScpIFRPICgnMjAy
My0wNC0wMScpOw0KDQpDUkVBVEUgUFVCTElDQVRJT04gcHViIEZPUiBUQUJMRSBtZWFzdXJlbWVu
dHNfMjAyM19xMSBXSEVSRSAoY2l0eV9pZCA9IDIpOw0KDQpzZWxlY3QgcGdfZ2V0X3B1YmxpY2F0
aW9uX3RhYmxlcyhBUlJBWVsncHViMiddLCAnbWVhc3VyZW1lbnRzXzIwMjNfcTEnOjpyZWdjbGFz
cyk7DQogcGdfZ2V0X3B1YmxpY2F0aW9uX3RhYmxlcw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tDQooMCByb3dzKQ0KDQpCZXN0IFJlZ2FyZHMsDQpIb3UgemoNCg==