Wiki / 配置参数

Terminate any session that spans longer than the specified amount of time in a transaction. The limit applies both to explicit transactions (started with BEGIN) and to an implicitly started transaction corresponding to a single statement. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. If transaction_timeout is shorter or equal to idle_in_transaction_session_timeout or statement_timeout then the longer timeout is ignored. Setting transaction_timeout in postgresql.conf is not recommended because it would affect all sessions. Note Prepared transactions are not subject to this timeout.

英文手册覆盖始于 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

transaction_timeout

short desc

Sets the maximum allowed duration of any transaction within a session (not a prepared transaction).

source

pg-settings-source-snapshot

unit

ms

vartype

integer