Performance / Article
Job queues per tenant in PostgreSQL: the noisy neighbour | Now-Next
The article measures FIFO and per-tenant round-robin dequeue with FOR UPDATE SKIP LOCKED on PostgreSQL 17.10, reporting small-tenant wait times and a query-plan regression on a skewed backlog. It explains how a sub-select ordering choice drove dequeue latency from milliseconds to about ten seconds until a matching partial index was added.
Read the originalWhy it’s in the collection
Directly actionable for anyone building a multi-tenant queue, since it shows the query shape and index needed to avoid the planner trap.
THE CONVERSATION
Found on Hacker News 1
Links lead to the original story or comment where this resource appeared. Titles identify the surrounding discussion.