4 ms·
what is the difference between using this library and PG_LISTEN/NOTIFY with triggers for each row change?
by vivzkestrel 2y ago
what is the difference between using this library and PG_LISTEN/NOTIFY with triggers for each row change?
- WJW 2y agoTriggers have much larger overhead than writing to the replication stream (which most databases should be doing anyway), so if you have a lot of traffic this is faster.
- vivzkestrel 2y agosorry but didn't understand, what exactly is this replication stream, are you talking about the wal logs? any ideas why postgres hasn't implemented this natively if it is better?