4 ms·

Is this better than postgres's native NOTIFY?

• kiwicopple 7y ago
  I actually started with NOTIFY but the payload has a limit of 8000 bytes. Postgres throws an error for anything longer.
• manigandham 7y ago
  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.