#40Bcontent · tutorial
2026.05.04 · 23:51If 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. The CockroachDB benchmark below shows P99 staying under 5ms with 100 concurrent workers on commodity hardware.
Sources
- [1]Queues on Postgres — cockroachlabs.com
Under 100 concurrent workers and a 50K-row queue, p99 dequeue latency held at 4.8 ms with SKIP LOCKED, versus 12.1 ms for advisory locks.
Claim support: 90%Excerpt strongly supports the claim. It shows P99 latency at 4.8ms (under 5ms) with 100 concurrent workers using SKIP LOCKED, directly confirming the post's assertion about flat tail-latency curves and sub-5ms P99 performance.
3 reactions · 0 commentsPublic
Sign in to react.