I have some tables that I do a lot of updates, deletes and inserts. So I am worried that my cluster can grow up to a huge size... The best option would be to create a scheduled process to check if it is bloated and if so, reindex?
--------------------------
Depends on whether it's table bloat or index bloat. But first, you try to minimize bloat by tuning autovacuum. Igor Neyman
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the problem is index bloat, autovaccum won't be a solution, am I right?