pgsql: Doc: Add references for SI and SSI.

From: Thomas Munro <tmunro(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: Add references for SI and SSI.
Date: 2020-06-15 01:27:45
Message-ID: E1jkdub-0005sR-Uj@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jepsen(dot)io>
Reviewed-by: Andres Freund <andres(at)anarazel(dot)de>
Reviewed-by: Peter Geoghegan <pg(at)bowt(dot)ie>
Reviewed-by: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Discussion: https://postgr.es/m/db7b729d-0226-d162-a126-8a8ab2dc4443%40jepsen.io
Discussion: https://postgr.es/m/16454-9408996bb1750faf%40postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1575fbf1ac3c8464b2dade245deff537a3aa2498

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

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2020-06-15 01:28:07 pgsql: Doc: Add references for SI and SSI.
Previous Message Tom Lane 2020-06-14 15:00:11 pgsql: Fix behavior of exp() and power() for infinity inputs.