Hacker News new | ask | show | jobs
by paulddraper 1106 days ago
It depends whether the events are persistent in nature.

"Debit account $100" is persistent.

"Account balanced changed" is ephermeral.

Storing ephemeral events would be a large amount of overhead; pg_notify is far faster as it does not write to storage or WAL.