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.94.2) (envelope-from ) id 1rogRx-002m7a-NH for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Mar 2024 09:17:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rogRv-001TtT-Sf for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Mar 2024 09:17:00 +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.94.2) (envelope-from ) id 1rogRv-001TtK-Gd for pgsql-hackers@lists.postgresql.org; Mon, 25 Mar 2024 09:17:00 +0000 Received: from esa8.fujitsucc.c3s2.iphmx.com ([68.232.159.88]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rogRo-006N3J-D6 for pgsql-hackers@lists.postgresql.org; Mon, 25 Mar 2024 09:16:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1711358213; x=1742894213; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=RiTq3CeU/u6hQ/JL4reg26vFtx7fq54J6w0uCkJfUyg=; b=wEpkYkKYpxg00iU2Ofc0EefqJg7vCIwob7pLOekLTpkDE4y7P4gny0cg d8xD1VLprBOrDz4UdaLUg+6ILUfrO5ZhCQxDWieuF0VYqq1ty8NZIUXqL TnNa+k6Mq+uyHbQWy38ltb6uiSSSwjg5HWit0VJ58YAoY1+IvdNfInR8v hks9W82RS0ZbCWo/KBou+AN14w4AGF+ksG9Obbm+DrXEUynt1Fus7DrlC CNLi8y4tgcT0etWV6jyolX/4tiCT3Ps5jtYDywBZkA+aL0qCuOWWx1y1o QG3cSt2V6tk0IpTKYhr2ZRgwIMwpdQtkxhqiRLoQqZgneHNFrjg1bVnHf Q==; X-IronPort-AV: E=McAfee;i="6600,9927,11023"; a="114948181" X-IronPort-AV: E=Sophos;i="6.07,152,1708354800"; d="scan'208";a="114948181" Received: from mail-os0jpn01lp2105.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.105]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 25 Mar 2024 18:16:50 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=RjriUf814a4GNu13IyySWvgX2Qcg+y0+kByXryQFZ1jPsoGS/Ag7unOVoTVAQo9O5uN3VBE4SJ/j/hbcUM7/mGs9BLGX0B5a1PZzW0WYBVxoXTZSXvSIIvM9FjM4oyhSfE8Tq/by5+LAluWvlY3dP657+4enncCMoEtR49nDWRVYbtu4P5cuXWsVco14ejivZgDM5oFNUkx9sd/MOhr+tNvmUpIlHlgXxzDGLC7vante9Jx5+9jfbfrGumjfhWqfAYU5bk7UqwfbuWjYjuYRmJUGOFRa7vcr7bqCgVrPVRCCvShTX+8VTgcxr6ne35R+yZFGDRAoNDpPqyqGIxs3HA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=RiTq3CeU/u6hQ/JL4reg26vFtx7fq54J6w0uCkJfUyg=; b=MU93F0IeXj6RtylpjtjRsbmmQk2YM6NXoLWamNGQMUvInNW996wM1CfYpIBHgoOkks4/RWW4VzugFahwnp93lPKlX+OMYgFBNoG7KZr8yLSBvm+hDfr7OGavrcjI5Gc13132ciWj9djY/Q68VOvJN1m0rYPRZsvhN7ZMD0Y8OFhqOg2I95Q8CfKWKQIrBvY86VBM4rHyHBnG4Vj0AhuJOWqLuHrKXv2d4zRCe7NpPqktgBI8TDyBvFNEfve77cVoRqmCqAJ/F73RqnuqQWx54O9EdiLbgriHwFeWotdwz84mMWmhGnj93qC3sl0e5w6YsTAKQPWuVUSHxiYMQiLmqQ== 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 Received: from TYCPR01MB12077.jpnprd01.prod.outlook.com (2603:1096:400:439::5) by OS3PR01MB5734.jpnprd01.prod.outlook.com (2603:1096:604:c1::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7409.24; Mon, 25 Mar 2024 09:16:42 +0000 Received: from TYCPR01MB12077.jpnprd01.prod.outlook.com ([fe80::ef6e:8410:5112:8cd8]) by TYCPR01MB12077.jpnprd01.prod.outlook.com ([fe80::ef6e:8410:5112:8cd8%5]) with mapi id 15.20.7409.028; Mon, 25 Mar 2024 09:16:42 +0000 From: "Hayato Kuroda (Fujitsu)" To: "pgsql-hackers@lists.postgresql.org" CC: vignesh C , Peter Eisentraut , Shlok Kyal , Tomas Vondra , Michael Paquier , Andres Freund , Ashutosh Bapat , =?utf-8?B?RmFicsOtemlvIGRlIFJveWVzIE1lbGxv?= , "Hayato Kuroda (Fujitsu)" , 'Amit Kapila' , Euler Taveira Subject: RE: speed up a logical replica setup Thread-Topic: speed up a logical replica setup Thread-Index: AQHYJxwqCwVDEK8rxk6UuFJmWEa5OLBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgACrngCAAM0jQIAPei1wgAAshICAAp5LgIADBLQAgACKXLCABEd0gIABoIwAgAB7ucCAAcm90IAAHJgAgAACwICAAAXhgIAAC7MAgAAh+gCAAIfpEIAAGb3AgACYWmCAAOVegIAAfuxAgAeMDoCAAAXdAIABBpmAgABeF2CACXUbgIAATP9AgAHL3uCAARDPAIAAoFUwgAQywWCAAeMXAIADek5ggAz2jwCABVnHcIADBCkAgADUOwCAANs88IAH2USAgAB1EYCAAojjAIAALVOAgAIrrICAAwXTAIAEFtAAgAB5xgCAABAbgIAAEQAAgAAP0ICAAOCoAIAE0BJggAA/9cA= Date: Mon, 25 Mar 2024 09:16:42 +0000 Message-ID: References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com> <40595e73-c7e1-463a-b8be-49792e870007@app.fastmail.com> <6423dfeb-a729-45d3-b71e-7bf1b3adb0c9@enterprisedb.com> <2f0b73f3-e7c0-4e95-9712-1993442a6b64@app.fastmail.com> <34637e7f-0330-420d-8f45-1d022962d2fe@app.fastmail.com> <7a970912-0b77-4942-84f7-2c9ca0bc05a5@eisentraut.org> <60b45b8a-3047-4a21-ba2a-ddb15daa638f@eisentraut.org> <07a0f7d7-8ec9-4649-8bcb-610fd430eebd@app.fastmail.com> 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?NTBfQWN0aW9uSWQ9YjdlNTA5N2QtYjllMS00OGNkLWFmMmYtNDU4ODA3Y2Zh?= =?utf-8?B?NmYyO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZXREYXRlPTIwMjQtMDMtMjVUMDU6MjM6NTVaO01TSVBfTGFiZWxfYTcyOTVj?= =?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: TYCPR01MB12077:EE_|OS3PR01MB5734:EE_ x-ms-office365-filtering-correlation-id: bb1c046d-4029-42f7-13f4-08dc4cac4958 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: TJhDAmKu5Prh6NcVGn4FGbUgLJCB4jzr5FAiRsCMBwTibx9b+r+P6+HHm0mtLvfUOx0Z5AOoqql++adHU0ULVpMrr+9xrpvYGECqn7K9xUNX/rwSZTs33wVz1uD59LSpIX0vqj7B+hN//VTjVK1YC9yGdnCG9iM8wsFcJbF+6KRZQN2rgVpYDJX70bluGMuabN+DPvxCIA3LY8sRxPJpXTgSYAwYncXgAVpVBEeQUJH2cwjwCdaHRwXrMgVbR+RqBBNfE0NyxP5WG72YmcaZ+OXIq/W+Ee6JRxoQZSrO9WptjMiPyaIKrYbxA5fOcjHrRTG4EOAUp3ts0WwJZTI7x+bJ3YEVK+JjfCvH/Eoe/8w0kDN93b+KQZsdP0oENhEwzcajitBORyGwaFliI0gzYkHsWr53LneC0MKcgMk5IR6gQzNbLUoqa4CnrYDYPYxst75fhkUiHTNgxf9vqJZR3sWPELJ2V17LbNXvVkGuXgFQ1y7FKRDf0qNGz2lyJA5/U0a7g/8DMKjhfkZHwe3f4ahdjlcZ6U7J7KQZ8hfjzbbHbYlpVIpb0QdQYfFKCaxm+wJbOdq7zENrxIl6h24x8oyBj9k5/1SMZ0xZFwITEUXh3g+nO/fchWzZyQvXtzU+iV8D+1OqaWPYNzX45WuPXx8fh8QjflQNG19X9ZQCGe5EmNqIdYxgVdC1X660AUy5 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)(366007)(376005)(1800799015)(7416005)(1580799018)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?YW5aMDJNNDRmQmowR2hrbGRJRkN0aUFOd0VhWS83TGZtdFFaUWVqbWdDYkRr?= =?utf-8?B?L1J0eUovZTRrd21Ocnd4N3dHck9DNkxQZUtmRUtwSWxkdFNBeVdUVjhsOTRD?= =?utf-8?B?UC9CWlJNUXpXdFEzMjRkQTlqcUVKcERrTkNJbjY2ZlNVSmpZN1J1dDdIaVIv?= =?utf-8?B?MWN0S2tpT3VUQmJqeStGSmY0a2J6ZWdvdkxJNG9BaWxFQUQyQ0VkMVZTQ0JR?= =?utf-8?B?SmJTNFpsZWVrcWhFNG56RnRIcWtiSGM0aklTSzFpUmtOUmcyeDNranUrNDRS?= =?utf-8?B?NUJtcDRTNU12bXEwYlZSY1A4S21WcmJXRURBaUxlRVJTSXlNa1JnSWlBMmNT?= =?utf-8?B?Q0xNV0RHTW9TRGFBN0NpUlBzVDZHbHFOSHBCOFRBeEI5bE8xUnovM3hkdi93?= =?utf-8?B?bXM4TGFiK2pYTmVXN1hFWmQ0c2JLSlNmMnYvd2V2dkk1U3NrT29uV0kxeGs3?= =?utf-8?B?SlhOcUNrK0RYeFBjcjdrVFpUbkdjT2M2Q0d6OUptcmNtVzBYMVNZdWRpKzhH?= =?utf-8?B?MnB1VmNxYzF4QVhOeEYxTXFNK2NiZFA5RnI0c2VaM05kVW0xVXRCbmI1M2t2?= =?utf-8?B?VkZ5VGsxb3pBUkM0UWhudDE3ZnpkRW9kWGM2d1RNbTNsZStQSENhamJldklD?= =?utf-8?B?R3JuRjNPcEkrakRLaFEzeU9vclByNGkrM1RYNzQ5RVUxL3NoWUJSclVZQkRS?= =?utf-8?B?N0c2MERQL2VBSTkxS0FkL0VkTXRkZU5HdVFlaHM2d0hBZUxMVW4renAzbmRo?= =?utf-8?B?YnkyL3JXRzJHS0lZcEVhd2kzOExndmpRY2F1Z2ZYWjQzbUJpenEzK0lZdXN1?= =?utf-8?B?MjUxcWpwWjRUcEk3bVRpZUdyN2FmRVErbGpxdnV4cWdhbVNHcXRGZzR3N1hZ?= =?utf-8?B?cndGQ29sUFJWTTFjcFBBZnBCakg5UWQ2SFFpaG56MWRCVGVwcDFFeHFCb3VL?= =?utf-8?B?UThYRGZqNFdhZTY5ODY0dW9rTFJOUUpFWWxPZHRpbGtTMmdkTDV2UitxV2Y2?= =?utf-8?B?VEl0elVnc3IzTTAvZ0N5ZVUrMnFHeEhrMTQwMHpob2t1b2lmbGVjdkdLYnRy?= =?utf-8?B?Z3Mxam5hU0IwTm5KR011YWxmcGRTUThVRXNCaFVNcUZVWVVkUnhoczgwSFB2?= =?utf-8?B?U1JURTI0bWRZM1AwS05mdWpWbVRBenA5cFc4VW96eHhYTDFSQXgva05ib1pr?= =?utf-8?B?ZExwSWh5LzgzK1VjeHB6eFVEK25LWDFtcFhDSGNpWE40Uk54MS9vN3pxWnBM?= =?utf-8?B?WCtaTHhKeVV3WGhMOTkxM3ZDR2pkbFA4RDE1VHdHUDR1WkVZU1ZQLy9WNlNK?= =?utf-8?B?Y0xRQnBueUwrbytSUHhmWTBFYWV2QktTYkVTUys5ZVdESXNHS3ZoV0hrQVIx?= =?utf-8?B?UlozYW0rOFdWN0drTm9DQWV0dUpSVFVzaFIrODkvRFl1OHJNK0lQdU4wTWs0?= =?utf-8?B?bG53K0hoRWFOY01RRk51bUhpVzY3K3FHOEJLVmltaURnU1NWeVc4MnlDdmVl?= =?utf-8?B?UjlnZ2JVOE1sa3NBbUw2M2dDQ0FPTTFjbDVBOTBqdDhuRlhaRUtFb2doMFd5?= =?utf-8?B?TXhjUWFnYTVaSk5NZkNZSldNb3BuQWFMYVlaTUQwdHYrMUFlZVp5SldKR1BU?= =?utf-8?B?NnFOLzd4ZW9yMG1DREtPdHpGL3JUZS9zV2svSk5MU0tHQ2llOThUc1RDQkg2?= =?utf-8?B?SHNPUkNFeWw1Y2RMbHUvbGZZVXltUElPejhwaWpPbDcwcWN1SXJ0MUpHRUxC?= =?utf-8?B?QzRieDVEZUpJM2dQcHlxSG54OFNnbVh6YXpmRklHOEE1TEdKVE5EUXFJa0xB?= =?utf-8?B?UkJkNDRvNTQ5VHNLY2x1SzZSUlBmbXIzRnQ2d3MxSWduMVZUSFphRHpDUjBB?= =?utf-8?B?WUVIZGJNdXQveWJ6YmNwbmFPaHhlQ08xUElGemREVzYzaXVnbWE3OWJPU1Q3?= =?utf-8?B?bXIvMkpjWmpQVDlicTVXSEdqT2IrVUUvNGtrMXlxdUoyVUZ1UW1WbkxkbEto?= =?utf-8?B?a08zN0VhcGtCaGNiSDdpWXVRRlpzOGZVQ1VwclRDOHRBOWhYL0VYTjZCaGFO?= =?utf-8?B?OXhiZW1ob2tNTG91Z3F1Mmp4NUh0WWIxNGtuaWkrYmczd1MvZElIQjNNelBF?= =?utf-8?B?MnB3S3ZVNUh1RG5hMXdETStiOTlwZElON2lCcnNjV3JFNEtLYjF0azcvV2tL?= =?utf-8?B?QXc9PQ==?= 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: Gpz18qb2WiHXrQuCGSoIi3Bike2sp7mrKWUMhtL/Fkbs21EgnPDB11fQqc2Nlt4OY2wk3ObaSt3msC04T2D69OJFcwo/6r5DDK2J6aCK9DWeGWWMt4/aBFm36weTXt3vmYer1b7Ob35P7zqvxybzPReCBQg2GEw1vUuLmynZtKa5sWqPIhBNu9Cn48Yclkrn84j2YIMCxD2SgoexYl2EK3dZykTwjFI23XlSBSfy5tk9JObsTqv63b57qYHZ9Nf7epPNjuMvuopfZjrZZcLV1d/TrCv97U6BEIK9f7fi93/5hnhJvlSlV/+5hwDnRpTSVHHtx1hGlQqfKSoet2FleGqdv7CGLKkqXMpBZfIthjrKIJblSvPrzdsz/S69B7kKwmClvLPrKrIFgC9nW6Wf4I2QmT0PYzyHM5Bet356YI3PAg4jmug/opjuaHO8wXX/ggmk1ZC5uVykqOj9VJR1wgoAr5zFPxjmgalPv32qNgkdcDf1MvsGWfQGDGEnGCZlXR+ttqNrnZnz8lgBBB15FQZoI2aphMKTVZxoxutth5YvKLwCIy93zdxCDFPLZVnhq/yPcCYtvTy0/CgblZ7uks5ZQrC406pnmZXBIbOSm5ACoykcsye8PQc5YtaiUvSR 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: bb1c046d-4029-42f7-13f4-08dc4cac4958 X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Mar 2024 09:16:42.8238 (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: dzj2ieysqc9Y05XqzmxF33HkKNgc+ozaaV1ebE48v2VPE5KvFKGWPLu4aAWP8UPvWsKa/J0ANf2tTHly3PiMljQOQVffuvMCGQIX1930j0E= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3PR01MB5734 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBJSVVDLCBhZGRlZCBvcHRpb25zIHdlcmUgaW5zcGlyZWQgYnkgVG9tYXMuIEFuZCBoZSBzYWlk IHRoZSBsaW1pdGF0aW9uDQo+IChwdWIvc3ViL3Nsb3QNCj4gbmFtZSBjYW5ub3QgYmUgc3BlY2lm aWVkKSB3YXMgYWNjZXB0YWJsZSBmb3IgdGhlIGZpcnN0IHZlcnNpb24uIEkgYWdyZWUgd2l0aCBo aW0uDQo+IChUbyBiZSBob25lc3QsIEkgZmVlbCB0aGF0IG9wdGlvbnMgc2hvdWxkIGJlIGZld2Vy IGZvciB0aGUgZmlyc3QgcmVsZWFzZSkNCg0KSnVzdCB0byBjb25maXJtIC0gSSBkb24ndCB0aGlu ayBpdCBpcyBub3QgY29tcGxldGVseSBuZWVkZWQuIElmIHdlIGNhbiBhZ3JlZSBhIHNwZWNpZmlj YXRpb24NCmluIHNvbWV0aW1lLCBpdCdzIE9LIGZvciBtZSB0byBhZGQgdGhlbS4gSWYgeW91IGFz ayBtZSwgSSBzdGlsbCBwcmVmZXIgVG9tYXMncyBhcHByb2FjaC4NCg0KQmVzdCBSZWdhcmRzLA0K SGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBMSU1JVEVEDQpodHRwczovL3d3dy5mdWppdHN1LmNvbS8g DQoNCg==