if you have a table with a terabyte size, and it turns out that autovacuum is not catching up, then we suggest manual vacuum by ignoring Index Cleanup and truncate on the internal vacuum process. VACUUM (INDEX_CLEANUP OFF, TRUNCATE OFF) <tablename>; You can use the command above, with the benefits and cons of each, of course Our focus is to speed up the vacuum process so that the database can be used (written) quickly. but after that, we recommend running a regular vacuum to maintain performance
