On Sun, Jan 28, 2018 at 03:11:25PM -0800, Ivan Novick wrote: > > The simplest thing sounds like a GUC that will automitcally end a connection > > > idle for X seconds. > > Uh, we already have idle_in_transaction_session_timeout so we would just > need a simpler version. > > > Oh i see its in 9.6, AWESOME!
In summary, the good news is that adding an idle-session-timeout GUC, a max_connections limit hit cancels idle connections GUC, and a GUC for idle connections to reduce their resource usage shouldn't be too hard to implement and will provide useful benefits. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +