4 ms·
They do not need to be on the same connection, but LISTEN will need its own dedicated connection that is kept alive, it shouldn’t be drawn from the connection p
by DrJokepu 7y ago
They do not need to be on the same connection, but LISTEN will need its own dedicated connection that is kept alive, it shouldn’t be drawn from the connection pool. Very useful if you want to send messages only and exactly once a transaction is committed.
- exabrial 7y agoLet's say you have apps that cache rows with the pk as the cache key. You could notify your app servers that you changed a row and they should drop it from their cache... for instance.
- DrJokepu 7y agoOr tell the web server to push out the updated version of the record to browsers via web sockets. Very useful feature.