Tag: locking Basic
This content is a draft and will not be included in production builds.
11 articles tagged locking:
- Advisory locks: locking a business key when there is no row to lock
- Deadlocks in PostgreSQL: causes, reading the log, fixes
- Lock queue: why one waiting ALTER TABLE makes every SELECT queue up
- Lock timeouts and monitoring: finding the blocking session and capping wait time
- 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
- Row-level locks in PostgreSQL: FOR UPDATE, FOR NO KEY UPDATE, and preventing double booking
- Scale Lab — Interview problem: concert ticketing
- Scenario: a migration locks the orders table
- Table-level locks in PostgreSQL: which DDL blocks even SELECT on a live table