deadlock_timeout

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

deadlock_timeout

The time to wait on a lock before checking to see if there is a deadlock condition. On a heavily loaded server you might want to raise this value. Ideally the setting should exceed your typical transaction time, so as to improve the odds that a lock will be released before the waiter decides to check for deadlock.

Value Range Default Set Classifications
Any valid time expression (number and unit) 1s local

system

restart