← Back to context

Comment by cpursley

2 days ago

How did you resolve this? Did you consider listening to the WAL?

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