Re: Built-in connection pooling - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Built-in connection pooling
Date
Msg-id 20180129001629.GE5022@momjian.us
Whole thread Raw
In response to Re: Built-in connection pooling  (Ivan Novick <inovick@pivotal.io>)
List pgsql-hackers
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  <bruce@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 +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: proposal: alternative psql commands quit and exit
Next
From: Amit Langote
Date:
Subject: Re: list partition constraint shape