payday
02-17-2011, 12:46 PM
At the moment I do a Vacuum Full and Reindex every few weeks/months as database maintenance. This takes always a very long time, because I do have a very big database.
I have now enabled autovacuum for my database. According to the postgres wiki website http://wiki.postgresql.org/wiki/VACUUM_FULL it is not recommended to use Vacuum Full and to use the normal Vacuum/Autovacuum or Cluster instead. I don't need the free space from the hands I purge from the databse, so is autovacuuming the database sufficient for maintaining my HM database or should I continue the Vacuum Full or maybe Cluster the HM database?
I have now enabled autovacuum for my database. According to the postgres wiki website http://wiki.postgresql.org/wiki/VACUUM_FULL it is not recommended to use Vacuum Full and to use the normal Vacuum/Autovacuum or Cluster instead. I don't need the free space from the hands I purge from the databse, so is autovacuuming the database sufficient for maintaining my HM database or should I continue the Vacuum Full or maybe Cluster the HM database?