| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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>, Chris Wilson <chris+google(at)qwirx(dot)com> |
| Subject: | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |
| Date: | 2025-08-22 15:21:22 |
| Message-ID: | 1882312.1755876082@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> I got repeatable case today. Is is breaking on its own everyy
> ~ 5 minutes.
Interesting. That futex call is presumably caused by interaction
with some other process within the standby server, and the only
plausible candidate really is the startup process (which is replaying
WAL received from the primary). There are cases where WAL replay
will take locks that can block queries on the standby. Can you
correlate the delays on the standby server with any DDL events
occurring on the primary?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2025-08-22 15:30:22 | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |
| Previous Message | hubert depesz lubaczewski | 2025-08-22 15:19:33 | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |