PDA

View Full Version : Vacuum Full vs. Autovacuum



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?

payday
02-21-2011, 11:56 AM
No postgres or HM database expert here, who can answer my question?

netsrak
02-22-2011, 05:44 AM
For me the auto-vacuum never worked sufficient. I run additional vacuum/full.
But this is only required if you import a lot of mined hands and purge them.

You should try out what gives the best results for you.
I think for performance a reindex of the database (also in pgadmin->maintenance) is something you should run regularly.