Wiki / 配置参数

Terminate any session that has been idle (that is, waiting for a client query), but not within an open transaction, for longer than the specified amount of time. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. Unlike the case with an open transaction, an idle session without a transaction imposes no large costs on the server, so there is less need to enable this timeout than idle_in_transaction_session_timeout. Be wary of enforcing this timeout on connections made through connection-pooling software or other middleware, as such a layer may not react well to unexpected connection closure. It may be helpful to enable this timeout only for interactive sessions, perhaps by applying it only to particular users.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

0

category

Client Connection Defaults / Statement Behavior

context

user

documented

true

enumvals

未知

extra desc

0 disables the timeout.

lang

en

max val

2147483647

metadata version

18

min val

0

name

idle_session_timeout

short desc

Sets the maximum allowed idle time between queries, when not in a transaction.

source

pg-settings-source-snapshot

unit

ms

vartype

integer