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