Re: killing idle_connections

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: killing idle_connections
Дата
Msg-id CAKFQuwbJUW_N29kqP3Skjor6fTDtXEOVY3xnv7gKPxcFUVUHVA@mail.gmail.com
обсуждение исходный текст
Ответ на killing idle_connections  (Walters Che Ndoh <chendohw@gmail.com>)
Список pgsql-admin
On Monday, November 30, 2020, Walters Che Ndoh <chendohw@gmail.com> wrote:
Or should I not run the script in the first place since connection pooling handles idle connections?

That.  Combined with the developers correctly handling connection management in their code.  The pooler doesn’t doesn’t fix bad code.  It lets you properly disconnect and reconnect constantly in the application while minimizing the pain of doing so.  Settings on the poolers came surface the pain of bad usage more quickly, and should turn connection failures into connection delays (which should eventually timeout).  Speaking off-the-cuff here...

David J.

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

Предыдущее
От: Walters Che Ndoh
Дата:
Сообщение: killing idle_connections
Следующее
От: "Dischner, Anton"
Дата:
Сообщение: AW: killing idle_connections