| ▲ | efxhoy 6 days ago | |
I like it! We have a service with a similar postgres task queue but we use an insert trigger on the tasks table that does NOTIFY and the worker runs LISTEN, it feels a bit tidier than polling IMO. | ||
| ▲ | parthdesai 2 hours ago | parent | next [-] | |
Feels tidier till it becomes a bottleneck: https://www.recall.ai/blog/postgres-listen-notify-does-not-s... | ||
| ▲ | surprisetalk 6 days ago | parent | prev [-] | |
LISTEN/NOTIFY works great but they don’t have any mechanism for ACKs or retries so it’s got some tradeoffs to consider. Works great when you’re willing to sacrifice some durability! | ||