| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | depesz(at)depesz(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-19 18:39:03 |
| Message-ID: | d1d40328-ae3a-4089-9ee0-beade92d7c45@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scot Kreienkamp | 2025-08-19 20:09:40 | RE: vacuum analyze query performance - help me understand |
| Previous Message | Tom Lane | 2025-08-19 18:19:56 | Re: vacuum analyze query performance - help me understand |