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

From Adrian Klaver
Subject Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Date
Msg-id d1d40328-ae3a-4089-9ee0-beade92d7c45@aklaver.com
Whole thread Raw
In response to Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses RE: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
List pgsql-general
On 8/19/25 10:21, hubert depesz lubaczewski wrote:
> Hi,
> we have following situation: Pg 14.17 (yes, I know, but it can't be
> upgraded now/soon), on Ubuntu focal, in AWS cloud on EC2 server using
> arm64 architecture.
> 
> All works, is fine.
> 
> Every now and then (usually every 3-5 minutes, but not through the whole
> day), we see situations where every query suddently takes ~ 1 second.
> 

Given the subject line, what you are reporting is happening on the 
replica, correct?

If so where is the replica relative to the primary, in terms of network 
distance?

Also what are the 'hardware' specifications on the replica instance?


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuum analyze query performance - help me understand
Next
From: Scot Kreienkamp
Date:
Subject: RE: vacuum analyze query performance - help me understand