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 shared lock table is created with room to describe locks on max_locks_per_transaction * (max_connections + max_prepared_transactions) objects, so no more than this many distinct objects can be locked at any one time. This is not a hard limit on the number of locks taken by any one transaction, but rather a maximum average value. You might need to raise this value if you have clients that touch many different tables in a single transaction.

Value Range Default Set Classifications
integer 128 local