News for hackers. Stuff that matters.
Re:Turning PostgreSQL into a queue serving 10k jobs per seco... by wjd2030 on Thursday November 14, 2019 @07:15PM (#21541044)
Exactly. It is so easy to achieve using a dedicated queuing system. You could just as easily achieve much higher throughput by passing a jobId as a message to Rabbit and have the worker pop the required data out of the db. Thats assuming you dont want to just pass in a serialized object. All this talk of it not being a durable system is just wrong. Rabbit has strong durability guarantees across a cluster with queue mirroring, confirmations and acknowledgements.
Re:Turning PostgreSQL into a queue serving 10k jobs per seco... by ukd1 on Friday November 15, 2019 @02:05AM (#21542892)
Rabbit and most others do; but only once it reaches the queue itself. The problem that using a fb to queue stuff gets around is guaranteeing it earlier; your changes to database and the queued messages are either all committed, or not - a single transaction. This is hard to impossible with queues outside a dB. However obviously it’s a trade off; it’s slower, it’s more work and connections to your dB. But, you don’t have to code around messages either never sent it from a later rolled back transaction.