Re: Built-in connection pooling

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Built-in connection pooling
Дата
Msg-id 20180129001629.GE5022@momjian.us
обсуждение исходный текст
Ответ на Re: Built-in connection pooling  (Ivan Novick <inovick@pivotal.io>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: proposal: alternative psql commands quit and exit
Следующее
От: Amit Langote
Дата:
Сообщение: Re: list partition constraint shape