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 1w77Gx-004yWb-1n for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 07:42: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 1w77Gw-001vSl-0M for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 07:42:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w77Gv-001vSd-2G for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 07:42:54 +0000 Received: from mail-japanwestazon11010047.outbound.protection.outlook.com ([52.101.228.47] helo=OS0P286CU011.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w77Gu-00000001liA-0OxT for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 07:42:53 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=swbKQRsWrbWW6um/TN5Tis9UPZdFf1gttPoCWXzy6a/pt+yNA9LWUFK/088Ih2vl3OgXSu0CdGfnjHkDfYzELPktHB0LpMCXAoVbofrgu4l1QCNlTmdJnibaYt/RuUgxruILcdJomQINvl+Sz+yV6gpl2iHLF3ZGipd8D/N7xhf3crzRxSLx6xkOgXnW14VYmN4oimsy14ILwu7UN7tI25i25PHNF07iAULbaKQDqbbk6ZSdlNp0sJphszo7MKJzdAFTSbIbW+sY1pAEGWALKJp5LwsD8q3a6zi8EtYv19M2mx7g0MfnDK+a1G+5QLcGvImKaSWPRatUwtis0zLgWg== 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=p2oXrKVG54P9J63HuUf8JkXflYH3VsVVxeOwPgJl7f4=; b=H3r3MLiqC0X6OyshA96pn+kK6AThZB/zbHDkyILsUBfH6zg2h1RrorytzmznbSjoOlyg7vwzD7DD8Jw7vLRQ5jNacVe19MIMA6X20Mal17mnqrFaJT2XIQunab0iZDbiDbt5fnYcyDvvSYfTjRdOfMRME2QBQKYNsZMZZRCKvGJdMq0DNQoF2o5fM7hBrfyU3eOl9FSuUPBjo9qISTLjuDKNXUE8I4YoJ6jjlNy8RkqYCCPVULaCSyJfwlZziUDjkDWzAM6i346ROMAuRsV4kZip6hULtQAtHOcVrl0GhkrbKx2R6hfb0rikbA55mhh12itL5NwYtSLjajxvtjmCng== 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=p2oXrKVG54P9J63HuUf8JkXflYH3VsVVxeOwPgJl7f4=; b=C3cXixiH6NZ4k7VvrXNRU2rthx+c4X8oKpp2TkEXMzCrduXxKO7qO7KyZ3EJjhBI+tu17pXzMITeILpefwdeSTfqBjfrXSKyCq35xGcJK8TNK3Csd8beXurcDfs8IeLEtN0y9ijCBk4jNzWzHTHgM63MJZ06RpOyQSDFo7qSHiTFOqq+eYQX3CdNzfq75kRgrPzDTbtrmgDq7pueheZdOqphCKNKvZnr3eAmEDXSfYd/Cz9EZU4FlApSyEMwDFGD22zEN8U61ibE9+WqUW7FmvQe47i1i3IlPZNtN4zJXEPqrzwlmbXRn/l0/15Xmv5SoNy3bhSN1pWjK+7PGj0oLg== Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com (2603:1096:604:2e5::8) by OS7PR01MB11954.jpnprd01.prod.outlook.com (2603:1096:604:23f::6) 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:42:46 +0000 Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893]) by OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893%5]) with mapi id 15.20.9745.027; Mon, 30 Mar 2026 07:42:46 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Masahiko Sawada' , Amit Kapila CC: 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: AQHcZqqSU4dRo4LUx0GK65NhMesVCLUp2xSAgDAuDwCACy6hgIAvDagAgAN0IYCABWhkgIAKM5EAgA2bGwCAAC8cAIAAOcIAgAAnEYCAABAqAIAImQ6AgACJHwCAAKosAIAB8HgAgADcAACAADfO4IAAC1wAgAApfYCABM3fIA== Date: Mon, 30 Mar 2026 07:42:46 +0000 Message-ID: References: <0c28fbd1-3320-4e9b-815c-6d62753aa063@wi3ck.info> 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?NTBfQWN0aW9uSWQ9Yzk3ZThjMWItM2E0OS00NWVjLThmNDQtODkzOTkxMjE5?= =?utf-8?B?NzFmO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZXREYXRlPTIwMjYtMDMtMzBUMDc6NDI6MDBaO01TSVBfTGFiZWxfYTcyOTVj?= =?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: OS9PR01MB12149:EE_|OS7PR01MB11954:EE_ x-ms-office365-filtering-correlation-id: ac5c0978-3ed2-475f-8537-08de8e2fef49 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|366016|376014|1580799027|38070700021|56012099003|18002099003|22082099003; x-microsoft-antispam-message-info: bvIRLRAlAw5Lf5JdKOa8flTy2qrDlZDTnsKl1qLWbGmSyO17hsSbyMMd5PPo3srgak5jSnTtcPYqz6hJaBSsvoSUQjmdfNH9Iyw02o2jhOO7PhAHKjapOc6bIFks0BLAvTSLIvbLN5ru4GGE54Dn7Xky5gbWbGoAjNdROsOKhsJFY9WFwJ+DeG4S9SqYtV5gd2piHSffoeV8EJEYZUMwVc/ceYpINclJIxAr6wUnd8cHIs/lRdvE7lr93KaEau+9AZtOIZmFBj5rCzCLt4wuNwXLuytEyLikRt+9lMiKHciyunhwblYdVhsb8tOxMLq5YnILer+G+t7ycn+g+r4iV7Qi9wst7naxz5KyCWUfhza2ZKtsiMGwnYRQyi2slWlTBYIaPC0ooaL7pGhws/95G0jPn1ZpduNVGe0OPf/F40i1pSggUzuC7Sr89LE4um3QUTrYxtZXqZG8z1BByzFyL2IUNxr3T9jUW8JmzpsVCIUaqHj3rOtX/bi9cUYpj5X9BH/2kFO1Fy/2z334JUIzI12L72xghPeYSbh9zZERcYzzqlgOW1ZN8UTQTsYuwpcA+pZhO4RD/mwrR/s8oo9uNORlfDH2QfSmYdYYOObPgCCef0I9BZHgHyA38qwFL6TKtQMW4MXAIuexrlMkb8qT80GsXpW4g7zYuDeveUg0mpLliynOfT1mS0YVcK2U0CDBKug2g/I+WS2SXFr/bkhPu+7Hg8stQfzVMOD+i6pnUwTKlx2G0ymnQ92tg7T/NUsh7PAaoMhqQuf5T0mfNrRztcCMdiiNr1M82Qc0nButGqrmeT9MgOKSgDquT/AptNPw x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS9PR01MB12149.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(1580799027)(38070700021)(56012099003)(18002099003)(22082099003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?ZVFGOVB2SHBRWnFLcTVpeTdRWkRCL3lGTnBIV3V0cktUd1p3SXFoY2QrQzBL?= =?utf-8?B?SHVjcFRPUEJMUHhRSURFd0Q3bVNsSkNFdzNTeUswSEdPRDBwOFBnRStoU04r?= =?utf-8?B?Q1gzVTg4WHpjU2R5WFpHdE92MzFvbjRoVm51SXo1Nml6OERpZFdLT2RGRVcw?= =?utf-8?B?b29OdVJkWEFFVmFvR0ZSdmJYcVh6WnlGWE9kUENXME9mUk5ZLzFEWlpKWVYr?= =?utf-8?B?WnA1bGI3WHY5dmZReTZUMnR6VTBZTDQrcHdNbXV2ZWNNOUs2dGtqK25JMVhQ?= =?utf-8?B?VHB2UEI1Rkx0ZVJVN1RVM2tsUzRVakV5Zkh1N1NJR3ZJQk5vaU1wMFpGWlpC?= =?utf-8?B?b1B4ZUJmL05yS3JmbG95Uk9tWHFoeGVnd0NNUC9OWkc4WWRpR0NabktZTEpP?= =?utf-8?B?SGFoOGdSMHZOVSs3ckxuNGs4MFc3eEtCRUJ3WUk1eE1pclY1eVNkZDZXWGtN?= =?utf-8?B?dUExS21LRk9tWmc5M1dZcUFsZmRlQTBEbTZYT1l3K01FQTJxdmNNRlg1WG9F?= =?utf-8?B?YlAxL3o0QlRtbmdsNElTR2pSa3Bvd0NKRWtlMW1VQnM1UHZPRDAzVlZScUdL?= =?utf-8?B?cG4wYXIxNGRPVmJDYmxkWlFVNmNwcklqeG9EbkNEem4wSmpZQjQrUDF6QlNv?= =?utf-8?B?TUJPOEwrYk41b1BScURyRFlBK2Z2NUp1WFM4WG1yb3o0NWR4Tk0wZFJ6RGph?= =?utf-8?B?RGVWMWJMVko2VWMyd0ZYL01WRFpKbGhrQk5DczB6Y2QwVFBJd0MyRG5LUjBN?= =?utf-8?B?a01mK1dYMXNZd0pmdzhsTmV5NXlQUDdoWmdIRHRKQVY4RExENEV3Wmo5cmJC?= =?utf-8?B?cTQ4dVJraUp6cVphc3hxYS8zUUJpTE0yamtrK0pCUE1kREdwTWtlb0xoam1M?= =?utf-8?B?Tk1laWo3Vk5mUDFTVm4yZ3FoOGE2Tzl6Ty9RVHU1WUJsVE9jNVlOYWRMM1ZD?= =?utf-8?B?eEVwYm5KM2NzQllhNmMwV3B4bHJDVDBuaEFWa3FWenVlRFdLbVhwV3J4NXAr?= =?utf-8?B?YVM5VVoyM2ZlTUNjd3cwQXVMVGhTeVl5V1pHdTNBRnRJbDFKbnBqbG51OUZq?= =?utf-8?B?Y3BPR1NQMWxDbTRxTEtpMEZ5K0xPTDgvOE5xWk55cURRZDhLSExFS0pDZWpZ?= =?utf-8?B?VFBUalF5c01DSEpIdlp0alJFcUJYTzA1Z0dzdFhxb0h2MWNWY3A5dVhiS2Jn?= =?utf-8?B?ZzBidUZaWFk0ZVY1c0dzSlBWdG5RVFA4S0Y4L25uaGJiMUlqYyttMFdUR3k3?= =?utf-8?B?dGZOMFNrUVIxN1NYRG54ZUppaENtYmF1OFVlWXRlM3RMWjRZVjZvNjEwVVdE?= =?utf-8?B?K2puRHNlT2RnRWxTeDFjMnVnbUcxN2YvUnNBZDlseExPY09OZmM1b1c1L0JQ?= =?utf-8?B?aUU5UG9ERXFoM1JMQ2VCMCtSLzdJYXhpc0gwT1ZrZXFIaEpJV0Z1dEtXREJF?= =?utf-8?B?a2drNWpGeDlKZlplMlpDblp2KzNmZHgzVWovSWV3TkMrRys2bGRPcVd5d2JV?= =?utf-8?B?WkFmQ2tKWEUrSy8zdERwRXRrVlVMbDFRRW1JVUVDc1htK0VvcFdOTHBrN2t6?= =?utf-8?B?bGp0UTR2M0V0aVg4QWZja0N3UTFxVmlxR0lvNkNmQ2hHMzVnT2J5SFpvZUtu?= =?utf-8?B?dGVsRGxZWG1zTUZOQkErakVZY3FZMitkSHF1WFZjYTdlVmtkUHYrdURyeVIy?= =?utf-8?B?R054anZLeVFHUWIwK0tKMUVySjFiOC90MDZ2RGZyS0ZBU2lPdyt5c1hQMVdt?= =?utf-8?B?NEU4WVhzcmNnMUhHZHhBczhNa2FKTFJSK0tTMHU5cFNkc1oyR0tPa01xV1NJ?= =?utf-8?B?OXNLK0l4RVJBa3hKRExzSGZOaUpsWTl0RUlydkFNVk9Hckg0WXdPd3UxUTRN?= =?utf-8?B?NDM0Q3l3dDVzY0sxV20wM3hpK1h6YkFldElWU0ZPS1hWRFgxWDZlL01PUlEz?= =?utf-8?B?NnVMdmtRWnFZYi9iZDR5U1hlczNkOTBDaFFMTmVXbHV2MDVKTlhDUmZ6SC9u?= =?utf-8?B?QnVrWkE5eGExZE1nMEVBMUNncnlYZmhCWDJGNlgxa3dmQzBqd3JxM3MyWmJF?= =?utf-8?B?SlpZWnpseE9XT1VVTW1aa3YyT1A4MG5peHdkVmJiOHVFZlN6bHU4cG9IRGZh?= =?utf-8?B?T1c4UzJTWEZLV2FPZkp5VThXejhQTVNkeXVrSkIzbkRJMnVRSC9LcmdHYklJ?= =?utf-8?B?MWV3dkdZYjZFcnpUSzVHb3ZEdzdIc3l6dkxVelpwZ3FzQmtoQy9uUUVsZ0g1?= =?utf-8?B?VXg3dEhhVFc0anNnN0FkMTduYmdqT2ZkaU9VdkJ4K1VrbVRITHVXWHdHS2F0?= =?utf-8?B?MWwxWG0rdXU1TkpFZmEyTGk4UjFGMms0RXZGTmVNNy91Ty9HMWlXZGt2Ryt5?= =?utf-8?Q?m+oDgsPTvHfhIH2Y=3D?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: bsIoLMAdX+i/Yra7c/gZxDC2uJ1AxQyuToi5xCPDgcbkz+L9r6fbPv/lMssIgSoPYFGrNunFolYoeX01cdajr/NXlPUbtyvrwH0H7oA0sMwcFu0bqQgppyFU0qgax1FoB3uxJfwMHUxriZn/M1eRN+TvhRnk+z3qHGGd0q/0Qxb6INEdfsyJefyGBsdMrcRuKSSYmKsgD+4zd7RlY8jcn0ROa07LkC+FDsH0rYVJKj9m8VPeYF9dPHgRN5Iigt8My0egtHDceu8W2IllQIxnM2dumRQS0a4V8kJGR8aU26vqHe3wbwOS0qeACwqs6GUuAs5mBNkm3kleqdR72RZvBQ== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS9PR01MB12149.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: ac5c0978-3ed2-475f-8537-08de8e2fef49 X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Mar 2026 07:42:46.2245 (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: zd69hM6ilp1Bzj999CpfPhr3z6GgQ9ENoXqlMhYpeeZvG3GoxVnohDK4ME/VRY9QLZ7RYdJLR6PKi0GEqVW/YxvnabUXDi10JLSgM+6oL+o= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS7PR01MB11954 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBTYXdhZGEtc2FuLA0KDQpUaGFua3MgZm9yIHVwZGF0aW5nIHRoZSBwYXRjaC4gSSB0aGlu ayB0aGUgcGF0Y2ggaGFzIGEgZ29vZCBzaGFwZS4NCkJlbG93IGNvbnRhaW5zIG1pbm9yIGNvbW1l bnRzLg0KDQoNCmBgYA0KKyAgICAgICAgICAgICAgIGlmIChmaWx0ZXJfYnlfcmVsaWQpDQorICAg ICAgICAgICAgICAgICAgICAgICByZWxraW5kID0gZ2V0X3JlbF9yZWxraW5kKHRhcmdldF9yZWxp ZCk7DQpgYGANCg0KQ2FuIHdlIHJldHVybiBoZXJlIGlmIHRoZSByZWxraW5kIGlzIG5vdCBSRUxL SU5EX1JFTEFUSU9OIG5vciBSRUxLSU5EX1BBUlRJVElPTkVEX1RBQkxFPw0KS2V5IGFzc3VtcHRp b24gaGVyZSBpcyB0aGF0IHBnX2dldF9wdWJsaWNhdGlvbl90YWJsZXNfYigpIHJldHVybnMgYXQg bW9zdCBvbmUNCnR1cGxlLCB0aHVzIHRoaXMgaXMgd291bGQgYmUgY2FsbGVkIG9ubHkgb25jZS4N Cg0KYGBgDQorICAgICAgIC8qDQorICAgICAgICAqIE5vbi1hbGx0YWJsZXMNCisgICAgICAgICov DQorICAgICAgIGlmIChyZWxpc3BhcnRpdGlvbikNCmBgYA0KDQplbHNlLWlmIG1pZ2h0IGJlIHVz YWxiZSB0byBjbGFyaWZ5IHdlJ3JlIGluIHRoZSBub24tYWxsdGFibGVzIGNhc2UuDQoNCmBgYA0K KyAgICAgICAgICAgICAgIEFzc2VydChwdWJuYW1lcyAhPSBOVUxMKTsNCmBgYA0KDQpQZXJzb25h bGx5IEkgcHJlZmVyIHRvIGRvIEFzc2VydCgpIGJlZm9yZSB0aGUgU1JGX0ZJUlNUQ0FMTF9JTklU KCkuIEJlY2F1c2UgaXQncw0Kb25seSByZWxhdGVkIHdpdGggYXJndW1lbnQgYW5kIG5vdCByZWxh dGVkIHdpdGggb3RoZXIgZnVuY3Rpb24gY2FsbHMuDQoNCmBgYA0KKyAgcHJvbmFtZSA9PiAncGdf Z2V0X3B1YmxpY2F0aW9uX3RhYmxlcycsIHByb3Jvd3MgPT4gJzEwJywNCmBgYA0KDQpDYW4gcHJv cm93cyBiZSAxPyBCZWNhdXNlIG9ubHkgYSByb3cgd291bGQgYmUgcmV0dXJuZWQgaGVyZS4NCg0K QmVzdCByZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBMSU1JVEVEDQoNCg==