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 1rRqHw-009fDE-VW for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jan 2024 09:08:17 +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 1rRqHw-002kGh-28 for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jan 2024 09:08:16 +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 1rRqHv-002kGY-Nw for pgsql-hackers@lists.postgresql.org; Mon, 22 Jan 2024 09:08:15 +0000 Received: from esa2.fujitsucc.c3s2.iphmx.com ([68.232.152.246]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rRqHt-00363c-LO for pgsql-hackers@lists.postgresql.org; Mon, 22 Jan 2024 09:08:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1705914494; x=1737450494; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=SP080pRzi9Vs+opwU2sPkh/lJ4zFKPSBaPhkETyaWls=; b=SiRV4Xlxaddy72nWuMvLwgR8fvtDnSA1MCpoi346gx+XrATtDd/j4sug bmwdl7LQ6U9OmdgC2dQEq2CTzfdmUamLqw4Cn1/aTl+uYCgF9GebCx9o0 B8cHJgHnvv8fcGHarMIw5iDgNVUvmo73KhWPvVW/NuUwL+w6CLmHSrXlC HpSsjVFercCtEcK9w4JWnLjaZDaMnVp4NOfa68JaRB2SBDjraapBExQm5 BG5PFq6iPLU9+45OgoOiz7AWoiL1tXhuUmKFa1ha4cddw5XPXQXEXmPes durxgvXYYpJIWz9GXVj/pkTfupqZSd7vINbCU24KFEsxn116m52bSVP99 Q==; X-IronPort-AV: E=McAfee;i="6600,9927,10960"; a="19824019" X-IronPort-AV: E=Sophos;i="6.05,211,1701097200"; d="scan'208";a="19824019" 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; 22 Jan 2024 18:08:09 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=InIpOlj47HP04YkA+3oaTJeLEQgxhvvWbDtgWEzjrUGjJNiPk8MQPusV+2buryzePLj1jAj4HCVewCMa4gETqmBliovjWqEesdHIu8UjcoF0siE0EpZfaGTlAdiA/Zjxn85KTG3gANQPYcK6wZlsjg/P9Hyud98Z/Gbge91b0pJJCnWMH/NiDRDxk1aME+SL06XznRZMkp3UyB+TuSxWfehGpxvqH5eke+TNkgGIC/2bqeQjz2CNCmIVEq32ojtXwhwQDKFdXXRCiL5lmf8by84fHHdrezQ+DDxc70RulDGK+RJ75FUhcd0E0MQmRIMw2lNntkOrai3OrPQJfpQyxA== 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=SP080pRzi9Vs+opwU2sPkh/lJ4zFKPSBaPhkETyaWls=; b=Xs+v5qKQE1Vq2PKLrCxlNYqY04mLi4FfYRQYIMFeYfUoEX/e3PAt11LsPFci6qpFUG2w8ubJooM9HdBmoNBBACs/6OUwntACJWGXS1o9oAC2I8+h51j3edcgTbJ9Bt7g8tOeveS/VZO67GfkSnT8OXOxt17cx5Pm18WeZHeDIlXNeaFuCQ5XW213u4/stNuDK1/p1704QRBE4A7Iww9V/zB/Wrod4+r7EnsnOzzcLwx09lcg3CAOgoV0rM9FRBoJFJslkquDSGdyG0B2LWnml/4PQ3BBPC/3kE3vI1J1Zko6oDArfD1GZVqIQPDKE5UM7lOTlY/XO+pFqVNm0s8eFQ== 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 TY3PR01MB11931.jpnprd01.prod.outlook.com (2603:1096:400:40a::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7228.9; Mon, 22 Jan 2024 09:08:06 +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.7228.012; Mon, 22 Jan 2024 09:08:06 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Peter Eisentraut' , Amit Kapila CC: Euler Taveira , "pgsql-hackers@lists.postgresql.org" , Shlok Kyal , vignesh C , Michael Paquier , Andres Freund , Ashutosh Bapat Subject: RE: speed up a logical replica setup Thread-Topic: speed up a logical replica setup Thread-Index: AQHYJxwqCwVDEK8rxk6UuFJmWEa5OLBaerWAgBix/4CAACTuAIACleiAgACOjoCAKWVqAIApDNiAgARDvICAAC3UgIAADN4AgABJ6wCAAUerAIAHtdWAgAFvhACAAEZbgIAAWW2AgACrngCACidmAIAABQ4AgAYcEACAACRnIA== Date: Mon, 22 Jan 2024 09:08:06 +0000 Message-ID: References: <5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com> <2736443c-58e3-42df-8cc4-8c66106e3da5@app.fastmail.com> <78c88fa4-4960-4ce9-ae45-cda6302bd824@eisentraut.org> 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?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjQtMDEtMjJUMDk6MDg6?= =?utf-8?B?MDVaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD01MmM5NGVlMi1hMGE3LTQ4YmQt?= =?utf-8?B?OThlMS1jZmFkYzNiODQ3ZDQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?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_|TY3PR01MB11931:EE_ x-ms-office365-filtering-correlation-id: 3a8c51f4-7167-4c85-eb9f-08dc1b29a56f x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 5CaGXA2xKPslo5cBtSrQyNvzS11XS0NedT0ebYvc6Di3SXht0KM3xy4JaoP+IBnO5gWbONY9A2/sddgyzxkMFFWlBoYQbn8hpjC7+bGa86+BmHlV/iuQ51Hxih5zyvCuJWysPdheZKI3kt4W47/bc/InozEheOWeAq2wkLn8+/+BVk7sFiwFm3ma3DnyK6HmioTzxAJtFjXlvc9zLVWr30HXrctfxMMPuCbpVA7V6fp+FFULO9FRp6BOBGATVhMUutlCE7i9Lj2R2SApyt79RDTaZNuYQkCswhJMx8p1TPNMLdBuU3xU8yDpaD8/EMU1zf0O1QrdgY3JeUJ6B263cGXiXTb8JPQ20kD6FX9GPlhWbVdU/ghYEYKCMLFg38dLWXHgrsSyVKVjQZUxKxPGvB3Cx30Rze2ypvxn+XDRe0yJoTXntuMD+xuZZ97QJTnbMquVS5iZ9KpyTQRtQiz7T507fIaLQk4zL3GnTjb/s10AwTp/rYHHMPchqc7abF6BNtRKGtqboDBOKa7ShAYuExVyVovcrsV/EOAdPWBu6cHv2NBw6pyTSyjE0MOnqwA08tyK2bVM+Lr78NJ890Bh+5WSfzVb2vNBHtD1lj9W5DctijFPCHW6VArmgll9zVbs6fEVl79ZdH9gUhj+foG9hQ== 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)(376002)(39860400002)(366004)(136003)(346002)(396003)(230922051799003)(64100799003)(186009)(1800799012)(451199024)(1590799021)(966005)(71200400001)(83380400001)(41300700001)(478600001)(38100700002)(55016003)(82960400001)(122000001)(7696005)(9686003)(1580799018)(6506007)(86362001)(316002)(52536014)(64756008)(4744005)(66476007)(8676002)(26005)(8936002)(85182001)(5660300002)(38070700009)(33656002)(66946007)(110136005)(66556008)(54906003)(76116006)(4326008)(66446008)(2906002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dkU4SGVLSGlLUTVDMUJKR3BuTGRlYmtIeExFcEE1Z0Vmd2NKOEszemEyWmw1?= =?utf-8?B?YWhneXArWE8xazFlR1BYNHcwWHRZNm1wRHdLaGEwQUdPSzRreEpKdEhYckxJ?= =?utf-8?B?T21vM05uZlhsUlpHQUdzdHF2cGVWL09xbTVIVDBYSjd1T05ubXBvUWU0ajhX?= =?utf-8?B?QjhmTExmQTl3NmdxMXMvbTlUTlRheFRpWll2SXhtM0RVRU5uZjd1NitWcE5E?= =?utf-8?B?dzB0Zk5aaUU4dXpxNHlIc2tjZWNVU0J3Z1FHc05TY00yS3IyZGJTSUQyWVJy?= =?utf-8?B?VVQ5eDN3S0ZGMVZzRTRyVCtld1llWnJFdXN0dFBaMGNpSzVrZ2lKaFRveUph?= =?utf-8?B?bXNFbkVsT3NSMk9ma2FkaWZnSDFtWWFOMHp1MkJ1ZzIyc0NBTFFlVnREbW5L?= =?utf-8?B?VStrVE0zNExFdk9pbktsb2UxTzlWTDJEdHl6M0JQcnhLbkIxZTNrc25qRUww?= =?utf-8?B?Sko4VE93cTZaVkQxalp0Y2Y5MHpscXYrOFJ1WjBLeSt1Ti9iMzEzYVVCWS9a?= =?utf-8?B?ZmhuUmNHazNTcUx0Uy9paGVnQVEySzREbElhOXRWdi9GcE5SN0FKenlldGFF?= =?utf-8?B?c3B0OTNGSVdsL1dYWEpHM1R1V1pnQWtwRjZiMDhwVU5ZK0lSWE5Bb2EvOE1Z?= =?utf-8?B?ODFmYnJuRHI2SnFMMW5BT3dmSkJ4bEpTK2wzbXZSYnNiNFIxa2NpckQzbTkr?= =?utf-8?B?OWp2bUg0R2I3NXU4ZU55SGNjb0Z4cVpwMW5WUFQwakY1SmNHRkpwdzVPSHRV?= =?utf-8?B?SUNURVdaVVVrN1hLNkZyYmc3Z0pmdm5HK0o3eXNEaHc0WUhIL3U4RVc3OVBu?= =?utf-8?B?ZUQyZ3ovRk1WblQ2SGw2dkMyT0NxNmxKOHBEQmFxaDJ1UEZaOXRVUE80dkVU?= =?utf-8?B?VUNjeGhLWXJrWC9YRVVxT2llQUdwbWxoZWlJd3lQMWVQQUo2bW9Tb0dKcHZH?= =?utf-8?B?b012ajBZdU5UNXJhZkwxWE14RDJMYXZxck5GMmh1RThURzEyWmJ3ZVJTMzlL?= =?utf-8?B?eGx0T2dOSE4yaUg0ZVNEdjFLYTJtVGFWcEpjVFNZZEQ2cWRLNjRZZ2VkK0Zk?= =?utf-8?B?d1NacVBPOGtweDcxaTFXTVVEM3o4dmErOGxkYk4wREFpdk5GUlpzbmNTdmVB?= =?utf-8?B?Vzdxa0JMei9sRTd3QVhaYmZxa0x1YUY5Q3NLMDV5QXI1QjFVaXdZS29BbitM?= =?utf-8?B?ZCs3cGV2bDJ1MEFKWmJVdVdoZjYyWG55ekJrczNiNkVTNEdmVm1TeU5zZisx?= =?utf-8?B?SnZ1MGtjNDQ1dVJGMlVuOTRJTGI2cWZ4elkvM0wzM0VLZWFZVk5BdEtRcURI?= =?utf-8?B?ekRmMjkzZHFTN0FpdjltTnR0SUJHRXdBbGFnck5WUnRRdmRQaTlRLytobkp3?= =?utf-8?B?eUs2WVNQb0pybENPcUVaOElTTjh4MGF4ZDQwMkRucWJDVFcyejJ2RU84VGxZ?= =?utf-8?B?Z2MxelB3WXlsWnR0REJQSHc0MGYxWENzR0gxT3BpeEgwNDJYUEpTeG50dXpC?= =?utf-8?B?SzNGUElPeGYrb2cvTFNxY3R0Z3pEU01YeFd2dmV4N0hwRnNac0p5WkVNWkh5?= =?utf-8?B?V096RitvdVZ0V0VrcXJZZmc2bnRLclZ4K3E2Y0gxcEdjdkJPRXFzMnBxUWl3?= =?utf-8?B?RlQ5ek5OczR4SC9XdkN5dGppbmpsSnhPbWxEWmxGZVhmL25vRjVrNGUybmQ1?= =?utf-8?B?Z3RqMnB1UTRMUGZ6c09qMHFBRXVjUWhsWEJuRnZhNUNXMzFtODQrRGFpUzN0?= =?utf-8?B?WHBXUDhZdTlZMG12cXdsNTVlL3EwUG9Fb2czcHIxUnRrQnpTb2k1eVg1UUJs?= =?utf-8?B?dTVHdUtITzVway9xdC80QmxJYTlSRS9pWm5zcFYzQUMydVl5NWYvV1dmM1Ix?= =?utf-8?B?dFdMb2hqbVdmSWxnVEdsL1A3cUMxS1VoSStYaWkzMTJkVkdDeEEvanI4SGFa?= =?utf-8?B?YWZhTmZvL1lZdVUyc3J6WTd1SGR0bFJFcTd6NFM0dE4xa0JKSFUrRXRrdGlI?= =?utf-8?B?blQxUzREZnZlNGxvR25YTmVoMFBVQWVTZkpaY2FyTDUxVFFQY0M4OGRaVkRS?= =?utf-8?B?RXU4NHRjNzVodHJsTWtTT2xWQWhLUkhFdlB4SjRqSDIzVmQ2R0xuWTBseVFZ?= =?utf-8?Q?7R5eOCbe7W5jxjBjBWyrF8nkY?= 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: Ok1ulfWuOaNoOkvmye7z1qNVKeye8PxcVBX8MWKaOxGF/bkbdIasEahN3xcN1VryMnku7Gh/zGYogcdVKFRgycywXfSIZmx42udruWjFHxClQeN3VkMkkiVWxUKr42uQt0h2AqcZEdG9MXWudeKUEoCtw6YMhkivFL4zYA8fk+/DWTE+4q5sVjFIOcAUs2+wpkFOMj2VDZGj/jwiWFvUggDKEHY+CnLKxvLJBBnpwjlcNR618UTftWnZuNqN1NOZ6/pXrBzy2FvuHzT9k654Ajm84eahmgHp79zDfwI8TwDvIa6PwyWIuQvTrI5HBp6EJZYbuLUe+dKX6tenJLZTjc0xVE3yLBLT3i3dcsCU7gWZCIAU6zM8YwAm/XFk6H5rOxCZo4jMLZGueK5SnK6/6MjTjg/nLPoXso+P39GTle5TpSxLdvMfO85n0mTMbUSd5vdxAASbTQJUQM4itE5/6QVVl3+5kBV2nwyvxydCsv/D0oh0p6F4LnPR6PYR0+JZQLNbjnxjDrV8so/ulAKHxE3erGLnhiyLB1X0YP8MrxHpmIbIi/wFeUKQ55GHlpbPYMcc7i9o8KBP406DcLIK3TW49uIKYtZG7M8uYQQfhNmjNLqU7jLLBcvTQD6lJtN8 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: 3a8c51f4-7167-4c85-eb9f-08dc1b29a56f X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Jan 2024 09:08:06.2852 (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: QKnh9M0kys+kiklkPZnF8b787p7+VSGNtyXBJMp9e7J46ZDwVydROC/QR7th4yW04reMJuFo6+h1ShhCwBteVN6fo8Q92sJGgLjBTyYxOQA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY3PR01MB11931 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBQZXRlciwNCg0KPiANCj4gPiBZZXQgb3RoZXIgb3B0aW9ucyBjb3VsZCBiZQ0KPiA+IHBn X2J1aWxkc3Vic2NyaWJlciwgcGdfbWFrZXN1YnNjcmliZXIgYXMgJ2J1aWxkJyBvciAnbWFrZScg aW4gdGhlIG5hbWUNCj4gPiBzb3VuZHMgbGlrZSB3ZSBhcmUgZG9pbmcgc29tZSB3b3JrIHRvIGNy ZWF0ZSB0aGUgc3Vic2NyaWJlciB3aGljaCBJDQo+ID4gdGhpbmsgaXMgdGhlIGNhc2UgaGVyZS4N Cj4gDQo+IEkgc2VlIHlvdXIgcG9pbnQgaGVyZS4gIHBnX2NyZWF0ZXN1YnNjcmliZXIgaXMgbm90 IGxpa2UgY3JlYXRldXNlciBpbg0KPiB0aGF0IGl0IGp1c3QgcnVucyBhbiBTUUwgY29tbWFuZC4g IEl0IGRvZXMgc29tZXRoaW5nIGRpZmZlcmVudCB0aGFuDQo+IENSRUFURSBTVUJTQ1JJQkVSLiAg U28gYSBkaWZmZXJlbnQgdmVyYiB3b3VsZCBtYWtlIHRoYXQgY2xlYXJlci4gIE1heWJlDQo+IHNv bWV0aGluZyBmcm9tIGhlcmU6IGh0dHBzOi8vd3d3LnRoZXNhdXJ1cy5jb20vYnJvd3NlL2NvbnZl cnQNCg0KSSByZWFkIHRoZSBsaW5rIGFuZCBmb3VuZCBhIGdvb2QgdmVyYiAic3dpdGNoIi4gU28s IGhvdyBhYm91dCB1c2luZyAicGdfc3dpdGNoc3Vic2NyaWJlciI/DQoNCkJlc3QgUmVnYXJkcywN CkhheWF0byBLdXJvZGENCkZVSklUU1UgTElNSVRFRA0KDQo=