Re: libpq: Process buffered SSL read bytes to support records >8kB on async API

On Wed, Jul 16, 2025 at 7:36 AM Merlin Moncure <mmoncure(at)gmail(dot)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