diff options
| author | Kevin Grittner <kgrittn@postgresql.org> | 2017-04-07 21:38:05 -0500 |
|---|---|---|
| committer | Kevin Grittner <kgrittn@postgresql.org> | 2017-04-07 21:38:05 -0500 |
| commit | c63172d60f242ad3581c83723a5b315bbe547a0e (patch) | |
| tree | 0a98686f027aacecb01869bfb269ebd486ea3ba7 /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 9c7f5229ad68d7e0e4dd149e3f80257893e404d4 (diff) | |
| download | postgresql-c63172d60f242ad3581c83723a5b315bbe547a0e.tar.gz postgresql-c63172d60f242ad3581c83723a5b315bbe547a0e.zip | |
Add GUCs for predicate lock promotion thresholds.
Defaults match the fixed behavior of prior releases, but now DBAs
have better options to tune serializable workloads.
It might be nice to be able to set this per relation, but that part
will need to wait for another release.
Author: Dagfinn Ilmari Mannsåker
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 8a93bdcb3f0..512be0a92ed 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -593,6 +593,10 @@ # (change requires restart) #max_pred_locks_per_transaction = 64 # min 10 # (change requires restart) +#max_pred_locks_per_relation = -2 # negative values mean + # (max_pred_locks_per_transaction + # / -max_pred_locks_per_relation) - 1 +#max_pred_locks_per_page = 2 # min 0 #------------------------------------------------------------------------------ |