Re: Terminate the idle sessions

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Terminate the idle sessions
Дата
Msg-id CAKFQuwaTBdhhii+XV5-M_fdYw1bARTA2pq4twU622+xFE7rT0g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Terminate the idle sessions  (Cary Huang <cary.huang@highgo.ca>)
Список pgsql-hackers
On Mon, Aug 10, 2020 at 2:43 PM Cary Huang <cary.huang@highgo.ca> wrote:
There is currently no enforced minimum value for "idle_session_timeout" (except for value 0 for disabling the feature), so user can put any value larger than 0 and it could be very small like 500 or even 50 millisecond, this would make any psql connection to disconnect shortly after it has connected, which may not be ideal. Many systems I have worked with have 30 minutes inactivity timeout by default, and I think it would be better and safer to enforce a reasonable minimum timeout value

I'd accept a value of say 1,000 being minimum in order to reinforce the fact that a unit-less input, while possible, is taken to be milliseconds and such small values most likely mean the user has made a mistake.  I would not choose a minimum allowed value solely based on our concept of "reasonable".  I don't imagine a value of say 10 seconds, while seemingly unreasonable, is going to be unsafe.

David J.

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

Предыдущее
От: Cary Huang
Дата:
Сообщение: Re: Terminate the idle sessions
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Add LWLock blocker(s) information