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.96) (envelope-from ) id 1w76rn-004y9W-19 for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 07:16:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w76rl-001ndC-0a for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 07:16:53 +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.96) (envelope-from ) id 1w76rk-001nd1-2Q for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 07:16:53 +0000 Received: from mail-japanwestazlp170110001.outbound.protection.outlook.com ([2a01:111:f403:c407::1] helo=OS0P286CU010.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w76rh-00000001xBa-3kNN for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 07:16:52 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=W5WVNpSeTRIm2se08siPNu1x/2iLAcOR+D1TNtdUxvR8CmZvLdD1SpzyagcoOCNdYuFd+zn9haSAt2sylfNgJli+5/Hy5tZEbJqLAujn8cupIQ+S/9hc8Ja77rOaoPSaK/Qc2fxoYWxHoRIaZNe6vR5uQqucp40VggFeF5+ygKK9jJf74Ty2ENtvMXFwaORcowrzyqY/2HiGBhc6R6LjIxVDhoMFyR3KBWOr+gWa6nFCR55laNiWrs4VVroV+bNBNBX0oo32USsgQQf9DdKIMrd/a3icPHpoSqbNbO48/9GjGSoybk4U5XLv/TS6k/Ie03vyIjLL+rObvstA81Ilcg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=UGvRQDwjXOjLatAV5EyOmrbnGxXTqyCVw8gukNDj6G0=; b=t5L6bMwYBm0H5ca+QV2b6IS5iR9t+Am6oznsjGqYof1m8j45JXVUcRaKNLU9MuZwq8WICwpye87cLgqXg0OaBCjFIy47xgqJ+osDUNWeVkeHe1b5Kej7sBAxWt9vT4OZ5nR/LkbUDkzYokHTHdofn1mrUG2Lzji7slMXguL5Z6+LYUynPHkm5uzoWK08/bXSIFdb4H6+dV4cvuAuHVSIfLnQGmFJlas5/Mk36RmfPB2iZttZn/GwB21v1bdd8q70BUNmdFBhhJq9dZzNzyrsfZU8in6xbL1KWs55wYozeBO/qYvkYKdstGVCGXxmODIT8ljsJs/jFEJCUUHuANIlBg== 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 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=UGvRQDwjXOjLatAV5EyOmrbnGxXTqyCVw8gukNDj6G0=; b=SVJxE+EJabduwrlzqtiuyS/sc+zuKclves6205fNgUoxKlkB61OJQpHZv/FtRoEBgBc2IB5BnEubb+OvCpQr6DEvGKxOhyw73+xSK/Emkrs9VvxilRF6ZV4sLooV+Vq1wrXIHvNycGpKA6A6GMKKqnwtQMvk78qYetFb/IVDfa8pH001i/UeBpAEJMjkYsZYnG9o0bObshyj0BeLG9y2NP72Hiz+/RljqnPsB+1DH8kWUTUQ4LHxTnBtSIfdxje4SipN3Q1kCC1EDl0C3AONuocjFbhRjL9P9brpLjrJIKMajQomYZBP14mfzZApczsBzIor77yXVhjZ9w4KXh3AAw== Received: from TY4PR01MB16907.jpnprd01.prod.outlook.com (2603:1096:405:338::22) by OS7PR01MB17455.jpnprd01.prod.outlook.com (2603:1096:604:437::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9745.28; Mon, 30 Mar 2026 07:16:43 +0000 Received: from TY4PR01MB16907.jpnprd01.prod.outlook.com ([fe80::bbb7:659c:a6e:927d]) by TY4PR01MB16907.jpnprd01.prod.outlook.com ([fe80::bbb7:659c:a6e:927d%4]) with mapi id 15.20.9745.024; Mon, 30 Mar 2026 07:16:43 +0000 From: "Zhijie Hou (Fujitsu)" To: Masahiko Sawada , Amit Kapila CC: "Hayato Kuroda (Fujitsu)" , Jan Wieck , "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: AQHcZqqZNqfLv16B3UeDy2S4lB2IWbUp2xSAgDAuDwCACy6hgIAvDagAgAN0IYCABUmPoIAKUmUAgA2bHACAAC8cAIAAOcIAgAAnEYCAABAqAIAImQ6AgACJHwCAAKosAIAB8HgAgADb/wCAADlZgIAACdIAgAApfYCABMU+wA== Date: Mon, 30 Mar 2026 07:16:43 +0000 Message-ID: References: <0c28fbd1-3320-4e9b-815c-6d62753aa063@wi3ck.info> In-Reply-To: Accept-Language: en-AS, 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?NTBfQWN0aW9uSWQ9NDNmMTdlMTAtZTJhZC00ZjNjLWE3OWItM2U4ZmNhNTg0?= =?utf-8?B?MzRiO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZXREYXRlPTIwMjYtMDMtMzBUMDc6MTE6MDZaO01TSVBfTGFiZWxfYTcyOTVj?= =?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_|OS7PR01MB17455:EE_ x-ms-office365-filtering-correlation-id: 2909ba7d-fa7f-401e-a70a-08de8e2c4b9f x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|56012099003|18002099003|22082099003|38070700021|1580799027; x-microsoft-antispam-message-info: a9JTeW9FGohJ7gJAmlsQeCmAI5h/BwKAdPXNKsYj0j5W/yplwNlmTZp+JQsPFG25aFdU8Q1PxwE5COOUarHQLROgm55Vw3I/lNPxUrLrEPyd8gxiddLwYHEbIKpLcS8MfoKL5k52pbfVhAggX09WcuxgIFINPKvZvsrVWEsis7FOSRFq4t6T9DPayR9zHHZCyqa0ziC/7sHbZb+A8sp0Sb9rfSxad5JUAeeIOB7ivDDCZj5+E3iYAf7WqlVLh10z7zJD3ye/9ob2sWe/47q6Qunre3wGrzwNlSsmbxBAec/eBZjnIDtWy2oHA9jxPdxFfXQzCxmZHpK6Wbk6Tt4dIMRx/8HaiMxBWMiV8e4ydcltGk26bmYhZV2owhyNNYCA5lYJORsOBqh2ERXcrSKte1Wq0sM6H72wN551j789K8e9idAhfGs+wGTStfExXQei7Uug76mjYLOLFiaeymFKZ+lZGQP8SjOHd6xEPVHyUeFFIhdoxu24k7aqOzUuCY0fiCznL4wPlLgeC9XWi7E+WDN/4YtUVweEGK/SEPzyppYtL5sNBxAh2bCHzeva3jTZAm6KCr9+4PAwsl3/eSuSKRF/0MlXaFomocZuElFRyMSTrmhOtgTvRoMgfKYG04tUePFd/UJD+t80JwtYRMvvMvVHJfSGdk0hNJ2A4GRmv33u7X2MywUHRUNtrTlMG3/E6ofRRzuczWxEiUwWnYc8w1vkPn6Jje60eLZ13xjtty6QLy8LAahaY113fFJLXqRX1ZWa0rKKLeXufU9+tXc2TXSZCwlHlt0tmq0x0qtTTFKCQkdGQ+WV6lYJuQcP/IbH 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)(1800799024)(376014)(366016)(56012099003)(18002099003)(22082099003)(38070700021)(1580799027);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?WHBuUGszSHFsYWlyTGIzaFVzd2wxNVFGSXkyQ0VXbjA0MExqakYvblNCVTYr?= =?utf-8?B?eEorNUlObk5YZDVZVlYrOHkwS1NuOXFLK0FiSVFHZWlVQ0Z5dDBZRG5JejBV?= =?utf-8?B?bmh4K0hzWmw0YjkwejJqb1ZicTA1UnpTY1RyNVFhMjZVUG5mVk50ZU1EK0li?= =?utf-8?B?Y25iZkliRGpJb3RKK2lKMUdkb2QyZG9yVlh0dEprRVdMeFdqZDN3aThvUU5K?= =?utf-8?B?eE52Q1Q0RXdJdzRKTk53alZ0NDFubDNTZkw2M0h4alFFekUzeEQxTmlxaklz?= =?utf-8?B?UEFTYkU4MlZoWWVoNVJFZldKdkVsRHdHNjlyVHJqK3BQbHo5dU5qaXhGQkY3?= =?utf-8?B?cGhpTFNCazh5Q3JBelptSnlLMXZqdDFhcVRFaXkzZ0VaRjB2RC9KTUpFVHRP?= =?utf-8?B?bUxQR2lHYjJ2bWJQRHllN2U5cDkrcTBqaVh1MnRKZWJvdjZaNzBSUXMrS0Mz?= =?utf-8?B?Y2NWLzdXNE8rYUR4TUlzeGxtV0g4dm1SdE5VaDc0dzJNVmxCMmRZUm1VSmM5?= =?utf-8?B?aitLOC9XV2lySy9zeEVTbHJYenRhSEVJN3Flc0RyNkVCK0dTdjFqczgvL0I2?= =?utf-8?B?VExJVElNWWFxbmpNZy9nckh2L1AxVWEwRXRrR2FCRkpBdVBvNVlCWFFtQVVk?= =?utf-8?B?UmdYMVBjT2JuNEloWUlTeGFRMlM3dmU5QlVudmdVZFFVME5iR3hnQ3gzdjRa?= =?utf-8?B?RzhOUFNjQ0tWdkVQdjBYdU1BRE1RdDQ0TitIcGI1RnhWWnYzNDU2aTFDMjlY?= =?utf-8?B?elhHMHBMSWVXRGx5WTBoZk1XalMvMkx1MHQyU1IrSXorQlI5eUFzZ0k3NXo2?= =?utf-8?B?a0cxL0hkQ1prRkp6U1hNaDR0aTJHZkRMcEFobWJTV1FTSFRLNzBncE5JS09I?= =?utf-8?B?OFlLTXNtUjFDWk5uQjNNbFpEbmlCZ1BrU3QwNmVKL1FoRVdpTlZOYkY4UmpC?= =?utf-8?B?enU2UzhGOHdNRHRIK3I3eDN2b3YrMjBxa3NwUVkyY0lRSjBvM2tGOSsvUkZ5?= =?utf-8?B?c1NoQVBHS3ZzTWE0aGlqcHJ3L0YydWV2bmt5U21scWU4K3dxRkhCTkIvNXRv?= =?utf-8?B?V3JabDVCd1lJR05RNm9lZEJZZjRqL1FWL0NjOXBaSEpua0g2RUwwUUpVY09W?= =?utf-8?B?RFM0UTgxdkY0K1FJSmppTGR1QmI0am5pUWtNQ3NvbjVWbUIzOXJYVG02L3Bo?= =?utf-8?B?Uk5nRTE4ZzluUHJ4L0tRK1IySmNzd21GRU1SV2xxWXlDQTkwSXQwaitXa1ZZ?= =?utf-8?B?ZlU0VC9mK1JYNFd3aFFYRFdYTzZKTnUzTlQzYWk3aFVGV2Nzb2lMQ1BzOC9J?= =?utf-8?B?SlBZNXlMNlZ0eFZCVHpuRGgrUVFHT1NvUkpvVEtFNy9KQzluVXZ3dXNBZ0xu?= =?utf-8?B?WDZWd1dIN1g3VjBNME9PeE5oeFIyL3RJSm5UWHhaY28yd0dHaWN3NzNsd3NV?= =?utf-8?B?L0hHQVI4Y21sMGxzVUs3c1g3YTRNMzNZS29YazF1NXBWSjREM3B0M1VtMGsw?= =?utf-8?B?ZXR6V0tsR1JGN1NHOXo1STBja2I1Skp0QmNSRkZ6eU1CNU1XY2ZDNG9STmp2?= =?utf-8?B?c3QzV2Z6SVhhcHFoVU1zamhUQUNoaC9iUFFDdVZMeDh0R3JHeGVJby9YN25L?= =?utf-8?B?Q1gvSkN4Nkovc3pxUE1qZmtoY2c4bW41SHkvdGgvVU1YWEU0MjB0dTlCbUxX?= =?utf-8?B?THlaSXBKWHIyOHFmQnd1a1VFSmZUQ1RJMkVPU1pDbnI4MkpUSXl2QjhEQUFE?= =?utf-8?B?SDVIVlJ5cWsyeW9wckd2Y0h3VytnZzJVOEpxakdua1FsTVpXNUJFVVhoSXRH?= =?utf-8?B?eDRMOEYvRVZ2REtlOWVReTFIM00yRFBCaDhhVlp0VHlrQjhQM1VycDF1dWxy?= =?utf-8?B?VkZoR01WeEhmVWtnOEI0OGFtVisycE0vSGNDbkFNa3d3RjMwem4ySEk2WGRZ?= =?utf-8?B?RExjR2sxaWJmaS9oZGFqZVFPekJrWkJMM2tseTNQOWMrdjJlOVdSSTBRNkE0?= =?utf-8?B?eE9aNXpXSitjSFF3N2xZUHB2MTYraHAwNk1OUE9uYmQzc0xGcFlSaDJmVjBX?= =?utf-8?B?M1NmbXR5YldhNUFkVEYxZTdKdERCVUM3cEhqaE56ZkREVHIzb2RqYStWdkpq?= =?utf-8?B?NWJkSk5ZZ3I1ZlZVNnFyQ1JtZStuSUxCMm5EVDZLQWhDL3Fyemd0THBHTGpW?= =?utf-8?B?OGp3dmlLTkdmY0kzTGZWTkYvNEVJSHFxcVk5bGVKL3M2bVAyc0lHcmxzc2pD?= =?utf-8?B?YjVIT0pTVzZPQ2VXNmtYOVY3THppRXYzaFY0eUpoM0MraE5SWXdKK3l1L0NS?= =?utf-8?B?SEtWMmxXSEdZNE12TUJZNzlhZHdaeFcwb1BaYTV4cFBzNE1RQksvUT09?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: T71g2fS1eauGFlojle6hbefxCb/b5liSKcvMTL+eyMDmjgTfWbhsrZId4sobHxflY7LKBqBq6zX0DEYjujAvlYzrK/UzveXLASZXe37XDlR5sBwuaLBl7b+BU8AU/Dijt1quVd7HS9zNkzUh8OPsEkrromza/hnfioQeLskcsu5usZv7Th9cyFfPnL+q/EwQk3DeCp2oH/QNWOzkEn/vayV96eUYicQjn0I0TsDE3g6+LLw3sva5XqjVj3DRb1MbLwrNiOzb35mu8/if/fYLXOybcsDFWUMOkCr7scU9Bvtp725GTC8xU9H8c/yuyuWfPFidAlE4awiakVuymsuE3A== 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: 2909ba7d-fa7f-401e-a70a-08de8e2c4b9f X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Mar 2026 07:16:43.1066 (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: p+dQd8UPlwKU2KGvY8RK3kQUDwPB71g6hN1Iu7EF6uMqmpnK/XwcLwAXsd4SCoxXw+Fz+4edwi9afawxDGUoSQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS7PR01MB17455 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpZGF5LCBNYXJjaCAyNywgMjAyNiAyOjIwIFBNIE1hc2FoaWtvIFNhd2FkYSA8c2F3YWRh Lm1zaGtAZ21haWwuY29tPiB3cm90ZToNCj4gSSd2ZSBhdHRhY2hlZCB0aGUgdXBkYXRlZCBwYXRj aC4gSSBiZWxpZXZlIEkndmUgYWRkcmVzc2VkIGFsbCBjb21tZW50cyBJIGdvdA0KPiBzbyBmYXIu IEluIGFkZGl0aW9uIHRvIHRoYXQsIEkndmUgcmVmYWN0b3JlZA0KPiBpc190YWJsZV9wdWJsaXNo YWJsZV9pbl9wdWJsaWNhdGlvbigpIGFuZCBhZGRlZCBtb3JlIHJlZ3Jlc3Npb24gdGVzdHMuDQoN ClRoYW5rcyBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoLg0KDQpUaGUgbGF0ZXN0IHBhdGNoIGxvb2tz IG1vc3RseSBnb29kIHRvIG1lLiBIb3dldmVyLCBJIG5vdGljZWQgb25lIGlzc3VlOiB0aGUNCmZ1 bmN0aW9uIHJldHVybnMgdGFibGUgaW5mb3JtYXRpb24gZXZlbiBmb3IgdW5sb2dnZWQgb3IgdGVt cG9yYXJ5IHRhYmxlcy4gSQ0KdGhpbmsgd2Ugc2hvdWxkIHJldHVybiBOVUxMIGZvciB0aG9zZSBj YXNlcyBpbnN0ZWFkLg0KDQpCVFcsIEkgdGhpbmsgd2UgY291bGQgdXNlIGlzX3B1Ymxpc2hhYmxl X2NsYXNzKCkgYXMgYSByZWZlcmVuY2UgdG8gY2hlY2sgb25jZQ0Kd2hldGhlciBhbGwgdW5wdWJs aXNoYWJsZSB0YWJsZSB0eXBlcyBhcmUgcHJvcGVybHkgaWdub3JlZCBpbiB0aGlzIGZ1bmN0aW9u Lg0KDQpCZXN0IFJlZ2FyZHMsDQpIb3UgemoNCg==