Add GUCs for predicate lock promotion thresholds

Enterprise / PostgreSQL - Kevin Grittner [postgresql.org] - 7 April 2017 22:38 EDT

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

c63172d Add GUCs for predicate lock promotion thresholds.
doc/src/sgml/config.sgml | 36 ++++++++++++++++++++
doc/src/sgml/mvcc.sgml | 4 ++-
src/backend/storage/lmgr/predicate.c | 48 +++++++++++++++++----------
src/backend/utils/misc/guc.c | 22 ++++++++++++
src/backend/utils/misc/postgresql.conf.sample | 4 +++
src/include/storage/predicate.h | 2 ++
6 files changed, 98 insertions(+), 18 deletions(-)

Upstream: git.postgresql.org


  • Share