]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: Add references for SI and SSI.
authorThomas Munro <tmunro@postgresql.org>
Sun, 14 Jun 2020 23:33:13 +0000 (11:33 +1200)
committerThomas Munro <tmunro@postgresql.org>
Mon, 15 Jun 2020 01:20:29 +0000 (13:20 +1200)
commit4c897197d7939d290781edae6bc53f91f5fcb09b
tree02a0c94c6eab59d3557658b2f514b09de65d7ca3
parentdede9a6ada00d4975240e5a60de220124d547a08
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
doc/src/sgml/biblio.sgml
doc/src/sgml/mvcc.sgml