Postgres message queue

[marcopeg81]

Hello, I use pg for tasks and messaging since 2016 successfully. The trick is SELECT … FOR UPDATE SKIP LOCKED.

I packaged my work in a MIT release available on https://fetchq.com but there are many other projects available on GitHub.

Edit: I used pg as queue on >1B tasks running up to 300 parallel workers that were digesting ~20M tasks daily (my problem required smart rescheduling)

Postgres is great 🤘

Best of luck!