Postgres LISTEN/NOTIFY Actually Scales
- Postgres LISTEN/NOTIFY has a bad reputation thanks in part to a popular blog post asserting it does not scale.
- If that were true, it would be a shame, because LISTEN/NOTIFY is a powerful tool, allowing you to use your Postgres database for low-latency durable notifications, streams, and pub/sub.
- The accusations aren’t wrong: NOTIFY has unintuitive and undocumented performance characteristics arising from its use of a global lock.
Unverified
- Postgres LISTEN/NOTIFY has a bad reputation thanks in part to a popular blog post asserting it does not scale.
- If that were true, it would be a shame, because LISTEN/NOTIFY is a powerful tool, allowing you to use your Postgres database for low-latency durable notifications, streams, and pub/sub.
- The accusations aren’t wrong: NOTIFY has unintuitive and undocumented performance characteristics arising from its use of a global lock.
Sources: Dbos