Postgres isolation example & note

• Transaction isolation and read phenomena
  • Chapter 1: ACID property & 4 isolation levels
  • Chapter 2: 4 read phenomena
  • Chapter 3: Relationship between isolation levels and read phenomena
• Others
  • Chapter 4: Selecting for Share and Update
  • Chapter 5: Postgres Store Procedure

Reference

https://www.postgresql.org/docs/current/transaction-iso.html

https://www.postgresql.org/docs/9.1/explicit-locking.html

https://en.wikipedia.org/wiki/Isolation_%28database_systems%29

https://dev.to/techschoolguru/understand-isolation-levels-read-phenomena-in-mysql-postgres-c2e#serialization-anomaly-in-postgres

http://shiroyasha.io/selecting-for-share-and-update-in-postgresql.html