[efxhoy]

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]

Feels tidier till it becomes a bottleneck:

https://www.recall.ai/blog/postgres-listen-notify-does-not-s...

[surprisetalk]

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!