Doc: Add references for SI and SSI.
Thomas Munro <tmunro@postgresql.org>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/biblio.sgml | modified | +58 −0 |
| doc/src/sgml/mvcc.sgml | modified | +33 −0 |
Documentation touched
Discussion
- Potential G2-item cycles under serializable isolation 77 messages · 2020-06-01 → 2020-06-15
- BUG #16454: Mixed isolation levels inside transactions 5 messages · 2020-05-21