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 1uogRZ-008Aay-Nl for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 10:53:27 +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 1uogRY-007OBm-OS for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 10:53:25 +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 1uogRY-007OBd-Ce for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 10:53:25 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uogRW-000tWZ-2f for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 10:53:24 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-61bc52fd7a4so451109eaf.0 for ; Wed, 20 Aug 2025 03:53:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755687200; x=1756292000; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=X4lR2Lw3A7u4UTnboN8qRiN3hnD6m0kLfL3fU8w6ahY=; b=G/M5v2fnqn9oR28AsvdBHwpfwxanqYQ/DhSuZjZcs73mrsCAwQgN2yB+mX8GDl3Ns8 SS4IB2yaAUg+ScWkPabJMuwDgE5xSv+VoPbS5xg7uECAOo8ggI0iMeNAct6zioZBF2KR Edqn+cbyR58jLKKHuQO3cYIlUfA8dCgTVQkyzqsHxRxkuh+onD+rBPVSQbtBBzCbR5dC 12Qga5bTBqbKaav+MUyU0zcRXDbNlu+atBjEjaHa2Wxk07rfgZAOp9+tK1VwrDkpKLdB Ocn8h1ycgAtt5w6Kg6qNKp5fL/E8CaBDLhmj6Lwj06VV4vARSEskLUOTQFaGAG7erPR3 9uSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755687200; x=1756292000; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=X4lR2Lw3A7u4UTnboN8qRiN3hnD6m0kLfL3fU8w6ahY=; b=ENjapL0ZgXjsaAMoQ8U0R0JFXRmNZqTgXsQLzsoWVWcuHEqbk6xmrV1hq39OEhXiun l+0NuwEslwlFBb0ypsWsbB53x5WVAuiR1MY3B+/YQaNb4APX3VcEUO5X29TxdhV8n8Y5 cyc70MQofamPQc66I7Y3Hu5ltJhhDnoFuPSOukUUt6asu+qWRg4gQz8FLDFmRqXWjGXs P2XEx4hnrvKEMtY4ikssljxXYI2j2V3VlqThbJuEniiYBS3DSHTd+YwqX3tZFfiMenIk eEIkG4n2OT35W03eqr6ELQD5QiMt0hASltBJI4h5Ys8iCp7IDQCR6s0FWWzE7I0iyjiq uzCw== X-Gm-Message-State: AOJu0YwXUTWAE75LXmFbP+ruPkRWQP+wIThvOsQt8/CjKompyuC6cxRV SXbyDs2ZbOsHpwvhu7VOUukAhKI17wa+Vpvz/0lr1XGzUvsZFUuaqNqgULxaBlfHcIFRvBqb/Eh 2WQVBeYo92opMG4ZcYy9CZrbHdf6W2RNaGvSJ X-Gm-Gg: ASbGnctXkCiaDXyUgNPOSeL3+4rXkjdkIT/qgwVXbuCEKm0VX+VcVseAZutNnXhl2ci 3nXIBUmT5B0y/0Z3cxjqowpt7oyed+qimm1G2GtlW+oNJSrp0rMZuLNFyzp5YJ/hxDTsu5B3YOZ omz3dbCkz/28kW4tQKvqCChGWoxzDmSWvwR2Jf2dvydEmz9hSgQwiA+S0mApeK6MvjJ6a4s/Q8H Nw7V4rp X-Google-Smtp-Source: AGHT+IFhx49+gpjbpui32FPy7zl7bkqjs/WJ1e8ZaqfIXaXo6xbgcmlfcHE131dnjJw0TFp/K4fAsY+1wQn1+0g1NJI= X-Received: by 2002:a05:6808:1b0f:b0:434:f7c:3d6 with SMTP id 5614622812f47-4372e209336mr3286211b6e.18.1755687200161; Wed, 20 Aug 2025 03:53:20 -0700 (PDT) MIME-Version: 1.0 References: <8B89FABB-E020-4EF0-9019-08B1B9E22208@gmail.com> In-Reply-To: <8B89FABB-E020-4EF0-9019-08B1B9E22208@gmail.com> From: Ron Johnson Date: Wed, 20 Aug 2025 06:53:09 -0400 X-Gm-Features: Ac12FXyGSVrjGi23i2J778vhyuo2tc1tpzIgTHDoIPkv39SCAsPmvPl3OEZsyYo Message-ID: Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug To: PostgreSQL General Content-Type: multipart/alternative; boundary="000000000000e702cf063cc9c779" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e702cf063cc9c779 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 U2NvdCdzIGVtYWlsIHdhc24ndCBnaWJiZXJpc2ggdG8gbWUgKHJlYWRpbmcgZnJvbSBjaHJvbWUp LiAgU3BhY2VzIGJldHdlZW4NCmV2ZXJ5IGNoYXJhY3RlciwgYW5kIDk5Ljk2ODklIHNpZ25hdHVy ZSBibG9jayAoSSBkaWQgdGhlIG1hdGghKSwgYnV0IGFsbA0KRW5nbGlzaCAoYW5kIGEgZ2lhbnQg cG5nIGZpbGUpLg0KDQpPbiBXZWQsIEF1ZyAyMCwgMjAyNSBhdCA1OjQx4oCvQU0gQWxiYW4gSGVy dHJveXMgPGhhcmFtcmFlQGdtYWlsLmNvbT4gd3JvdGU6DQoNCj4NCj4NCj4gPiBPbiAxOSBBdWcg MjAyNSwgYXQgMjI6MjUsIFNjb3QgS3JlaWVua2FtcCA8U2NvdC5LcmVpZW5rYW1wQGxhLXotYm95 LmNvbT4NCj4gd3JvdGU6DQo+ID4NCj4gPiDljIDnpIDmuIDmjIDmoIDniIDmvIDmuIDmvIDnlIDn jIAg5oyA5ryA5rSA5rSA5qSA55CA47yAIOS8gOeIgCDmhIDnjIDnpIDmuIDmjIDmoIDniIDmvIDm uIDmvIDnlIDnjIDjvIDgtIDgqIDgtIDgqIDgtIDgqIDljIDmjIDmvIDnkIAg5KyA54iA5pSA5qSA 5pSA5riA5qyA5oSA5rSA54CAIOewgCDkhIDngIDngIDmsIDmpIDmjIDmhIDnkIDmpIDmvIDmuIDn jIANCj4g5KSA5riA5piA54iA5oSA54yA55CA54iA55SA5oyA55CA55SA54iA5pSAIOSEgOeIgOaM gOaggOakgOeQgOaUgOaMgOeQgCDnsIAg5LCA5oSA4rSA5aiA4rSA5IiA5ryA56SAIOSMgOa8gOeI gOeAgOa8gOeIgOaEgOeQgOaUgOC0gOCogOKggOOcgOOMgOOQgOKkgCDjjIDjoIDjkIDitIDjmIDj kIAg44yAIOewgA0KPiDjhIDitIDjnIDjjIDjkIDitIDjpIDjhIDjlIDitIDjhIDjkIDjkIDjkIAg 57CAIOWMgOaMgOa8gOeQgOK4gOSsgA0KPg0KPiBUaGlzIGxvb2tzIGxpa2UgYSBidWcgaW4gT3V0 bG9vayAoYXQgd29yaykgdGhhdCBJIHJhbiBpbnRvIG92ZXIgMyB5ZWFycw0KPiBhZ28gYWZ0ZXIg ZW5hYmxpbmcgYmV0YS1zdXBwb3J0IGZvciBVVEYtOCBlbmNvZGluZ+KApiBUaGUgZnVuIHBhcnQg d2FzIHRoYXQNCj4gdGhlIG1lc3NhZ2VzIGxvb2tlZCBwZXJmZWN0bHkgZmluZSBvbiBteSBlbmQs IGJ1dCB3ZXJlIGdpYmJlcmlzaCBvbiB0aGUNCj4gcmVjZWl2aW5nIGVuZHMgb25seS4gSXMgdGhh dCBidWcgc3RpbGwgcHJlc2VudCBwZXJoYXBzPw0KPg0KPiBPciBpcyBpdCBqdXN0IG15IGVuZCB0 aGF0IHR1cm5zIFNjb3R0J3MgKGFuZCBvbmx5IFNjb3R0J3MpIG1lc3NhZ2VzIGludG8NCj4gZ2li YmVyaXNoIENoaW5lc2U/DQo+DQo+IEFsYmFuIEhlcnRyb3lzDQo+IC0tDQo+IFRoZXJlIGlzIGFs d2F5cyBhbiBleGNlcHRpb24gdG8gYWx3YXlzLg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KDQotLSAN CkRlYXRoIHRvIDxSZWRhY3RlZD4sIGFuZCBidXR0ZXIgc2F1Y2UuDQpEb24ndCBib2lsIG1lLCBJ J20gc3RpbGwgYWxpdmUuDQo8UmVkYWN0ZWQ+IGxvYnN0ZXIhDQo= --000000000000e702cf063cc9c779 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+PGJyPjwvZGl2PjxkaXY+U2NvdCYjMzk7cyBl bWFpbCB3YXNuJiMzOTt0IGdpYmJlcmlzaCB0byBtZSAocmVhZGluZyBmcm9tIGNocm9tZSkuwqAg U3BhY2VzIGJldHdlZW4gZXZlcnkgY2hhcmFjdGVyLCBhbmQgOTkuOTY4OSUgc2lnbmF0dXJlIGJs b2NrIChJIGRpZCB0aGUgbWF0aCEpLCBidXQgYWxsIEVuZ2xpc2ggKGFuZCBhIGdpYW50IHBuZyBm aWxlKS48L2Rpdj48YnI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUgZ21haWxfcXVvdGVfY29udGFp bmVyIj48ZGl2IGRpcj0ibHRyIiBjbGFzcz0iZ21haWxfYXR0ciI+T24gV2VkLCBBdWcgMjAsIDIw MjUgYXQgNTo0MeKAr0FNIEFsYmFuIEhlcnRyb3lzICZsdDs8YSBocmVmPSJtYWlsdG86aGFyYW1y YWVAZ21haWwuY29tIj5oYXJhbXJhZUBnbWFpbC5jb208L2E+Jmd0OyB3cm90ZTo8YnI+PC9kaXY+ PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4 IDAuOGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVm dDoxZXgiPjxicj4NCjxicj4NCiZndDsgT24gMTkgQXVnIDIwMjUsIGF0IDIyOjI1LCBTY290IEty ZWllbmthbXAgJmx0OzxhIGhyZWY9Im1haWx0bzpTY290LktyZWllbmthbXBAbGEtei1ib3kuY29t IiB0YXJnZXQ9Il9ibGFuayI+U2NvdC5LcmVpZW5rYW1wQGxhLXotYm95LmNvbTwvYT4mZ3Q7IHdy b3RlOjxicj4NCiZndDsgPGJyPg0KJmd0OyDljIDnpIDmuIDmjIDmoIDniIDmvIDmuIDmvIDnlIDn jIDigIDmjIDmvIDmtIDmtIDmpIDnkIDjvIDigIDigIDkvIDniIDigIDmhIDnjIDnpIDmuIDmjIDm oIDniIDmvIDmuIDmvIDnlIDnjIDjvIDgtIDgqIDgtIDgqIDgtIDgqIDljIDmjIDmvIDnkIDigIDk rIDniIDmlIDmpIDmlIDmuIDmrIDmhIDmtIDngIDigIDnsIDigIDkhIDngIDngIDmsIDmpIDmjIDm hIDnkIDmpIDmvIDmuIDnjIDigIDkpIDmuIDmmIDniIDmhIDnjIDnkIDniIDnlIDmjIDnkIDnlIDn iIDmlIDigIDkhIDniIDmjIDmoIDmpIDnkIDmlIDmjIDnkIDigIDnsIDigIDksIDmhIDitIDlqIDi tIDkiIDmvIDnpIDigIDkjIDmvIDniIDngIDmvIDniIDmhIDnkIDmlIDgtIDgqIDioIDjnIDjjIDj kIDipIDigIDjjIDjoIDjkIDitIDjmIDjkIDjgIDjjIDigIDnsIDigIDjhIDitIDjnIDjjIDjkIDi tIDjpIDjhIDjlIDitIDjhIDjkIDjkIDjkIDigIDnsIDigIDljIDmjIDmvIDnkIDiuIDkrIA8YnI+ DQo8YnI+DQpUaGlzIGxvb2tzIGxpa2UgYSBidWcgaW4gT3V0bG9vayAoYXQgd29yaykgdGhhdCBJ IHJhbiBpbnRvIG92ZXIgMyB5ZWFycyBhZ28gYWZ0ZXIgZW5hYmxpbmcgYmV0YS1zdXBwb3J0IGZv ciBVVEYtOCBlbmNvZGluZ+KApiBUaGUgZnVuIHBhcnQgd2FzIHRoYXQgdGhlIG1lc3NhZ2VzIGxv b2tlZCBwZXJmZWN0bHkgZmluZSBvbiBteSBlbmQsIGJ1dCB3ZXJlIGdpYmJlcmlzaCBvbiB0aGUg cmVjZWl2aW5nIGVuZHMgb25seS4gSXMgdGhhdCBidWcgc3RpbGwgcHJlc2VudCBwZXJoYXBzPzxi cj4NCjxicj4NCk9yIGlzIGl0IGp1c3QgbXkgZW5kIHRoYXQgdHVybnMgU2NvdHQmIzM5O3MgKGFu ZCBvbmx5IFNjb3R0JiMzOTtzKSBtZXNzYWdlcyBpbnRvIGdpYmJlcmlzaCBDaGluZXNlPzxicj4N Cjxicj4NCkFsYmFuIEhlcnRyb3lzPGJyPg0KLS08YnI+DQpUaGVyZSBpcyBhbHdheXMgYW4gZXhj ZXB0aW9uIHRvIGFsd2F5cy48YnI+DQo8YnI+DQo8YnI+DQo8YnI+DQo8YnI+DQo8YnI+DQo8YnI+ DQo8L2Jsb2NrcXVvdGU+PC9kaXY+PGRpdj48YnIgY2xlYXI9ImFsbCI+PC9kaXY+PGRpdj48YnI+ PC9kaXY+PHNwYW4gY2xhc3M9ImdtYWlsX3NpZ25hdHVyZV9wcmVmaXgiPi0tIDwvc3Bhbj48YnI+ PGRpdiBkaXI9Imx0ciIgY2xhc3M9ImdtYWlsX3NpZ25hdHVyZSI+PGRpdiBkaXI9Imx0ciI+RGVh dGggdG8gJmx0O1JlZGFjdGVkJmd0OywgYW5kIGJ1dHRlciBzYXVjZS48ZGl2PkRvbiYjMzk7dCBi b2lsIG1lLCBJJiMzOTttIHN0aWxsIGFsaXZlLjxicj48ZGl2PjxkaXY+Jmx0O1JlZGFjdGVkJmd0 OyBsb2JzdGVyITwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pg0K --000000000000e702cf063cc9c779--