-
PostgreSQL Deep dive: serializable snapshot isolation — how PostgreSQL prevents write skew without traditional locking
PostgreSQL Deep DivePostgreSQLserializableSSIMVCCconcurrencypredicate-lockswrite-skewtransactions -
PostgreSQL Deep dive: MVCC, xmin, xmax — how Postgres really decides what you can see
PostgreSQL Deep DivePostgreSQLMVCCperformanceinternalsconcurrencydatabase