Re: Terminate the idle sessions
От | David G. Johnston |
---|---|
Тема | Re: Terminate the idle sessions |
Дата | |
Msg-id | CAKFQuwaRyr3jOfOTpaiPHYMcXPQkB3enXgP88FRg0jFH_2J_SA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Terminate the idle sessions (Li Japin <japinli@hotmail.com>) |
Ответы |
Re: Terminate the idle sessions
|
Список | pgsql-hackers |
On Mon, Nov 16, 2020 at 5:41 AM Li Japin <japinli@hotmail.com> wrote:
Thanks for your review! Attached.
Reading the doc changes:
I'd rather not name postgres_fdw explicitly, or at least not solely, as a reason for setting this to zero. Additionally, using postgres_fdw within the server doesn't cause issues, its using postgres_fdw and the remote server having this setting set to zero that causes a problem.
<note>
Consider setting this for specific users instead of as a server default. Client connections managed by connection poolers, or initiated indirectly like those by a remote postgres_fdw using server, should probably be excluded from this timeout.
Text within <para> should be indented one space (you missed both under listitem).
I'd suggest a comment that aside from a bit of resource consumption idle sessions do not interfere with the long-running stability of the server, unlike idle-in-transaction sessions which are controlled by the other configuration setting.
David J.
В списке pgsql-hackers по дате отправления: