|
|
|
|
|
by AlexITC
998 days ago
|
|
I have been involved in a few projects using postgres-bakend queues for a few years, scale hasn't been a problem so far. On the other hand, I have done a few experiments with postgres LISTEN/NOTIFY, while the feature seems nice at first glance, I concluded that it wasn't worth it for our use cases, maybe it is different in other languages but in the JVM, you have to allocate 1-thread for polling these results, which also keeps a connection busy. What I ended up doing is leveraging akka-stream to stream the queue data directly from the db, which makes it simple to define throttling rules, this is super simple and effective. |
|