Tag: concurrency Basic
This content is a draft and will not be included in production builds.
12 articles tagged concurrency:
- Advisory locks: locking a business key when there is no row to lock
- Anomalies when many transactions read and write together, and how to fix each one
- Distributed locks with Redis: what if the lock expires while the owner is still running?
- Matching: pick a lock or isolation level for each situation
- NOWAIT and SKIP LOCKED: distributing jobs across workers
- Optimistic or pessimistic locking: choose by conflict rate and think time
- Pipelining, MULTI/EXEC and Lua: when is a sequence of Redis commands truly atomic?
- Row-level locks in PostgreSQL: FOR UPDATE, FOR NO KEY UPDATE, and preventing double booking
- Scenario: a flash sale oversells inventory
- Upsert with ON CONFLICT: "insert if missing, update if present" without error 23505
- What does "Redis is single-threaded" mean when there are I/O threads?
- Writing transactions in code: keeping data correct when many requests run at once