Wiki / 配置参数

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.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

2

category

Lock Management

context

sighup

documented

true

enumvals

未知

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

未知

vartype

integer