Doc: Add references for SI and SSI.
authorThomas Munro
Sun, 14 Jun 2020 23:33:13 +0000 (11:33 +1200)
committerThomas Munro
Mon, 15 Jun 2020 01:13:11 +0000 (13:13 +1200)
commiteb1286413c0abfabf51788215186841f5dbb345b
tree63b53c1dd9660aa30389d826062d30b7e8be2b17
parent874372a941a6ee31ba4034db0367e0929e5f49bc
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
Reviewed-by: Andres Freund
Reviewed-by: Peter Geoghegan
Reviewed-by: Tatsuo Ishii
Discussion: https://postgr.es/m/db7b729d-0226-d162-a126-8a8ab2dc4443%40jepsen.io
Discussion: https://postgr.es/m/16454-9408996bb1750faf%40postgresql.org
doc/src/sgml/biblio.sgml
doc/src/sgml/mvcc.sgml