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 1rO9n7-001vzJ-JG for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 05:09:14 +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 1rO9n6-00HY0n-Oh for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 05:09:12 +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.94.2) (envelope-from ) id 1rO9n6-00HY0f-9L for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 05:09:12 +0000 Received: from esa15.fujitsucc.c3s2.iphmx.com ([68.232.156.107]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rO9n3-0017oY-CD for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 05:09:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1705036150; x=1736572150; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=lgN1RTFJWviucBU3Uyw/Nhoyxiqh+QkvnTT6n6or72U=; b=zXoCe5UdfKzO9l/AuKkXmC4rhbr4fgx1pTA3XEWc4c4R0kE/MrfjnddF cEojzu+GgfeEpAsKCc+N8KHZXAqIaCt/SNGznJFDCnNs/8OhmrFKTafOE dBQXeuBypMuCSlocmvPguHFXVb9paT9aBjMWw/MYA6u/0V6uopQtJrwso 5U/qpl0gd+iAkEVastOkNusOoNIgaY8SWYm70VAeUN7HInsh1Q11toSe6 ESKmEMx49ZXyXh4bR0QTVeC7ZY8xt9lLECK1iv0K3UsxyJ5Zx65HcA+Wp KkxpGeAWpKaPm6LajmdM4zDN4EWrqSKQQXok2xemNx/ocCcFznVDI0AkC Q==; X-IronPort-AV: E=McAfee;i="6600,9927,10950"; a="108172193" X-IronPort-AV: E=Sophos;i="6.04,188,1695654000"; d="scan'208";a="108172193" Received: from mail-tycjpn01lp2168.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.168]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 12 Jan 2024 14:09:04 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=MDP+bvaowIj26jbDH+htYTBRPV/zRNNcYRsO7up8fl0GL5oQc3LWfWqwZEMXbQgsif89PqsKcqEHRXkVo0wrq9XUnEac5VSmbw8/GQrdahlF1VLD16Ps9c6wto4Ky8XtCrd8uG9hTO475tHgpkknRNIRc0Xi2KRen/sm/7fSx00kqvn7LigVzD7OqJBOitKpZI5QJ1zh9QEhZPJgdpa5Nw7Kpmanv3G8Q7twfBvjbfbbQL485fJkYwwkSwfhl3iyds/weX987SaYg7MBzcZDRoPs7CS/TWRaived4mItfxmGdDcNH3y2X8HD4z4YEwNZ952PX+0TInhggkrlfSuLwA== 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=lgN1RTFJWviucBU3Uyw/Nhoyxiqh+QkvnTT6n6or72U=; b=Bi4bL5/3Vb4yg6b8KL6Tx9Xz1dswS2kkrG20KOK1ocQgVMeIuak/mcwBptzuRo+ec5vZj+00dTIRK432bNwY0WoSbbz7I7fDR6J9s7bjo3Wx62c5/1LAf3/gMctLxDPRdm1qOd0Pwit7Y/3+1UPf5eUkdurPuIy6G518bU1t8lmKJvjhTb4supqpngV86aYbq7RPILgpFum3FfTwXYDZmDWj1IHu1MzQ1PLB0Wzl7KgtOIOnCtNIqCvmQQ4PVC270ZQffog0cOiDgVxDeApkw5hNn8NybKGs+TgoPD42nS+tOwYahhUMWxavK90GUARi/PEabojW3O18wq+dqasmqg== 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 TY3PR01MB9889.jpnprd01.prod.outlook.com (2603:1096:400:22b::13) by OSZPR01MB9583.jpnprd01.prod.outlook.com (2603:1096:604:1d7::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7202.14; Fri, 12 Jan 2024 05:08:58 +0000 Received: from TY3PR01MB9889.jpnprd01.prod.outlook.com ([fe80::cd87:60f9:f281:5d81]) by TY3PR01MB9889.jpnprd01.prod.outlook.com ([fe80::cd87:60f9:f281:5d81%5]) with mapi id 15.20.7202.014; Fri, 12 Jan 2024 05:08:58 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Amit Kapila' , Euler Taveira CC: "pgsql-hackers@lists.postgresql.org" , Shlok Kyal , vignesh C , Michael Paquier , Peter Eisentraut , Andres Freund , Ashutosh Bapat Subject: RE: speed up a logical replica setup Thread-Topic: speed up a logical replica setup Thread-Index: AQHYJxwqCwVDEK8rxk6UuFJmWEa5OLBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgAC4LACAAE0BAIAAGW3w Date: Fri, 12 Jan 2024 05:08:57 +0000 Message-ID: References: <5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com> <4710d895-689a-4ae6-b8e3-344286dbf970@app.fastmail.com> <96e3b739-d63d-4d35-90a3-7869465b7167@eisentraut.org> <2736443c-58e3-42df-8cc4-8c66106e3da5@app.fastmail.com> <7b6e75fc-324e-4734-b4ed-232fc6359e70@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?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?= =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjQtMDEtMTJUMDU6MDg6?= =?utf-8?B?NTVaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD1jNWUxZjU5My0wNDYyLTQxMzIt?= =?utf-8?B?OWEwOC1mMDgzMTA1ZjJiM2I7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?utf-8?B?MmFjLWFiNGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA=?= 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: TY3PR01MB9889:EE_|OSZPR01MB9583:EE_ x-ms-office365-filtering-correlation-id: 49c4b122-b860-4ba5-fad5-08dc132c948f x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 4w9oLV7i6mzFxJcOn+cIt0XW9QXZfs+SvL1mWxxW/t/GDeXq3LN6i97HxGjrpO/Z7ytoGfHGbmk5f17vmKxVHMRPTJK1B/AKFs3XNA0lpxQhJXKXIINQJKJNaU5o9zy2xeDFGx0UQo1vfP4I52ShaqvqN+XR1D0gvFMF/K0fyjDHr0RvXTATchysEov8AkRvvQloBb035XosdtCl68v6qtJOqe7c8lqJCyEea0wnxQ4udZOlWGMNVPheFgJZqLs95EyRnQJV4mVy8i8hAbGdC3FN7uI8wSNy0oQ+9tJRfdzBuvMTAy3EchrYxYa64qRibPZJ4viBBazCyeMtquwEAe/X1wRtn8ns191vl84lcRiIXHWBxBfwFBcF+Q9JQLx3zaRnvZqju6MqVcyGYRlQolhCk+zLqQsoOEdUPb4iix55zkyEQD9N8AUA+oCklPf72DVmckLN1K8VIazAiWY7LqiTD7jaFDkRckMovee6f8+af2m1qtwNTR8jcK5MFmL0HryHmupp03ZEQB85rmAD1nAG6x+40w4yviEfjkmfLqEcYYfjNt+FNzJi3VjkVVj3M1MWqlvi29P+ehByLH1jkQr2SOISGaSSR0RyqgsssEVDSZ+yf4FUP66v4gzxAMLm6xqLGgQflLNdMZqn0+Oepg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY3PR01MB9889.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(396003)(346002)(136003)(39860400002)(366004)(376002)(230922051799003)(1800799012)(64100799003)(1590799021)(451199024)(186009)(38070700009)(55016003)(26005)(7696005)(9686003)(71200400001)(5660300002)(64756008)(52536014)(66556008)(8936002)(66946007)(316002)(6506007)(110136005)(54906003)(8676002)(66476007)(66446008)(76116006)(83380400001)(2906002)(4744005)(1580799018)(122000001)(38100700002)(4326008)(478600001)(41300700001)(86362001)(85182001)(33656002)(82960400001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?M3h0azVPTUY1ak8xTTMrZHhia1hwWmFLb1RKaUpqOHZiS0tWMXVYYTJlOUhs?= =?utf-8?B?ZFJjR0Y4WVRZdExHdzBKU1hnbE0xdmxFekJ5eDllcDVtNzA1QjJDb2JLcE16?= =?utf-8?B?cEY5R29MZHdiMktRNnV4QWZqdUVkUHR1cm9lb1NmVjRVdElzbGR5eHR1WnZR?= =?utf-8?B?Z21kNnlvM0hURWJORnlhSjZ6aHNnc0dybkR4bUNTVldIbWU2L0UzUFdYbnBN?= =?utf-8?B?K3Y2WEFVQXVUTzhjUzgyOVNBRU1hSFZjYi93cVN4RmRiN2ZjWEg0d1c2T0pG?= =?utf-8?B?SHJaMFdOK3VodGU2cWI3N3QzelVsbE9UNlV2V3lxMUJQRlFNZUJKVmlXSXVR?= =?utf-8?B?Q1pSVDdTaVZHZ2tzWWpkdHVjSFNKRmZGZVV4a0NpU3dtQ0dxSmxPaWxUVFJx?= =?utf-8?B?TGRqUzRmYmlaYzliYnNvMXRjbjd5QVloNFlzVVU2UUV1NEtGUVUvaU9TdTRG?= =?utf-8?B?b2NuNEhEdnJCYnNURlFmZUhpMnRZeHJaSjArYzlLTDJTT056TFQ1OTZoQWV0?= =?utf-8?B?Q1FrYVpMcThlcHg0S1lhOEVjYzdEeGN4T1FZWlJ6bXY4Q1l0THZWREZXY2Yw?= =?utf-8?B?cTJyV080RUtRVHlORFJrYlFiZ1E2cGQ0NzVoRmhGemJaNWZDWno1a3BubFJ2?= =?utf-8?B?K0NqWHdpSjBrb1Y2Yk5rVnpSVktBTkRMOXM2MVdIRGdmWlFtYlpSZ01wcWc2?= =?utf-8?B?QTAwREF0Z0kyUGx5Y3J6U1laVzFkOUkrK1VjcmNUOWFGRm5OM3pFYnZFWUUx?= =?utf-8?B?MEFtbW5IZHRya01hc0NsWlhkWCsrVk1GcTM1MEFkaklWaStnaEVodXJ3Rnc0?= =?utf-8?B?dHMvQWhhNWZEYnpRL2xUeXdQOE5ydURlVWRQeUxJakNCTmlyU0tJV0c3WHFm?= =?utf-8?B?UTJvcXRhUFR6QUpJYnpUeW9xRWVOY3pHRHZsUmtTU25ScXE5WUx4WFJpNmM2?= =?utf-8?B?bTNFY2VJS1EzVU9SVkZhZ2FBdlhRYW5mTExhWCtwUGJrTXlZbCtYLzQ0ek9v?= =?utf-8?B?MS8rY3lLVlVNbGxiVURZYk96eGVzd0NFTWJQakd2UTY4c0lhTDJvcEl4Umhk?= =?utf-8?B?c3Nsakl4QkorZHJlbE91YXpKQTBpaUxhUkZHK2NoWUlTd29pSVVEZitTeTEw?= =?utf-8?B?WmpkZ0hOeUxaVkpRWXoyNWl0UkVsSkRZcWJPSjM1RkJUQ3B6OXlyYnlGY1o3?= =?utf-8?B?dVNkaVZCcENzSzZKMXFRMWVOSnJCN2duZk8vSm53SXh5ZjJrVTA2R3g3d1R1?= =?utf-8?B?VWhUUUpFcTdRVlpWQ01kSFlod1V0d3NkV0dXSWxSendINkRTRGRDVURvcDlr?= =?utf-8?B?OGlBMTArcXZ0cVN5K3N1SHArVHRZSEYwekFSSERyZmdZamJkeWtIeEtDbGlT?= =?utf-8?B?Y3kzYlFMeDltckJWdnpVc2VxRUtFL3FNMEhiTzJuRWxob2Y2Ti9xazZObzJW?= =?utf-8?B?dkZjZkV2d1pmMGFzSlBueTQ0L1JSOHc1UmtxOTRtSzRPK3RDcy9HZE5GN0h2?= =?utf-8?B?cXh6d2xQc2xVTFFZa0NkQVU1WFByNHNCR3JEc01PZkF0Y3NzUVhBOWM0bkR5?= =?utf-8?B?SVpQbnNvMUUxRTZ6QkxrQ3J0anpsaXVHTzBrcVRDdmRLbDhpbVpXNVlDQVl2?= =?utf-8?B?UERCelVFc1lhUmJ4aENSV29ZeHhLNzN1Ym84SThaSzFZSXB4anZ6WS9IWmIv?= =?utf-8?B?UjdDQXJEZW8yN0tqaEZMeDZXZkFmOUd2ZDlBV1BFaHRtRGJ3d1VkS1JyYTM0?= =?utf-8?B?UmgzdlYxTW1rKytWZ0FwQ29SRm9rdGhERStRYys5T09wQUl0VFhxNUNCb1A0?= =?utf-8?B?aGRaOUtObSsxdVRoM0R1ZHlsV2lnSkJNNGZ3VVdWeldxS1gwRnhjOTFMOTMw?= =?utf-8?B?aGEyTXUrNDFnMlB4K09LbmRQaWNYMjN1RGFQV1dkMGV5c2luaHpXS0UxM25y?= =?utf-8?B?NVZFdnA5VTdRWXNjWUU5VjNaU1RSRFZJTENZREtJQUsyZjVBR0VIczVsZS90?= =?utf-8?B?NG1OejF1SENpemNMYWtPeHV3bjBuTzZVcG5jdnU4ZjFiN01NUERsRmg1cTZp?= =?utf-8?B?dGtUVG5Ib1UrRlVsN3BSUEtxL0FaemdqMXhLb2dRMlBjeUljaE9sYllWY05s?= =?utf-8?Q?xtbxkf97DFXwbAtXdDGbQ7Zvp?= 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: 8a4HPC6A4B7Djayth6zY9YpusAjkz7p8OyIakKVK3C1f2rEE+qLEX/HLzemm32AzrOvFBTG2skE1PadzQJksTxXAYt9UWKqbOrO6VcqZnztPd2f1dv5qvOomT0YPFpCleMwBwAFekn6flDe+HMmWLJL4y1g8yP2fAygZucEIKPBPrXF6Z1X+/USGUb+6TdcRzCcTA7GMBIZewWnq9BisIPRkpuWmUeQ0pWqmMRlpCYusIQfyQpiYSIpbQiK8A4mLjbI5+bMUAdFdScQU8G2gF0js18JoJRGe4+2cqMriqi8k4aqx3Ct2cZIZKSTU/tqNPoDmCo/jP0Eg5S3tdCWO3Rt8WitwW82uTmuzh4BiUHJdGIiGYe0he6TojUVr4750UJYVP/r7WI1MepzjGNJ4XAKj/74WYz2DpyELgE71mgiSjDjkxNwOxp8CuWcpP9Z07VATqSHCX0g3p1lSvOyJt8G5SsD0IoeClVqahhIO7gy7suKoO3iwiQClH63DLcl1snLbBA6kFLCfrzkzCB8z1MqN5ZqvfeDrfMmvsvT7POKifhJ5OCcXM4ivdczJTe9vZWzj2MG3kHzetQZ3AoBcUUD/FRMz5pmTyIcMoQ/HPQG6Mk08hAWBOZVJwevCexxP X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TY3PR01MB9889.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 49c4b122-b860-4ba5-fad5-08dc132c948f X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Jan 2024 05:08:57.1547 (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: jDYil79CbAjZ2prrKdgF80cPEfBKl5WrBMPAkZj03viihyDLuRTmwNsdu2MX1FmOSuOrYx5D6Gewv3JVPy15cIuS3HQQGt7CahTuQy1Vt0w= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSZPR01MB9583 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBBbWl0LCBFdWxlciwNCg0KPiA+DQo+ID4NCj4gPiAzLg0KPiA+IE9wdGlvbnMgLW8vLU8g d2VyZSBhZGRlZCB0byBzcGVjaWZ5IG9wdGlvbnMgZm9yIHB1YmxpY2F0aW9ucy9zdWJzY3JpcHRp b25zLg0KPiA+DQo+ID4NCj4gPiBGbGV4aWJpbGl0eSBpcyBjb29sLiBIb3dldmVyLCBJIHRoaW5r IHRoZSBjb3N0IGJlbmVmaXQgb2YgaXQgaXMgbm90IGdvb2QuIFlvdQ0KPiA+IGhhdmUgdG8gcGFy c2UgdGhlIG9wdGlvbnMgdG8gY2F0Y2ggcHJlbGltaW5hcnkgZXJyb3JzLiBUaGluZ3MgbGlrZSBw dWJsaXNoIG9ubHkNCj4gPiBkZWxldGUgYW5kIHN1YnNjcmlwdGlvbiBvcHRpb25zIHRoYXQgY29u ZmxpY3RzIHdpdGggdGhlIGVtYmVkZGVkIG9uZXMgYXJlDQo+ID4gYWRkaXRpb25hbCBzb3VyY2Vz IG9mIGZhaWx1cmUuDQo+ID4NCj4gDQo+IFllYWgsIEkgYW0gYWxzbyBub3Qgc3VyZSB3ZSBuZWVk IHRob3NlLiBEaWQgd2UgZGlzY3Vzc2VkIGFib3V0IHRoYXQNCj4gcHJldmlvdXNseT8gT1RPSCwg d2UgbWF5IGNvbnNpZGVyIHRvIGVuaGFuY2UgdGhpcyB0b29sIGxhdGVyIGlmIHdlDQo+IGhhdmUg dXNlciBkZW1hbmQgZm9yIHN1Y2ggb3B0aW9ucy4NCg0KT0ssIHNvIGxldCdzIGRyb3AgaXQgb25j ZSBhbmQgY29uc2lkZXIgbGF0ZXIgYXMgYW4gZW5oYW5jZW1lbnQuDQpBcyBFdWxlciBzYWlkLCBp dCBsZWFkcyBhZGRpdGlvbmFsIEVSUk9Scy4NCg0KQmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9k YQ0KRlVKSVRTVSBMSU1JVEVEDQo=