Comment by cpursley 7 months ago How did you resolve this? Did you consider listening to the WAL? 4 comments cpursley Reply sorentwo 7 months ago We 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 7 months 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 7 months ago In app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though. parthdesai 7 months ago Distributed Erlang if application is clustered, redis if it is not.Source: Dev at one of the companies that hit this issue with Oban
sorentwo 7 months ago We 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 7 months 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 7 months ago In app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though.
MuffinFlavored 7 months 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 7 months ago In app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though.
sorentwo 7 months ago In app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though.
parthdesai 7 months ago Distributed Erlang if application is clustered, redis if it is not.Source: Dev at one of the companies that hit this issue with Oban
We 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.
> Another important change was removing insert triggers, partially for the exact reasons mentioned in this post.
What did you replace them with instead?
In app notifications, which can be disabled. Our triggers were only used to get subsecond job dispatching though.
Distributed Erlang if application is clustered, redis if it is not.
Source: Dev at one of the companies that hit this issue with Oban