PostgreSQL LISTEN/NOTIFY doesn't scale inside transactions
2 wow
| by anon
62 days ago
PostgreSQL LISTEN/NOTIFY doesn't scale inside transactions because it acquires a global lock on all databases within the postgres instance.
Explained in https://www.recall.ai/blog/postgres-listen-notify-does-not-scale