Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noGgP-0000dy-QJ for pgsql-hackers@arkaria.postgresql.org; Tue, 10 May 2022 03:37:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1noGgO-0001wq-1M for pgsql-hackers@arkaria.postgresql.org; Tue, 10 May 2022 03:37:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noGgN-0001wg-ET for pgsql-hackers@lists.postgresql.org; Tue, 10 May 2022 03:37:07 +0000 Received: from esa2.fujitsucc.c3s2.iphmx.com ([68.232.152.246]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noGgI-000768-W0 for pgsql-hackers@lists.postgresql.org; Tue, 10 May 2022 03:37:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1652153823; x=1683689823; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=Pjq5phCXCLKl78FQnMoS4q8xrXD3gX61UDEVNjT5iMU=; b=mvHyIJYj9h4a1BT9gzplEBhJV/mHqnhL2CGVbbW2yoEPBxmryYOQ15yH iUmLGYlDq5kvpNUho6v03L7IN9aSjrKwe5QCkURNVxnwqb989UFyHgttA gs4q6dmUeST/SWNwzijV/ECNgJxB5HIgNwF1/Pm+W0g5gosCsUsviaCje DhXGh+SejjW8FUKx7JYxBalzkbFDwfP7py1NX+sm4Iu62KBR5CrSiw4i+ syf/4AVahxukiWbpOToalvu5QYvRQsX1BykQ8wv26Oo/LNedQ9QURVAHb bOq2dU5+REVXncz3R7yehOanUtU8O30aAI/f6EPKU0E6zq+ZBoPrq77JR Q==; X-IronPort-AV: E=McAfee;i="6400,9594,10342"; a="63715250" X-IronPort-AV: E=Sophos;i="5.91,213,1647270000"; d="scan'208";a="63715250" Received: from mail-tycjpn01lp2169.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.169]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 May 2022 12:36:58 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Iwl0jsksAbiy/e2oSNgXJFcmeLvlSP+gy1GS2+dfmyqAHGjAjrmrHOvQvpKFXJUfvlWRKGWTqD9REY0UCOaZpxMNoCm2wIPicg8bvtnzLfSWWNCJqCuZcHEbOCBdgf4J4xR7aanAnmZe+lt87TXjNiRymy1Cu/MlaQEJx7jx1DS27tyzgsnd1NqBYLQpJL1nBykxok1gUNS0vqVzzz35N67121T8r4Gd7L1eDxAS4fL1lptjAwkRUuw9EdLqYxJpKOcDtN3khNkSOuXlgg8VcLFLxfgzm2Z57lqHgXVPDMISJsqsoSxvX3Dsq+y6eWz/HVqayjJJZuVkRwlzUtuA5w== 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=Pjq5phCXCLKl78FQnMoS4q8xrXD3gX61UDEVNjT5iMU=; b=LDJj73xvGMM/zriGFPd7G35oe90U//WAtY3Riw1kX6kWY/gwPVn/fETh6/DLagnX96TfNPhiT1Lpc8mItGt0nLkVltcs2K+DWfqxpM9RD79ndeJ57YN18GFASbKVPZlHw5a583v1qDtdJ9uE24rArklt8WWYF4EdamvXqFa11ZqSU+gMJNEP0/85U4zT4x1VrUA3eAJx8IQlTc06Fu1wUkbwb9qUSJMf+VBYFsxQNuSuDEHxW00NqlUcZIVRubg3wUK7ehWraXDoQNvQdPen+Ehq9bVNV+/YmvpZSQEm+nL+olvpbQXS4ElchUSPgCLm6BEVTOx6gJsDH+0cmHUaZA== 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.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Pjq5phCXCLKl78FQnMoS4q8xrXD3gX61UDEVNjT5iMU=; b=K1Bjb1WGr+WvA3/jvM5+f7aMXbHSLqpbtrDxcGTVHPtL8zCWisCKFzQqG7okXtzSRrKw9hZ7aCY++vORYy0VDm47HHHG5m7/RwLMPux0OilaPJT0liXVkP0dhTvzH2QxajLL5kRbsHJO5OFW5+GwgEUswCmoKdVbuWDvuVUR9IQ= Received: from OS3PR01MB6275.jpnprd01.prod.outlook.com (2603:1096:604:f1::8) by OSAPR01MB5060.jpnprd01.prod.outlook.com (2603:1096:604:6e::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5227.21; Tue, 10 May 2022 03:36:55 +0000 Received: from OS3PR01MB6275.jpnprd01.prod.outlook.com ([fe80::5861:b904:cd0e:d082]) by OS3PR01MB6275.jpnprd01.prod.outlook.com ([fe80::5861:b904:cd0e:d082%5]) with mapi id 15.20.5227.023; Tue, 10 May 2022 03:36:55 +0000 From: "wangw.fnst@fujitsu.com" To: Amit Kapila , Euler Taveira CC: Masahiko Sawada , "houzj.fnst@fujitsu.com" , "kuroda.hayato@fujitsu.com" , Peter Smith , Fabrice Chapuis , Simon Riggs , Petr Jelinek , "tanghy.fnst@fujitsu.com" , PostgreSQL Hackers , Ajin Cherian Subject: RE: Logical replication timeout problem Thread-Topic: Logical replication timeout problem Thread-Index: AQHXq6q0QGcj6JXZ4US7wFvi0mxKGquoBbGAgABGZICAAnlLAIAB+ycAgAATswCAAElQAIAA8bIAgAAdFACAABkigIAAYZsAgAEivICAAHkiAIABaZWAgAAlYwCACggKAIAM/F4AgDYaB4CAANP8AIAAsSuAgD7B+oCAAUduAIAJeV2AgA4SawCABpEzgIABUlCAgAGGygCAAD8kAIABVFSAgAAdkoCAB/p7AIABQC/ggABIXACAAVeYMIAAOpQAgABCZQCAASy+AIAFyaWQgBRitNCAD7afAIAGWNIQgAHoyACAB8R6cIAAOXWAgAKPYVCAAgvSAIABg4EAgAXSvjCAAG1LgIABNYgAgABJ9YCACr/LsIAAvEGAgAEaMACAADb0gIAAGyqAgAEizbCAAF5QgIAEXb0AgAFV6cCAA7VegIABO8mggAAP0wCAAEKDEIAEKtoAgABG3JCAAUgqsIAB+P7QgAATMACAAcuPAIAA5KGAgAAG6ACAAAhZgIAAE+YAgAfzQhCAAAcGgIAAKseAgABKWDCAARZyAIAGWo9ggANqW4CAAa0sgIAFvRwAgAAKGACAAwVJcIAATYAAgAy/joCABcOwgIAACDCAgAABHwCAA6XRgIACl5GAgABYaLCABLCVgIAAcMUAgADoZACAAAOdsA== Date: Tue, 10 May 2022 03:36:55 +0000 Message-ID: References: <78d4b56b-f6a5-4260-90a6-9943e0e88ce6@www.fastmail.com> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 1f546bd5-8e54-4d56-84bb-08da3236545b x-ms-traffictypediagnostic: OSAPR01MB5060:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: flCh6TEpCbMIZp1WOxRZHfFevl7rviqzc1BexFGlI+j940iJLpu9AzZRsHh8sezzDinBKew3nuU9sQzZgHy1xjBpJCfGcvOG63qjPp+7NByoVSbToTmUOBQ3TTFY1WXfyWpSjVK7lAuKUU36ZMk0dwaLveJ1fvBte60MiJe5efRc6fqvJM75xSTZ0ULrV+yw91QJyvwpjK4DGSJQuIGpMc2HrAOBWs6dycwKw8TJeBBxNlKMK/HnLi08cIRVOHH2V1vZ6cGfre7EeUjxU8PJ0SF7HCamBgvXvteOGZvpYSlJmCyXFxBi0EiH11RoNvaShink+B6SrC3wIC23/ZOOqeZlVVDwU6scbR2GtHYWE09VQNyq3bdyRJs0mhNG0IvQ2FAh6fFsKuLFVV+UlGZZ8dPO83s/pOfuvpxZaMKRhizM46KA7qLTRngrFn0HKR0snHrmH/dS6JoAixu7FvjIfIk/qUh672GYwp+8mdrNwdMGN25A6qDrSKfmydyU0+VfoTmLx7/p1XH5tW2epB9Z8ely+yszE0pPPaXhkkLW96WfvEOo3FLR8901K5PPXJ0xo4X/nHncrdTd6h7fACSUl4BSCcutdImNDFHEvxH0JTxrANCetBpD7bipGD9Pgq22L5dXLjvIdFBv34VstWmIlt19psL78g+ieffrDv+7pZXu++UnsoXmBoiKN8FzibZqaRqAYuzlvXV0G1rX+lnHvg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS3PR01MB6275.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(33656002)(122000001)(38100700002)(85182001)(53546011)(5660300002)(110136005)(6506007)(8936002)(83380400001)(38070700005)(52536014)(86362001)(82960400001)(66446008)(64756008)(55016003)(316002)(66556008)(9686003)(66946007)(508600001)(66476007)(26005)(76116006)(8676002)(4326008)(54906003)(71200400001)(3480700007)(7696005)(186003)(2906002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?NW52UDRTR2dhNDRuMW5PWXppMzJwTks3YzhwV3lEK0wwLzJFby81MDM5cUI4?= =?utf-8?B?Q2hObGtHRkMwRjdGZ3E3Y1JvZE9ydmlNR0ZWRVp5Vmk1MHY3YXY2MWk3Qit5?= =?utf-8?B?VUxMemVJNjh4T3IwSTZETEZoK2Y5MFNtVVRObWFRNDF4VzFLQmp3ajlJbWNj?= =?utf-8?B?UERPMzZVSE9LU1NNK1VwSE5hWjRMTXU5UnMwTE9JaXJiVFd6Sm5XcEJSNUhx?= =?utf-8?B?Qzh5SE13SUI3VWNDVEFpTEFWVmtqeHUwR2ExcDdrUXZHTDVLdGJFaGZLMzlR?= =?utf-8?B?U1B5dVREWE85dXVPbmdTcFRObTBHemNFbDFrWjlzS2tPTEpuR2Q2ekFYYTEv?= =?utf-8?B?bFAyN1FWZVp3MnBUcW5LL1RjYW5SLzRFSVVXc0xIbXZpaXRLSTFlRE1nYVNs?= =?utf-8?B?aEkwM3RPNWtUeVFJUzBQemhHbnFaY3N0WlJVem1OTDZkR3NJUHZkNFJEYWJD?= =?utf-8?B?V1lGcDFFUkNtR0ExdzdQSGNQZjFjQ1B2bFptU0Frb2xvYncrMCs0NDZnY0Mx?= =?utf-8?B?Mlh2WUpYVW5ITXBucjdQWkJCZi9SWXM1MU15NU1BYVBodzEwMHRQQ051OXpa?= =?utf-8?B?M1BHeWdEU3lDdnVSNEQvbkdvQk5SVkppcWRkY1FTVC9SRHRXZ3dUOEI3cEVV?= =?utf-8?B?QTNXQVpIc1VKUDIwZ3BNdG9RZW4welh2dWN1Q0tJRDN2SVpsM0FtMDVmbmhp?= =?utf-8?B?dmxta09TTjBFV3VSeDVha05EWmU3dFV4Slc0b0NjbDNGTnk5ZWVKQTRXbDBE?= =?utf-8?B?NEY1V3o0aGVDOVNiTnFrendsZEdSVmdGaUF6MGs2Q0RsbFpSZFQ1ZTFvUksv?= =?utf-8?B?ZGk0V3VlK0k1ZDgwdmNXcmJOczFDcXBadzhOWm8xVnEveEpxei9TQUl5Y0Fn?= =?utf-8?B?SGhrRzhLZ1NPbVNpb0EwT1Vzblh1M0Z5RWRDRlIvK3lpVENYL2g5RDRiMFkv?= =?utf-8?B?ZUZBOVpVYnByamtsNVpFMWpPeHNTdHF4MHY4SndQcmRRNWdTUUpuTklKbXVz?= =?utf-8?B?OFpDRXZVbHNVN1Zvd1RSSk1xUzV4bmpvWTA3bFVVb2dwK25VYVNDendFRHZl?= =?utf-8?B?VnJBbEpqUmRkUElTZkVBa3U0OVhibGdEUTN3eGVxNEZBSjQrNzNJM01BUCtI?= =?utf-8?B?bUVCL2JUbVovbGNOekhKYkZvWmR6RU9Gc01ibHV2Zk1MekV6UThGTlJja3Fs?= =?utf-8?B?WkV4VFJxcTlCbjA3Tkh4bkZob1BNS2tHTVdRK1FTK1h4THdOODg5dURhRnJZ?= =?utf-8?B?TnlYTGtSQXF3VFZhU0x2NERtT1ZrRkpJdmUxdmRHWDRGVTY5SVJ4RE0wMWxF?= =?utf-8?B?dDlKdktzT2VqVm4vS3JaV2w3VTVkZ1J6ejRPOGgwTEV5akd1K0JuMm5LeFdy?= =?utf-8?B?cVNWZDBnaTZtUWtxMXNPNHhvTE1vREI2RWdyVjVhQUc0UG03NEhaMjVjOG5s?= =?utf-8?B?cmZrSlcrdFhlYXRocEYyWTJyblJ5OHl6a2pSVFgxbVROQUZtRi9KOFYvMWtQ?= =?utf-8?B?Z0tlYUtsaVlTb0JyUmRpdFM4MHlxaERpTHljbWpnSENyWU1hc0NKY1lJM1NI?= =?utf-8?B?WnZlZnBYQUJVUGpnMDBLL2poczdGUjQ3TjE5VkRDMEZuTHRSMlR4UlQwcXBQ?= =?utf-8?B?dnVyVzJiZVJHMW1aZnlBa1lVazkrZmdKUTdZWDlHZXB2OTE4Tnoydkt4cmZL?= =?utf-8?B?Qjg2Ly9rOUh0YUVkdm9KSkxNenZkNUZ1enA4WDV5VmtndmN5M2xzdURaeThC?= =?utf-8?B?c1pyT2EvMGUyQmxsQk9ReDJFWVc3OGVOSlpmbVY1RnM2aWhKanJNZUxCRkNz?= =?utf-8?B?L3JSbUZBRHdjaHNPdXZFTmRhVm1IL0lKQjdldFppZFEyNVlZTUlaLzY5TGRI?= =?utf-8?B?UUtad1pTRC8xcjZmNXczanJFZTVJQmV5REg2QTUrSmtpM3FNMzdyL01xMXc4?= =?utf-8?B?Y1F2bERXbGVsYlFPczBOZWluTStrTnV3cE9wbGtuc3NiNWxzejh5eWpkSXRE?= =?utf-8?B?VGlpV2p1MU53VHVEV3NjQWZZaGx6cGFvdFBUV05FWWdzMmxMaU1lU1BVNi95?= =?utf-8?B?WWE3akRhbkVMTG9KWTJXaDN5eVRBZVJHNUFaVWpMTjFoVURNVHB1NnE4OC9R?= =?utf-8?B?WmgvKzRjUnJPa1VCVTJvVERlR0luQVNlQ1MyOHdTUnZnczU5WmFQdlRVNXo5?= =?utf-8?B?bEJESWpMU0FCb0dOaFBtcHVEVkVCWjQ0aExVWlh3TnB6cXJncWZ0SU14OEY4?= =?utf-8?B?RE1pcWZmaTVnL2tJbFdGRGRRZlh0V01xZWwwbnpmYTJ2b3IrZDlXSisyaHlH?= =?utf-8?B?QnhtQXVhdG5KS29VTmV6dlVLL1AydWRjWThxdDNwNEdoQXVKcSt3Zz09?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS3PR01MB6275.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 1f546bd5-8e54-4d56-84bb-08da3236545b X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2022 03:36:55.0627 (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: GmnwHQREcL1Pc2kEdAmXkRYMP/QFopkInKJNXqkXbYxfjvZv1vwOOKmgwGfhoVbMrbLh4xV3fw4SB7+aKzMvYw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB5060 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gTW9uLCBNYXkgOSwgMjAyMiBhdCAxMToyMyBBTSBBbWl0IEthcGlsYSA8YW1pdC5rYXBpbGEx NkBnbWFpbC5jb20+IHdyb3RlOg0KPiBPbiBNb24sIE1heSA5LCAyMDIyIGF0IDc6MDEgUE0gRXVs ZXIgVGF2ZWlyYSA8ZXVsZXJAZXVsZXJ0by5jb20+IHdyb3RlOg0KPiA+DQo+ID4gT24gTW9uLCBN YXkgOSwgMjAyMiwgYXQgMzo0NyBBTSwgQW1pdCBLYXBpbGEgd3JvdGU6DQo+ID4NCj4gPiBUaGFu a3MuIFRoZSBwYXRjaCBMR1RNLiBJJ2xsIHB1c2ggYW5kIGJhY2stcGF0Y2ggdGhpcyBhZnRlciB0 aGUNCj4gPiBjdXJyZW50IG1pbm9yIHJlbGVhc2UgaXMgZG9uZSB1bmxlc3MgdGhlcmUgYXJlIG1v cmUgY29tbWVudHMgcmVsYXRlZA0KPiA+IHRvIHRoaXMgd29yay4NCj4gPiAuLi4uLi4NCj4gPiBE b2VzIHRoaXMgaXNzdWUgZGVzZXJ2ZSBhIHRlc3Q/IEEgc21hbGwgd2FsX3JlY2VpdmVyX3RpbWVv dXQuIEFsdGhvdWdoLCBJJ20NCj4gbm90DQo+ID4gc3VyZSBob3cgc3RhYmxlIHRoZSB0ZXN0IHdp bGwgYmUuDQo+ID4NCj4gDQo+IFllcywgdGhlIG1haW4gcGFydCBpcyBob3cgdG8gd3JpdGUgYSBz dGFibGUgdGVzdCBiZWNhdXNlIGVzdGltYXRpbmcNCj4gaG93IG1hbnkgY2hhbmdlcyBhcmUgZW5v dWdoIGZvciB0aGUgY29uZmlndXJlZCB3YWxfcmVjZWl2ZXJfdGltZW91dCB0bw0KPiBwYXNzIG9u IGFsbCB0aGUgYnVpbGRmYXJtIG1hY2hpbmVzIGlzIHRyaWNreS4gQWxzbywgSSBhbSBub3Qgc3Vy ZSBob3cNCj4gaW1wb3J0YW50IGlzIHRvIHRlc3QgdGhpcyBiZWhhdmlvciBiZWNhdXNlIGJhc2Vk IG9uIHRoaXMgdGhlb3J5IHdlDQo+IHNob3VsZCBoYXZlIHRlc3RzIGZvciBhbGwga2luZHMgb2Yg dGltZW91dHMuDQpZc2UsIEkgdGhpbmsgd2UgY291bGQgbm90IGd1YXJhbnRlZSB0aGUgc3RhYmls aXR5IG9mIHRoaXMgdGVzdC4NCkluIGFkZGl0aW9uLCBpZiB3ZSBzZXQgd2FsX3JlY2VpdmVyX3Rp bWVvdXQgdG9vIHNtYWxsLCBpdCBtYXkgY2F1c2UgdGltZW91dA0KdW5yZWxhdGVkIHRvIHRoaXMg YnVnLiBBbmQgaWYgd2Ugc2V0IGJpZ2dlciB3YWxfcmVjZWl2ZXJfdGltZW91dCBhbmQgdXNlIGxh cmdlcg0KdHJhbnNhY3Rpb24gaW4gb3JkZXIgdG8gbWluaW1pemUgdGhlIGltcGFjdCBvZiBtYWNo aW5lIHBlcmZvcm1hbmNlLCBJIHRoaW5rDQp0aGlzIG1pZ2h0IHRha2Ugc29tZSB0aW1lIGFuZCBt aWdodCByaXNrIG1ha2luZyB0aGUgYnVpbGQgZmFybSBzbG93Lg0KDQpSZWdhcmRzLA0KV2FuZyB3 ZWkNCg==