what is the default idle connection timeout for PostgreSQL, I ran show idle_in_transaction_session_timeout query and returned 0, but the value 0 means this option is disabled, but I want to know what is default idle timeout value in seconds or milliseconds when it is disabled
What is the default idle connection timeout value for PostgreSQL
Viewed 1768
1 Answers
0 means “infinitely long”.
Note that that is not an “idle session timeout”, but a timeout for being idle while a database transaction is open.
A timeout for idle sessions was added in v14 with idle_session_timeout.
Related