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?
ua-cam.com/video/WIRy1Ws47ic/v-deo.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."
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!
“pg-boss” on npm is a great package for enabling Postgres job-queue functionality in Node.
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!
ua-cam.com/video/WIRy1Ws47ic/v-deo.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) .