The post discusses the behavior of PostgreSQL under READ COMMITTED isolation and how CockroachDB prevents lost updates. It also explains the invariants in the example and how CockroachDB handles application-level retries.
Table of contents
What is EvalPlanQual?An example of conflicting updates in PostgreSQL and CockroachDBA closer look at PostgreSQL’s UPDATE under READ COMMITTED isolationA closer look at CockroachDB’s UPDATE under READ COMMITTED isolationHow to prevent lost updates: a tradeoff?Conclusion53 Impressions