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 1uofK2-007oxj-D2 for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 09:41:35 +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 1uofK1-006tlc-Rf for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 09:41:34 +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 ) id 1uofK1-006tlU-Fo for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 09:41:34 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uofJz-000p39-1y for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 09:41:33 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-afcb78d1695so83133666b.1 for ; Wed, 20 Aug 2025 02:41:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755682891; x=1756287691; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=kSv9Zoy1NdwYGFVimf8PjZocbrcF02UuCDo00GaWNEQ=; b=nZ8XaC86q7IYvacBxsV7VC87J1ntb4EehOJC9rM2b83tmMWS/FyUZFtBt6SkITZqMf RexBMH/JwqzIwA1KaAen7UDS0fqo0/ZAcbVaSgsrlZjysNUzzqLxlwtrVv/JjN/fw9tF CVMaunce+2alpJqH/ku4d0J5iXcdNNiRvBsJ9SvGTilJPLSQddFUPL2+4Lj/iHNK5ORy dis6QnEnRoIDfYa1cW33zYwvPI8dy3irxH/x27dw4rLjbZ3SULpJAnH5kb2BwAn+VsYw mUH1DAa2bVEfrqDrmTOVXE5fxwWr5fVb/6/E6hqzjl5fpLXvXcezQXYj8lhGQFfwoZVI NR6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755682891; x=1756287691; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=kSv9Zoy1NdwYGFVimf8PjZocbrcF02UuCDo00GaWNEQ=; b=xFIqPDDx6XDZqSRBMuPYU6YqbFspVRkn8zC6bmOO6abt1AUnpG0LvmfjovRLDCc1vp oHYW03ft6up4uqmDDcyt2PFkPmFHNCEMXwb5EnAhURC2wx3xv14zsLi8zKLbsZBpDYqA nOjdmLrjJEIFL8PIOYs6+Wcm13LnZ4qV1NT8/aebbm6f76Lx2331G6LmWgZ5prsx1oop XqOCUfOuIY2XxR/g8eGJTYoLawiSgMD2HT3yKgqqIJHa/G3AdTDfp7TXJk8tYaZqRo23 shOcaoXe4/mnioOFxeE3rtivdKOpYjSJrv4Uh58jOtGnvTAmy3AjKtODPh3qDW7phhV7 L/IQ== X-Forwarded-Encrypted: i=1; AJvYcCUCgufKv5AzPSABS/Oh7QLhaHSyGh5s8JCj615ExcJvi7shAMVK+BVQ57ffKMYfcNzesYUg7N/pTLsQkwzi@lists.postgresql.org X-Gm-Message-State: AOJu0YwlY6QtI1xJb5K1ixQmVPQyOsa//4hRqHVIQhc4TzXDXU4g1H75 Wzh0TfyU3t/ibpQ/UvMvTXSvM34lxGVg2uN5NdNZc+vxwMkXH0l6Iwiz X-Gm-Gg: ASbGncs6XUx6VyvsLgV2y+jW6h0TE7FqIkTEculuDgLtrEbBw93JaJX1EjBfXkfP/8U W3tLAalLwEtibfRTEwDbvpzkcf2Vu13ns1i7Kl6uKbp2jI/TG7lX2KBeTYEew5u3wMe0VfIKCIy gZPJvW3Kit/I/CCuejAAUc8RW04lyF3VdEpVp4xwh1DnfOZhLgvP6/cF0BP9NCJ0yvHYkHMjsE4 Ub+uPezmX0Res8Hn9Uhx/9fT9lIOCTkvxq6zSOPh2R4Ff0A9cN5ibowi9UKuGkw1RA5SdTA6eAq pDdpVV0ug40BwJ4TdD9vWq5V9yWfsPiyRpRiyC8Jo8226PmWUc3f/x2Qedfu7fDBMh574wTlECn WBk/H2iZUHSojLJ1e8rysNBRBmYn8V4bOwpRoIwA= X-Google-Smtp-Source: AGHT+IHj0+KjptP30CEMP3QJoPZlpnfj4Bq77z8krp11/Q06KK7jsNmNqyCJvsHcZSIM9Am5X49Ljg== X-Received: by 2002:a17:907:3e9f:b0:af9:8748:2bb0 with SMTP id a640c23a62f3a-afdf0272640mr100899066b.10.1755682890670; Wed, 20 Aug 2025 02:41:30 -0700 (PDT) Received: from smtpclient.apple ([188.212.112.125]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-afded478ff9sm145936266b.57.2025.08.20.02.41.29 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 20 Aug 2025 02:41:30 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\)) Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug From: Alban Hertroys In-Reply-To: Date: Wed, 20 Aug 2025 11:41:19 +0200 Cc: Adrian Klaver , "depesz@depesz.com" , PostgreSQL General Content-Transfer-Encoding: quoted-printable Message-Id: <8B89FABB-E020-4EF0-9019-08B1B9E22208@gmail.com> References: To: Scot Kreienkamp X-Mailer: Apple Mail (2.3826.700.81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 19 Aug 2025, at 22:25, Scot Kreienkamp = wrote: >=20 > = =E5=8C=80=E7=A4=80=E6=B8=80=E6=8C=80=E6=A0=80=E7=88=80=E6=BC=80=E6=B8=80=E6= =BC=80=E7=94=80=E7=8C=80=E2=80=80=E6=8C=80=E6=BC=80=E6=B4=80=E6=B4=80=E6=A4= =80=E7=90=80=E3=BC=80=E2=80=80=E2=80=80=E4=BC=80=E7=88=80=E2=80=80=E6=84=80= =E7=8C=80=E7=A4=80=E6=B8=80=E6=8C=80=E6=A0=80=E7=88=80=E6=BC=80=E6=B8=80=E6= =BC=80=E7=94=80=E7=8C=80=E3=BC=80=E0=B4=80=E0=A8=80=E0=B4=80=E0=A8=80=E0=B4= =80=E0=A8=80=E5=8C=80=E6=8C=80=E6=BC=80=E7=90=80=E2=80=80=E4=AC=80=E7=88=80= =E6=94=80=E6=A4=80=E6=94=80=E6=B8=80=E6=AC=80=E6=84=80=E6=B4=80=E7=80=80=E2= =80=80=E7=B0=80=E2=80=80=E4=84=80=E7=80=80=E7=80=80=E6=B0=80=E6=A4=80=E6=8C= =80=E6=84=80=E7=90=80=E6=A4=80=E6=BC=80=E6=B8=80=E7=8C=80=E2=80=80=E4=A4=80= =E6=B8=80=E6=98=80=E7=88=80=E6=84=80=E7=8C=80=E7=90=80=E7=88=80=E7=94=80=E6= =8C=80=E7=90=80=E7=94=80=E7=88=80=E6=94=80=E2=80=80=E4=84=80=E7=88=80=E6=8C= =80=E6=A0=80=E6=A4=80=E7=90=80=E6=94=80=E6=8C=80=E7=90=80=E2=80=80=E7=B0=80= =E2=80=80=E4=B0=80=E6=84=80=E2=B4=80=E5=A8=80=E2=B4=80=E4=88=80=E6=BC=80=E7= =A4=80=E2=80=80=E4=8C=80=E6=BC=80=E7=88=80=E7=80=80=E6=BC=80=E7=88=80=E6=84= =80=E7=90=80=E6=94=80=E0=B4=80=E0=A8=80=E2=A0=80=E3=9C=80=E3=8C=80=E3=90=80= =E2=A4=80=E2=80=80=E3=8C=80=E3=A0=80=E3=90=80=E2=B4=80=E3=98=80=E3=90=80=E3= =80=80=E3=8C=80=E2=80=80=E7=B0=80=E2=80=80=E3=84=80=E2=B4=80=E3=9C=80=E3=8C= =80=E3=90=80=E2=B4=80=E3=A4=80=E3=84=80=E3=94=80=E2=B4=80=E3=84=80=E3=90=80= =E3=90=80=E3=90=80=E2=80=80=E7=B0=80=E2=80=80=E5=8C=80=E6=8C=80=E6=BC=80=E7= =90=80=E2=B8=80=E4=AC=80 This looks like a bug in Outlook (at work) that I ran into over 3 years = ago after enabling beta-support for UTF-8 encoding=E2=80=A6 The fun part = was that the messages looked perfectly fine on my end, but were = gibberish on the receiving ends only. Is that bug still present perhaps? Or is it just my end that turns Scott's (and only Scott's) messages into = gibberish Chinese? Alban Hertroys -- There is always an exception to always.