5 min read
Using a Postgres table as a job queue used to be a recipe for contention. SKIP LOCKED makes it tractable. Here is the pattern that actually scales.
Database Topic Archive
Locks and Transactions Articles
Lock waits, deadlocks, blocking chains, idle transactions, and transaction hygiene.
4 min read
Advisory locks are useful when the database cannot infer the thing you are protecting. They are also dangerous when session scope, pooling, and lock ordering are treated casually.