Wiki / Configuration Parameters

Abort any statement that waits longer than the specified amount of time while attempting to acquire a lock on a table, index, row, or other database object. The time limit applies separately to each lock acquisition attempt. The limit applies both to explicit locking requests (such as LOCK TABLE, or SELECT FOR UPDATE without NOWAIT) and to implicitly-acquired locks. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. Unlike statement_timeout, this timeout can only occur while waiting for locks. Note that if statement_timeout is nonzero, it is rather pointless to set lock_timeout to the same or larger value, since the statement timeout would always trigger first. If log_min_error_statement is set to ERROR or lower, the statement that timed out will be logged. Setting lock_timeout in postgresql.conf is not recommended because it would affect all sessions.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

0

category

Client Connection Defaults / Statement Behavior

context

user

documented

true

enumvals

Unknown

extra desc

0 disables the timeout.

lang

en

max val

2147483647

metadata version

18

min val

0

name

lock_timeout

short desc

Sets the maximum allowed duration of any wait for a lock.

source

pg-settings-source-snapshot

unit

ms

vartype

integer