PostgreSQL LISTEN/NOTIFY doesn't scale inside transactions
0.00 truth stake not refunded
2.00 submission fee refunded
2.00 response cost
truth stake
0.00 lost from falsity
submission cost paid to comments
0.00/2.00 paid
submission cost earned by comments
0.00 earned
raised from comments
0.00 raised
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