Postgres LISTEN/NOTIFY locks the whole DB and kills scale
Recall.ai’s high‑write workload crashed when thousands of bots issued NOTIFY inside transactions. The feature acquires a global lock during commit, serializing all writes and causing severe bottlenecks. The fix landed in PostgreSQL core, but the incident warns against using LISTEN/NOTIFY for massive concurrent writers.