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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 16:01:50
Message-ID: aKiUbpOabjw0i2fS@depesz.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 22, 2025 at 11:55:18AM -0400, Tom Lane wrote:
> Nonetheless, I'm suspecting an interaction with the startup process,
> because there just isn't that much else that this process could be
> needing to deal with. Can you try strace'ing both the process doing
> the test query and the startup process, to see what the startup
> process is doing at the times the futex calls happen?

I can, but not today. Will get back to you about it, next week, though.

Best regards,

depesz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Luzanov 2025-08-25 12:21:47 Re: Q: GRANT ... WITH ADMIN on PG 17
Previous Message Tom Lane 2025-08-22 15:55:18 Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug