idle_session_timeout
No restart — settable per sessiontuned by pgconfiguratorPostgreSQL 14+time (ms); 0 disables
Closes sessions that sit idle (not in a transaction) for too long.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
Added in PostgreSQL 14, this disconnects a session that's been idle (outside any transaction) longer than the timeout, freeing its backend and memory. Unlike the in-transaction variant, an idle non-transaction session isn't holding locks — so this is about reclaiming connection slots, not preventing bloat.
How to tune it
Useful to reap leaked or abandoned connections, but be careful with connection poolers — they keep idle connections deliberately, so a short timeout fights the pool. Often better applied to direct/interactive roles than to pooled app roles.