Using Postgres as a queue: where it breaks
It works surprisingly far. The failure mode is not throughput, it is bloat.
`SELECT ... FOR UPDATE SKIP LOCKED` is enough for a surprising amount of work. Teams get to millions of jobs a day before anything looks wrong.
Subscriber story
Continue reading with a subscription
This piece is part of the subscriber archive. Subscribe to the daily brief for full access — one email, no card, cancel any time.
Already a subscriber?
#testing#databases#maintenance
More in this section
🔒softwareSubscriber
The quiet return of single-file binaries
Static linking is fashionable again. The reasons are less about performance and more about deployment fatigue.
software
A minimal CI pipeline in 200 lines
No plugins, no marketplace, no YAML sprawl. Just a runner, a queue, and honest logging.
🔒softwareSubscriber
Editorial: your dependency tree is a supply chain
Treat it like one — pin, audit, mirror, and stop trusting transitive installs by default.