4 ms·
How did you resolve this? Did you consider listening to the WAL?
by cpursley 1y ago
How did you resolve this? Did you consider listening to the WAL?
- sorentwo 1y agoWe have Postgres based pubsub, but encourage people to use a distributed Erlang based notifier instead whenever possible. Another important change was removing insert triggers, partially for the exact reasons mentioned in this post.
- MuffinFlavored 1y ago> Another important change was removing insert triggers, partially for the exact reasons mentioned in this post. What did you replace them with instead?
- sorentwo 1y agoIn app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though.
- parthdesai 1y agoDistributed Erlang if application is clustered, redis if it is not. Source: Dev at one of the companies that hit this issue with Oban