On Wed, Jul 16, 2025 at 7:36 AM Merlin Moncure <mmonc...@gmail.com> wrote: > Agreed. Here's a little more detail on the case I noticed: > > * postgres backend thread managing several libpq connections, with polling > is_busy loop > * when client pushed a lot of log messages (say, with 'RAISE NOTICE'), the > server would stall for significant periods of time, sometimes minutes -- > during that time, there would be no activity in the log (the server doesn't > do anything interesting outside of of the polling loop) > * checking backend server log, which relogs the client raised logs via > dblink, each pause happened after roughly 16k bytes > * reducing the log verbosity made the problem go away.
Thanks for this! I'm not sure I'll be able to prove that this is related, as opposed to some other potential problem, but it's good to have the information. --Jacob
