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?
ruclips.net/video/WIRy1Ws47ic/видео.html "The key thing would be to find a way to integrate with transactions. That's where all the benefit of using a database for your queue comes."
“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!
Fantastic talk!! I think the idea of creating a Postgres plugin with native abstractions for high perf queues is a neat one.
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?
great talk!
ruclips.net/video/WIRy1Ws47ic/видео.html "The key thing would be to find a way to integrate with transactions. That's where all the benefit of using a database for your queue comes."
very insightful, thank you Thomas (@MengTangmu) .