mowings/readme.md

Last active August 14, 2021 14:52

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mowings/5e8f1b698eaa82ea185d86d1e2b5cbbf.js"></script>
Save mowings/5e8f1b698eaa82ea185d86d1e2b5cbbf to your computer and use it in GitHub Desktop.

Postgresql Queues

Raw

Use UPDATE SKIP LOCKED to manage queue concurrency

DELETE FROM queue
WHERE itemid = (
  SELECT itemid
  FROM queue
  ORDER BY itemid
  FOR UPDATE SKIP LOCKED
  LIMIT 1
)
RETURNING *;

Select an option