3 ms·

NOTIFY just sends a pub/sub message. You still need a trigger or something else to actually call it on updates, and it has payload size limits.

• jtdev 7y ago
  Like...a trigger?
  • Tostino 7y ago
    Yeah...triggers can have significant overhead though while sending a WAL stream to another server which will process it is super low overhead.