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 1nTpL8-0008Vf-Je for pgsql-bugs@arkaria.postgresql.org; Mon, 14 Mar 2022 18:22:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nTpL7-000604-D7 for pgsql-bugs@arkaria.postgresql.org; Mon, 14 Mar 2022 18:22:41 +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 1nToXG-0005Rt-Ck for pgsql-bugs@lists.postgresql.org; Mon, 14 Mar 2022 17:31:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nToXA-0003EI-Pg for pgsql-bugs@lists.postgresql.org; Mon, 14 Mar 2022 17:31:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=wfI9xQ1hAN5yDt3RUsVNH+a38+k2aaajiSRskMg2KIQ=; b=py9dLPOWoNZWvRSVxa8IgO6HmO 3X3IAEPDI3azQ7pbGKGCz0Sbj+NdOH6bhseFlVSpvH6D3ttQSNzwQ9X0GNIZh2j4vRyXcJ3pSGvOG pzoC9P1Tb4xopG/JN6T2I/KVllOLcnOZD83CREP74ntUV8urXg139Taa7f55M7QfN0jXvvBy9dnca H43q3ltAV9KhD6kMWHjlv+nVaufQoEwDA55fbq6J83LJ7CyPm9m9drHq01XybvCE7BKuSLQZtouf2 7sisoYsyElwNfXcWy/1Th1zTA2k4ksca76HaNhGvIIOLSoOMwxPv6RQVQOVk92dkZYIM3Y3CvzXrZ pRP2wSbg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nToXA-00017C-5q for pgsql-bugs@lists.postgresql.org; Mon, 14 Mar 2022 17:31:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nToX8-000CcJ-8h for pgsql-bugs@lists.postgresql.org; Mon, 14 Mar 2022 17:31:02 +0000 Content-Type: multipart/mixed; boundary="===============6323166827183244006==" MIME-Version: 1.0 Subject: BUG #17438: Logical replication hangs on master after huge DB load To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sergey.belyashov@gmail.com Reply-To: sergey.belyashov@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 14 Mar 2022 17:30:25 +0000 Message-ID: <17438-2d4d4d7c6d1e8ec4@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6323166827183244006== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQzOApMb2dnZWQgYnk6ICAgICAgICAgIFNlcmdleSBCZWx5YXNob3YK RW1haWwgYWRkcmVzczogICAgICBzZXJnZXkuYmVseWFzaG92QGdtYWlsLmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDE0LjIKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTEsIEdOVS9MaW51eCB4 ODZfNjQKRGVzY3JpcHRpb246ICAgICAgICAKCk1hc3RlciBEQiBoYXMgZmV3IHRhYmxlczogQSAo ZmV3IGluc2VydHMgcGVyIHNlY29uZCwgYWJvdXQgMjAwIHVwZGF0ZXMgcGVyCnNlY29uZCwgfjEw MCBkZWxldGVzIGVhY2ggNSBtaW51dGVzKSwgQiAofjEwMCBpbnNlcnRzIGVhY2ggNSBtaW51dGVz KSwgQwoofjIwMCBpbnNlcnRzIGFuZCB+MjAwIHVwZGF0ZXMgcGVyIHNlY29uZCkuIEIgYW5kIEMg YXJlIGxhcmdlIHBhcnRpdGlvbmVkIGJ5CnJhbmdlIHRhYmxlcyAoMzYgYW5kIDEyIHBhcnRpdGlv bnMpLiBBIGlzIHNtYWxsIHRhYmxlIGFib3V0IDEwSyBlbnRyaWVzCihvZnRlbiB1cGRhdGVzKS4g VGFibGUgQSBoYXMgcHVibGljYXRpb25zIGZvciBpbnNlcnRzIGFuZCBkZWxldGVzLiBUYWJsZSBC CmhhcyBwdWJsaWNhdGlvbiBmb3IgYWxsIG9wZXJhdGlvbnMgZXhjZXB0IHRydW5jYXRlIHZpYSBy b290Lg0KDQpJIGRvIHNvbWUgbWFpbnRlbmFuY2Ugd29yay4gSSBzdG9wIHByb2R1Y3Rpb24gbG9h ZCBvbiBEQiBhbmQgZG8gc29tZSBoaWdoCmxvYWQgb3BlcmF0aW9ucyB3aXRoIHRhYmxlIEMgKGZv ciBleGFtcGxlOiAiaW5zZXJ0IGludG8gRCBzZWxlY3QgKiBmcm9tIEMiKS4KQWZ0ZXIgY29tcGxl dGlvbiByZXBsaWNhdGlvbnMgZm9yIEEgYW5kIEIgZnJlZXplcyBhbmQgbG9hZHMgQ1BVIGZvciA1 MC05OSUKd2l0aG91dCBhY3R1YWwgZGF0YSB0cmFuc21pc3Npb24uIEkgdHJ5IHRvIGRpc2FibGUv ZW5hYmxlL3JlZnJlc2gKc3Vic2NyaXB0aW9uLCBidXQgbm8gZWZmZWN0LiBJIHRyeSB0byByZXN0 YXJ0IG1hc3RlciAtIG5vIHJlc3VsdC4gT25seQpkcm9wL2NyZWF0ZSBvZiBzdWJzY3JpcHRpb25z IGhlbHBzIG1lLg0KDQpQdWJsaXNoZXIgbG9ncyBtYW55IG1lc3NhZ2VzIGxpa2UgZm9sbG93aW5n Og0KMjAyMi0wMy0xNCAxOTo1NzowMi45MDcgTVNLIFsxNzcxOTc2XSB1c2VyQERCIEVSUk9SOiAg cmVwbGljYXRpb24gc2xvdAoiQV9zdWIiIGlzIGFjdGl2ZSBmb3IgUElEIDE3NjY4NDkNCjIwMjIt MDMtMTQgMTk6NTc6MDIuOTA3IE1TSyBbMTc3MTk3Nl0gdXNlckBEQiBTVEFURU1FTlQ6ICBTVEFS VF9SRVBMSUNBVElPTgpTTE9UICJBX3N1YiIgTE9HSUNBTCAyOEMvNjAxNTBGNTAgKHByb3RvX3Zl cnNpb24gJzInLCBwdWJsaWNhdGlvbl9uYW1lcwonIkFfcHViIicpDQoyMDIyLTAzLTE0IDE5OjU3 OjAyLjkwOSBNU0sgWzE3NzE5NzddIHVzZXJAREIgRVJST1I6ICByZXBsaWNhdGlvbiBzbG90CiJC X3N1YiIgaXMgYWN0aXZlIGZvciBQSUQgMTc2NjgyOA0KMjAyMi0wMy0xNCAxOTo1NzowMi45MDkg TVNLIFsxNzcxOTc3XSB1c2VyQERCIFNUQVRFTUVOVDogIFNUQVJUX1JFUExJQ0FUSU9OClNMT1Qg IkJfc3ViIiBMT0dJQ0FMIDI4Qy9BRTJCN0Q4IChwcm90b192ZXJzaW9uICcyJywgDQpwdWJsaWNh dGlvbl9uYW1lcyAnIkJfcHViIicpDQoNClN1YnNjcmliZXIgbG9ncyBtYW55IG1lc3NhZ2VzIGxp a2UgZm9sbG93aW5nOg0KMjAyMi0wMy0xNCAxOTo1Njo1Mi43MDkgTVNLIFszMjY2MDgyXSBMT0c6 ICBsb2dpY2FsIHJlcGxpY2F0aW9uIGFwcGx5IHdvcmtlcgpmb3Igc3Vic2NyaXB0aW9uICJCX3N1 YiIgaGFzIHN0YXJ0ZWQNCjIwMjItMDMtMTQgMTk6NTY6NTIuNzEwIE1TSyBbOTkzXSBMT0c6ICBi YWNrZ3JvdW5kIHdvcmtlciAibG9naWNhbApyZXBsaWNhdGlvbiB3b3JrZXIiIChQSUQgMzI2NjA4 MCkgZXhpdGVkIHdpdGggZXhpdCBjb2RlIDENCjIwMjItMDMtMTQgMTk6NTY6NTIuODE0IE1TSyBb MzI2NjA4MV0gRVJST1I6ICBjb3VsZCBub3Qgc3RhcnQgV0FMIHN0cmVhbWluZzoKRVJST1I6ICBy ZXBsaWNhdGlvbiBzbG90ICJBX3N1YiIgaXMgYWN0aXZlIGZvciBQSUQgMTc2Njg0OQ0KMjAyMi0w My0xNCAxOTo1Njo1Mi44MTUgTVNLIFs5OTNdIExPRzogIGJhY2tncm91bmQgd29ya2VyICJsb2dp Y2FsCnJlcGxpY2F0aW9uIHdvcmtlciIgKFBJRCAzMjY2MDgxKSBleGl0ZWQgd2l0aCBleGl0IGNv ZGUgMQ0KMjAyMi0wMy0xNCAxOTo1Njo1Mi44MTggTVNLIFszMjY2MDgyXSBFUlJPUjogIGNvdWxk IG5vdCBzdGFydCBXQUwgc3RyZWFtaW5nOgpFUlJPUjogIHJlcGxpY2F0aW9uIHNsb3QgIkJfc3Vi IiBpcyBhY3RpdmUgZm9yIFBJRCAxNzY2ODI4DQoyMDIyLTAzLTE0IDE5OjU2OjUyLjgxOSBNU0sg Wzk5M10gTE9HOiAgYmFja2dyb3VuZCB3b3JrZXIgImxvZ2ljYWwKcmVwbGljYXRpb24gd29ya2Vy IiAoUElEIDMyNjYwODIpIGV4aXRlZCB3aXRoIGV4aXQgY29kZSAxCgo= --===============6323166827183244006==--