I have one big bloated table (real data size approx 65 Gb, 140 Gb on disk). Vacuum does not work cause of low space on default tablespace disk. So I want to clean the database from trash by moving fat tables to another tablespace, vacuuming them and returning back.
Can I do it safely while not turning off services working with that table? It is around 15 separate one row inserts and ~7 select operations per minute.
And few more insignificant questions:
- What manuals/guides or parameters settings would you advice for autovacuuming table, that works in such load.
- Is it better to pass old data delete operations with frequency of inserts or delete big stacks of rows (every day,week, month,etc..)?