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

Поиск
Список
Период
Сортировка
От Jacob Champion
Тема Re: libpq: Process buffered SSL read bytes to support records >8kB on async API
Дата
Msg-id CAOYmi+m4Xv0Ubq3qCinEe_wyUCwRc-c3P=gPC9mqeKcFWfsXXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: libpq: Process buffered SSL read bytes to support records >8kB on async API  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
On Wed, Jul 16, 2025 at 7:36 AM Merlin Moncure <mmoncure@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
oftime, sometimes minutes -- during that time, there would be no activity in the log (the server doesn't do anything
interestingoutside 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



В списке pgsql-hackers по дате отправления: