A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
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