2 ms·
NOTIFY also can be used this way.
by cryptonector 4y ago
NOTIFY also can be used this way.
- klysm 4y agoNotify is really hard to use correctly, and I think logical replication works better in most cases
- semiquaver 4y agoCorrect me if I’m wrong but even though NOTIFY is transactional, it isn’t persisted to WAL or anywhere else —- so any clients that were not LISTENing at the time NOTIFY was called cannot receive it retroactively. WAL is, well, a log which has nicer properties for many applications that allow clients to “fall behind” or recover from transient network disconnects without losing data.