Re: killing idle_connections - Mailing list pgsql-admin

From David G. Johnston
Subject Re: killing idle_connections
Date
Msg-id CAKFQuwbJUW_N29kqP3Skjor6fTDtXEOVY3xnv7gKPxcFUVUHVA@mail.gmail.com
Whole thread Raw
In response to killing idle_connections  (Walters Che Ndoh <chendohw@gmail.com>)
List 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 by date:

Previous
From: Walters Che Ndoh
Date:
Subject: killing idle_connections
Next
From: "Dischner, Anton"
Date:
Subject: AW: killing idle_connections