PostgreSQL LISTEN/NOTIFY doesn't scale inside transactions
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