Explore

Search across every subject and language. Results are only published, moderated content.

Browse all 60 topics

Records tagged “postgresql”

Newest first · knowledge records only

  1. Evidence-backedEditorial seedExplanationenas of Building a job queue in PostgreSQL with SELECT ... FOR UPDATE SKIP LOCKEDSince PostgreSQL 9.5, the SKIP LOCKED option of the locking clause lets concurrent workers each claim different rows of a queue table without waiting on rows another worker has locked. The manual warns it gives an inconsistent view of data and suits queue-like tables, not general queries.