pgsql: Doc: Add references for SI and SSI. - Mailing list pgsql-committers

From Thomas Munro
Subject pgsql: Doc: Add references for SI and SSI.
Date
Msg-id E1jkdvE-0005th-0T@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: Add references for SI and SSI.

Our documentation failed to point out that REPEATABLE READ is really
snapshot isolation, which might be important to some users.  Point to
the standard reference paper for this complicated topic.

Likewise, add a reference to the VLDB paper about PostgreSQL SSI, for
technical information about our SSI implementation and how it compares
to S2PL.

While here, add a note about catalog access using a lower isolation
level, per recent user complaint.

Back-patch to all releases.

Reported-by: Kyle Kingsbury <aphyr@jepsen.io>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Peter Geoghegan <pg@bowt.ie>
Reviewed-by: Tatsuo Ishii <ishii@sraoss.co.jp>
Discussion: https://postgr.es/m/db7b729d-0226-d162-a126-8a8ab2dc4443%40jepsen.io
Discussion: https://postgr.es/m/16454-9408996bb1750faf%40postgresql.org

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/eb1286413c0abfabf51788215186841f5dbb345b

Modified Files
--------------
doc/src/sgml/biblio.sgml | 58 ++++++++++++++++++++++++++++++++++++++++++++++++
doc/src/sgml/mvcc.sgml   | 33 +++++++++++++++++++++++++++
2 files changed, 91 insertions(+)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Doc: Add references for SI and SSI.
Next
From: Thomas Munro
Date:
Subject: pgsql: Doc: Add references for SI and SSI.