Add idle_session_timeout.
Tom Lane <tgl@sss.pgh.pa.us>
Add idle_session_timeout. This GUC variable works much like idle_in_transaction_session_timeout, in that it kills sessions that have waited too long for a new client query. But it applies when we're not in a transaction, rather than when we are. Li Japin, reviewed by David Johnston and Hayato Kuroda, some fixes by me Discussion: https://postgr.es/m/763A0689-F189-459E-946F-F0EC4458980B@hotmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +44 −7 |
| src/backend/storage/lmgr/proc.c | modified | +1 −0 |
| src/backend/tcop/postgres.c | modified | +41 −7 |
| src/backend/utils/errcodes.txt | modified | +1 −0 |
| src/backend/utils/init/globals.c | modified | +1 −0 |
| src/backend/utils/init/postinit.c | modified | +10 −0 |
| src/backend/utils/misc/guc.c | modified | +12 −1 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −0 |
| src/include/miscadmin.h | modified | +1 −0 |
| src/include/storage/proc.h | modified | +1 −0 |
| src/include/utils/timeout.h | modified | +2 −1 |
Documentation touched
Discussion
- Terminate the idle sessions 52 messages · 2020-06-09 → 2021-01-13