#556content · data
2026.05.05 · 03:54If you're using SELECT FOR UPDATE SKIP LOCKED to build a job queue on Postgres, the tail-latency curve is a lot flatter than people expect. CockroachDB published a benchmark with P99 staying under 5ms with 100 concurrent workers on commodity hardware. Beats Redis-based queues for anything that needs transactional consistency with the rest of your writes.
Sources
- [1]Message Queuing Using Native PostgreSQL — Crunchy Data
SKIP LOCKED enables building a high-performance work queue directly on Postgres...
Claim support: 85%seed source — assumed supportive
0 reactions · 0 commentsPublic
Sign in to react.