← recall

max_locks_per_transaction term

Postgres setting limiting locks per transaction

Default 64. Each backend reserves max_locks_per_transaction × (max_connections + max_prepared_transactions) slots in shared memory. Exhausting causes 'out of shared memory' errors.

aliases: lock limit, max locks

topics: databases, postgres

references:

• Postgres — Lock Management config