Queues in PostgreSQL | Citus Con: An Event for Postgres 2022

great talk!

Fantastic talk!! I think the idea of creating a Postgres plugin with native abstractions for high perf queues is a neat one.

“pg-boss” on npm is a great package for enabling Postgres job-queue functionality in Node.

Fantastic talk, thanks for it, Thomas! 👏🏻👏🏻

I'm a big fan of simple and pragmatic solutions, especially using relational databases, and SKIP LOCKED is one of the best features we can find in Postgres and many RDBMS! I love it!

I think the circular scan option works in Oracle with a ROWID predicate.
Did you also look at prefetching (LIMIT 5 with multi stage states)
What about updating a fixed number of records aka slots?