Parameters
Lock Management
5 PostgreSQL 18.6 parameters. Each one has its own animation and explanation.
Lock Management
deadlock_timeout: How long to wait on a lock before checking for a deadlock (and logging lock waits).max_locks_per_transaction: Sizes the shared lock table: value × (backends + prepared transactions) entries.max_pred_locks_per_page: After this many tuple predicate locks on one page, use a single page lock instead.max_pred_locks_per_relation: After this many predicate locks in one table, use a single relation lock. Negative = fraction.max_pred_locks_per_transaction: Sizes the shared predicate-lock table used by SERIALIZABLE transactions.