#transactions

Optimistic vs pessimistic locking: how to choose

Two requests touch the same row and one update silently disappears. How version checks, SELECT FOR UPDATE and retry loops behave in production, and how to pick between them.