I have a situation where I can see very high Bloat on some of the tables in the system, and the biggest one by factor of 10 or more is always oban_producers (see attached LiveDashboard screenshot)
I suspect this is causing issues: I just had several hours of 100% CPU usage, and autovacuum process was failing to delete any tuples whatsoever from the system.
Oban may not be the root cause of the problem, and it may be an overall misconfigured vacuum settings, that I did not tweak at all (uses whatever Google sets up on their hosted databases).
I have a question: how do I fix that bloat, in least interruptive way? The system is having a lot of users, and a lot of activity, so I would prefer not taking it down for maintenance but could do that over the weekend if needed.
I have limited knowledge of tuning PostgreSQL, and would appreciate any tips.
It may also be something is misconfigured in Oban itself? I am using the Reindexer plugin, but I think the problem is not the indexes but actual bloat on the tables… @sorentwo can you advise?
