Short-Form Reference

Notes

Focused explanations of one engineering mechanism at a time, including the problem it solves, the guarantees it provides, and the boundary it cannot cross.

26 Mar 2026
Postgres SKIP LOCKED for Work Queues
SELECT ... FOR UPDATE SKIP LOCKED can support a modest Postgres work queue: workers claim rows without blocking, while leases, fencing, retries, and indexes provide the recovery behavior.