On: Show HN: An SQS Alternative on Postgres

[ltbarcly3]

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://github.com/florentx/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.

[arecurrence → ltbarcly3]

Yeah, 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.

[mattbillenstein → ltbarcly3]

Ha, I wrote one too - 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.