title: Configure Idle Connection Timeoutsimpact: HIGHimpactDescription: Reclaim 30-50% of connection slots from idle clientstags: connections, timeout, idle, resource-management配置空闲连接超时空闲连接浪费资源。配置超时可以自动回收它们。错误做法连接无限期保持-- 未配置超时showidle_in_transaction_session_timeout;-- 0已禁用-- 连接永远保持打开即使处于空闲状态selectpid,state,state_change,queryfrompg_stat_activitywherestateidle in transaction;-- 显示事务空闲数小时并持有锁正确做法自动清理空闲连接-- 终止处于事务中空闲超过 30 秒的连接altersystemsetidle_in_transaction_session_timeout30s;-- 终止完全空闲超过 10 分钟的连接altersystemsetidle_session_timeout10min;-- 重新加载配置selectpg_reload_conf();对于池化连接请在池化器层面配置# pgbouncer.ini server_idle_timeout 60 client_idle_timeout 300参考连接超时