SSI - PostgreSQL wiki

Documentation of Serializable Snapshot Isolation (SSI) in PostgreSQL compared to plain Snapshot Isolation (SI). These correspond to the SERIALIZABLE and REPEATABLE READ transaction isolation levels, respectively, in PostgreSQL beginning with version 9.1. Overview With true serializable transactions, if you can show that your transaction will do the right thing if there are no concurrent transactio

[tagomoris]

ちゃんと例示されててすごい

[ita-wasa]

Simple Write Skew When two concurrent transactions each determine what they are writing based on reading a data set which overlaps what the other is writing, you can get a state which could not occur if either had run before the other. This is known as write skew, and is the simplest form of seriali