Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Date: 2025-08-20 17:24:29
Message-ID: D79F4468-F335-46C5-95E9-4368D0121CA2@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 20, 2025, at 10:08 AM, hubert depesz lubaczewski <depesz(at)depesz(dot)com> wrote:
>
> On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
>> Hmm.
>>
>> From initial post:
>>
>> "For ~ 1 second there are no logs going to log (we usually have at 5-20
>> messages logged per second), no connection, nothing. And then we get
>> bunch (30+) messages with the same milisecond time."

Is that logger ms or db server ms? The latter seems unlikely to me.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message KK CHN 2025-08-20 17:25:56 MS SQL to Postgres
Previous Message David G. Johnston 2025-08-20 17:01:30 Re: Domains vs data types