| From: | Kevin Grittner <kgrittn(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Add GUCs for predicate lock promotion thresholds. |
| Date: | 2017-04-08 02:43:00 |
| Message-ID: | E1cwgL6-0001jq-IT@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/c63172d60f242ad3581c83723a5b315bbe547a0e
Modified Files
--------------
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2017-04-08 02:45:51 | pgsql: doc: Add some markup |
| Previous Message | Tom Lane | 2017-04-08 02:20:39 | pgsql: Optimize joins when the inner relation can be proven unique. |