Wiki / Configuration Parameters

This controls how many pages or tuples of a single relation can be predicate-locked before the lock is promoted to covering the whole relation. Values greater than or equal to zero mean an absolute limit, while negative values mean max_pred_locks_per_transaction divided by the absolute value of this setting. The default is -2, which keeps the behavior from previous versions of PostgreSQL. This parameter can only be set in the postgresql.conf file or on the server command line.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

-2

category

Lock Management

context

sighup

documented

true

enumvals

Unknown

extra desc

If more than this total of pages and tuples in the same relation are locked by a connection, those locks are replaced by a relation-level lock.

lang

en

max val

2147483647

metadata version

18

min val

-2147483648

name

max_pred_locks_per_relation

short desc

Sets the maximum number of predicate-locked pages and tuples per relation.

source

pg-settings-source-snapshot

unit

Unknown

vartype

integer