(www.recall.ai)

570 points davidgu | 2 comments | 07 Jul 25 14:05 UTC | HN request time: 0.001s | source

1. supportengineer ◴[10 Jul 25 20:52 UTC] No.44525481[source]▶

LISTEN/NOTIFY isn’t just a lock-free trigger. It can jeopardize concurrency under load.

Features that seem harmless at small scale can break everything at large scale.

2. edoceo ◴[11 Jul 25 00:04 UTC] No.44527072[source]▶

It's true and folk should also choose the right tool at their scale and monitor it. There are plenty of cases where LISTEN/NOTIFY is the right choice.

However, in 2025 I'd pick Redis or MQTT for this kind of role. I'm typically in multi-lamg environments. Is there something better?

↑

Postgres LISTEN/NOTIFY does not scale