Terminate the idle sessions

Japin Li <japinli@hotmail.com>

From: Li Japin <japinli@hotmail.com>

To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2020-06-09T09:02:42Z

Lists: pgsql-hackers

Attachments

0001-Allow-terminating-the-idle-sessions.patch (application/octet-stream) patch 0001

Hi, hackers

When some clients connect to database in idle state, postgres do not close the idle sessions,
here i add a new GUC idle_session_timeout to let postgres close the idle sessions, it samilar
to idle_in_transaction_session_timeout.

Best, regards.

Japin Li

Commits

Rethink SQLSTATE code for ERRCODE_IDLE_SESSION_TIMEOUT.
- 4edf96846a02 14.0 landed
Improve commentary in timeout.c.
- 9486e7b666fd 14.0 landed
Add idle_session_timeout.
- 9877374bef76 14.0 landed
Improve timeout.c's handling of repeated timeout set/cancel.
- 09cf1d522676 14.0 landed