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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uohXi-008Y6N-Hw
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 12:03:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uohXh-007ro5-U0
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 12:03:50 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1uohXh-007rnx-JF
	for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 12:03:50 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1uohXf-000q9X-2G
	for pgsql-general@lists.postgresql.org;
	Wed, 20 Aug 2025 12:03:49 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 57KC3dHI988959;
	Wed, 20 Aug 2025 08:03:39 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alban Hertroys <haramrae@gmail.com>
cc: Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>,
        Adrian Klaver <adrian.klaver@aklaver.com>,
        "depesz@depesz.com" <depesz@depesz.com>,
        PostgreSQL General <pgsql-general@lists.postgresql.org>
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
In-reply-to: <8B89FABB-E020-4EF0-9019-08B1B9E22208@gmail.com>
References: <aKSyq74zIuLS-2B5@depesz.com> <d1d40328-ae3a-4089-9ee0-beade92d7c45@aklaver.com> <a2cd8084-b93e-4da0-8999-569a6e58ef6b.8f62f83c-ab51-428e-98d1-ab1abb243a49.93a25b3a-0b25-4d18-8a69-08f841e737cb@emailsignatures365.codetwo.com> <a2cd8084-b93e-4da0-8999-569a6e58ef6b.b1460fbe-55a2-4060-995f-39f4e2f3c7f9.5415824a-634b-472f-8c56-ab10d48e91f7@emailsignatures365.codetwo.com> <SJ0PR15MB5245919B78ECB02696ADD1959A30A@SJ0PR15MB5245.namprd15.prod.outlook.com> <8B89FABB-E020-4EF0-9019-08B1B9E22208@gmail.com>
Comments: In-reply-to Alban Hertroys <haramrae@gmail.com>
	message dated "Wed, 20 Aug 2025 11:41:19 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <988957.1755691419.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 20 Aug 2025 08:03:39 -0400
Message-ID: <988958.1755691419@sss.pgh.pa.us>
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/988958.1755691419%40sss.pgh.pa.us>
Precedence: bulk

Alban Hertroys <haramrae@gmail.com> writes:
> Or is it just my end that turns Scott's (and only Scott's) messages into=
 gibberish Chinese?

What it looks like from here is that the message body is in UTF16:
every other byte is zero.  That gives my email client indigestion,
too.

			regards, tom lane