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 1pcuMe-00067F-54 for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 20:38:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcuMc-0007ec-EK for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 20:38:18 +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 1pcuMb-0007eS-Mr for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 20:38:18 +0000 Received: from mailfo01.lmco.com ([192.31.106.12]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcuMX-0005cW-T6 for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 20:38:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lmco.com; h=from : to : subject : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version; s=corpgw220615; bh=ZDRxBPGQhSU13gFJSddg/AE3ZEa8zRi2le2TQgKHoCo=; b=SEA0cOH+8eOMKO6wnvXQ++1Zb/tW6zLDtsWnTYVovCtOYOBJRPLU4tZ4sbXRwWXL3C26 XqS/VpVCKamX+P0lPSpqDBzG7ZpsB7S1oNd+yFBYYFfY6iDSKs6QgRi7r93bvRJI9gbg S5AZt+0DymGIUsAP8A/pTUqTmjxmpylKFL6gPN1eGmpHem8FfNROdFuIFOw9ww2mkV6m 0yRuWmcFklhpbDs0b7ylu2vwISj6yEHDKsX4aYQO0AeW84vZYPhKLTJ9i6ONC/0I7kg3 UynCkJqRsJOYri7SLMcFpOixYIdl3irc6H/NfdNVbmzA0nO0XUiX39ZZUBTrFzf4kJ4x Eg== Received: from lmxpdend09w02.us.lmco.com (lmxpdend09w02.ems.lmco.com [172.23.20.57]) by mailfo01.lmco.com (8.16.0.42/8.16.0.42) with ESMTP id 32GKc8A2329566; Thu, 16 Mar 2023 20:38:08 GMT Received: from lmxpdend09w04.us.lmco.com (172.23.20.59) by lmxpdend09w02.us.lmco.com (172.23.20.57) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.1.2308.27; Thu, 16 Mar 2023 14:38:07 -0600 Received: from lmxpdend09w04.us.lmco.com ([172.23.20.59]) by lmxpdend09w04.us.lmco.com ([172.23.20.59]) with mapi id 15.01.2308.027; Thu, 16 Mar 2023 14:38:07 -0600 From: "Dolan, Sean" To: Laurenz Albe , "pgsql-general@lists.postgresql.org" Subject: Many logical replication synchronization worker threads kicking off for ONE table Thread-Topic: Many logical replication synchronization worker threads kicking off for ONE table Thread-Index: AQHZWEc2IErQfQDctEavEp2M8R3RYA== Date: Thu, 16 Mar 2023 20:38:07 +0000 Message-ID: References: <0eda9b7d13e34cc786d30c602510f3e4@lmco.com> <6eec8fc3dfa743ff9b19d8ce0e87763d@lmco.com> <47d0b525ad3ba570b4100e7b8d2a2b002ceba232.camel@cybertec.at> In-Reply-To: <47d0b525ad3ba570b4100e7b8d2a2b002ceba232.camel@cybertec.at> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.23.20.7] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Proofpoint-ORIG-GUID: -UhKA8OhuGHCKitzCgCbUVADsofDACQ5 X-Proofpoint-GUID: -UhKA8OhuGHCKitzCgCbUVADsofDACQ5 X-LM-Outbound: External 172.23.20.57 cntry=** g=-UhKA8OhuGHCKitzCgCbUVADsofDACQ5 q=32GKc8A2329566 m=1 X-LM-OBSENDER: sean.dolan@lmco.com X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.573,18.0.942 definitions=2023-03-16_14:2023-03-16,2023-03-16 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 phishscore=0 malwarescore=0 spamscore=0 suspectscore=0 adultscore=0 mlxlogscore=999 bulkscore=0 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2303150002 definitions=main-2303160154 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGluaXRpYWwgZW1haWwgYmVsb3cgd2FzIHRoZSBlbmQgcmVzdWx0IG9mIHNvbWV0aGluZyAi cnVuLWF3YXkiIGluIG15IGxvZ2ljYWwgcmVwbGljYXRpb24uDQoNClBvc3RHcmVzIDEzLjYsIFJl ZEhhdCA3LjkNCg0KRGF0YWJhc2UgQSBpcyB0aGUgcHVibGlzaGVyOyBEYXRhYmFzZSBCIGlzIHRo ZSBzdWJzY3JpYmVyLiAgICBXaXRoaW4gRGF0YWJhc2UgQSBhcmUgbXVsdGlwbGUgc2NoZW1hcyBh bmQgdGhlIHB1YmxpY2F0aW9uIGVuc3VyZXMgdGhhdCBhbGwgdGhlIHNjaGVtYXMgYW5kIGl0cyB0 YWJsZXMgYXJlIGFkZGVkLiAgICBUaGVyZSBpcyBvbmUgdGFibGUgaW4gcGFydGljdWxhciB0aGF0 IGhhcyAxLjRtaWxsaW9uIHJvd3Mgb2YgZGF0YS4gICANCg0KSSBjcmVhdGUgYSBzdWJzY3JpcHRp b24gb24gRGF0YWJhc2UgQiBhbmQgY2FuIHNlZSBpbiB0aGUgbG9nOg0KCUxPRzogbG9naWNhbCBy ZXBsaWNhdGlvbiB0YWJsZSBzeW5jaHJvbml6YXRpb24gZm9yIHN1YnNjcmlwdGlvbiAic3ViX3Rv X2RiYXNlQSIsIHRhYmxlICJhbGVydF9oaXN0b3J5IiBoYXMgc3RhcnRlZC4NCglDT05URVhUOiAg Q09QWSBhbGVydF9oaXN0b3J5IGxpbmUgNjY2ODQ1Ng0KCUxPRzogbG9naWNhbCByZXBsaWNhdGlv biB0YWJsZSBzeW5jaHJvbml6YXRpb24gZm9yIHN1YnNjcmlwdGlvbiAic3ViX3RvX2RiYXNlQSIs IHRhYmxlICJhbGVydF9oaXN0b3J5IiBoYXMgc3RhcnRlZC4NCglDT05URVhUOiAgQ09QWSBhbGVy dF9oaXN0b3J5IGxpbmUgNTE3NDYwNg0KCUxPRzogbG9naWNhbCByZXBsaWNhdGlvbiB0YWJsZSBz eW5jaHJvbml6YXRpb24gZm9yIHN1YnNjcmlwdGlvbiAic3ViX3RvX2RiYXNlQSIsIHRhYmxlICJh bGVydF9oaXN0b3J5IiBoYXMgc3RhcnRlZC4NCglDT05URVhUOiAgQ09QWSBhbGVydF9oaXN0b3J5 IGxpbmUgNDMyNTI4Mw0KDQpOb3JtYWxseSBJIHdvdWxkIHNlZSBhIGxpbmUgZm9yICJmaW5pc2hl ZCIsIGJ1dCBJIG5ldmVyIGRvLg0KDQpJIHRoZW4gYWN0aXZlbHkgd2F0Y2ggdGhlIHNjaGVtYS90 YWJsZSBhbmQgZG8gXGR0KyAgIGFuZCBjYW4gc2VlIHRoYXQgdGFibGUgZ3JvdyBpbiAyR0IgaW5j cmVtZW50cyB1bnRpbCBJIGZpbGwgdXAgdGhlIGVudGlyZSBkcml2ZSBhbmQgcnVuIG91dCBvZiBy b29tIGZvciB0aGF0IHNjaGVtYS4NCg0KSSBhbSBOT1QgZ2V0dGluZyBhbnkgImNoZWNrcG9pbnRz IGFyZSBvY2N1cnJpbmcgdG9vIGZyZXF1ZW50bHkiICAgIEFzIEkgaGF2ZSB1cGRhdGVkIG15IFdB TCBzaXplOg0KCW1heF93YWxfc2l6ZT00R0INCgltaW5fd2FsX3NpemU9MUdCDQoNCklzIHRoZSBz eXN0ZW0gaGF2aW5nIHRyb3VibGUgc3luY2hpbmcgdGhpcyBhbW91bnQgb2YgZGF0YSBpbiBhIHF1 aWNrIGZhc2hpb24gYW5kIHRoZXJlZm9yZSBraWNrcyBvZmYgbW9yZSBzeW5jaHJvbml6YXRpb24g dGhyZWFkcz8gICBBbnl0aGluZyBJIGNhbiBkbyB0byBwcmV2ZW50IHRoaXM/DQoNClRoYW5rIHlv dQ0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IExhdXJlbnogQWxiZSA8 bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0PiANClNlbnQ6IFRodXJzZGF5LCBNYXJjaCAxNiwgMjAy MyAxOjI1IFBNDQpUbzogRG9sYW4sIFNlYW4gKFVTIE4tSVNZUyBUZWNobm9sb2dpZXMgSW5jLikg PHNlYW4uZG9sYW5AbG1jby5jb20+OyBwZ3NxbC1nZW5lcmFsQGxpc3RzLnBvc3RncmVzcWwub3Jn DQpTdWJqZWN0OiBFWFRFUk5BTDogUmU6IEVYVEVSTkFMOiBSZTogIk5vIEZyZWUgZXh0ZW50cyIs IHRhYmxlIHVzaW5nIGFsbCBhbGxvY2F0ZWQgc3BhY2UgYnV0IG5vIHJvd3MhDQoNCk9uIFRodSwg MjAyMy0wMy0xNiBhdCAxMzoyMCArMDAwMCwgRG9sYW4sIFNlYW4gd3JvdGU6DQo+IEkgbWVzc2Vk IHVwIGFuZCBjb25mdXNlZCBpc3N1ZXMuwqDCoCBUaGUgZXJyb3IgaXMgOsKgIA0KPiBFUlJPUjog Q291bGQgbm90IGV4dGVuZCBwZ190YmxzcGMvMTY1NTUvUEdfMTNfMjAyMDAveHh4eC94eHh4wqAg Tm8gc3BhY2UgbGVmdCBvbiBkZXZpY2UNCj4gSElOVDogQ2hlY2sgZnJlZSBkaXNrIHNwYWNlDQo+ IA0KPiBTbyB0aGUgc2NoZW1hIGlzICJmdWxsIiBhbmQgdGhlIG9mZmVuZGVyIGlzIHRoaXMgb25l IHRhYmxlLg0KPiBJIGNhbid0IFRSVU5DQVRFIGFzIHRoZXJlIG5lZWRzIHRvIGJlIHNwYWNlIHRv IHBlcmZvcm0gdGhlIGFjdGlvbi4NCj4gSXMgdGhlcmUgYSB3YXkgdG8gc2VlIGlmIHRoZXJlIGlz IGEgdHJhbnNhY3Rpb24gb24gdGhhdCB0YWJsZSBsaWtlIHlvdSBhbGx1ZGUgdG8/DQoNCkFoLCB0 aGF0J3MgZGlmZmVyZW50Lg0KDQpJZiB5b3UgZG9uJ3QgaGF2ZSBlbm91Z2ggc3BhY2UgdG8gcnVu IFRSVU5DQVRFLCBhbmQgeW91IGRvbid0IGZlZWwgbGlrZQ0KZXh0ZW5kaW5nIHRoZSBkaXNrIHNw YWNlLCBEUk9QIFRBQkxFIHdvdWxkIGJlIGEgY29udmVuaWVudCBhbHRlcm5hdGl2ZS4NCg0KWW91 cnMsDQpMYXVyZW56IEFsYmUNCg==