3 ms·
Another one of these! It's interesting how many times this has been made and abandoned and made again. https://wiki.postgresql.org/wiki/PGQ_Tutorial https://w
by ltbarcly3 2y ago
Another one of these! It's interesting how many times this has been made and abandoned and made again.
https://wiki.postgresql.org/wiki/PGQ_Tutorial https://wiki.postgresql.org/wiki/PGQ_Tutorial
https://github.com/florentx/pgqueue https://github.com/florentx/pgqueue
https://github.com/cirello-io/pgqueue https://github.com/cirello-io/pgqueue
Hundreds of them! We have a home grown one called PGQ at work here also.
It's a good idea and easy to implement, but still valuable to have implemented already. Cool project.
- mattbillenstein 2y agoHa, I wrote one too - https://github.com/mattbillenstein/pg-queue/blob/main/pg-queue.sql https://github.com/mattbillenstein/pg-queue/blob/main/pg-que... Roughly follows the semantics of beanstalkd which I used once upon a time and quite liked.
- arecurrence 2y agoYeah, I've written a few of these and should probably release a package at some point but each version has been somewhat domain specific. The last time we measured an immediate 99% performance improvement over SNS+SQS. It was so dramatic that we were able to reduce job resources simply due to the queue implementation change. There's a lot of useful and almost trivial features you can throw in as well. SQS hasn't changed much in a long time.
- deleted 2y ago[deleted]