Optimistic and pessimistic concurrency control

Here we consider two most widely used approaches to transactional locking: pessimistic and optimistic locking.

PostgreSQL transaction isolation levels

Details of transaction isolation in PostgreSQL.

Transaction isolation levels

Transaction isolation levels in relational databases. A reminder post.