Wiki / Configuration Parameters

This controls how many rows on a single page can be predicate-locked before the lock is promoted to covering the whole page. The default is 2. 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 number of tuples on the same page are locked by a connection, those locks are replaced by a page-level lock.

lang

en

max val

2147483647

metadata version

18

min val

0

name

max_pred_locks_per_page

short desc

Sets the maximum number of predicate-locked tuples per page.

source

pg-settings-source-snapshot

unit

Unknown

vartype

integer