Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

what is the difference between using this library and PG_LISTEN/NOTIFY with triggers for each row change?


Triggers 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.


sorry 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?




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: