Hello all, I inherited a 8.1.x database of size 200GB. This database hasn't been maintained much (autovac is enabled though).
I been trying to VACUUM this db for the past few days for a couple of hours/day. The server runs 24x7 so continuous maintenance is not possible (this is the last resort). My questions are, > Is it possible to estimate how long VACUUM on a table might take? > The table size is growing as "VACUUM" is being performed. I assume I need reindex after VACUUM is complete. > I run VACUUM from psql and I Ctrl-C it to turn it off is this acceptable? > maintenance_work_mem is at 64MB and shared_buffers at 2GB. Should I dedicate more memory to maintenance_work_mem to speedup VACUUM? The server is a Intel Xeon 3.0GHz with 4GB RAM and RAID-5 (Yes I know). Thanks in advance, Steve