Horton
Menu

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

hubert depesz lubaczewski <depesz@depesz.com>

View thread
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, PostgreSQL General <pgsql-general@lists.postgresql.org>, Chris Wilson <chris+google@qwirx.com>
Date: 2025-08-22T16:01:50Z
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