Avatar

Employee Advisor

Hi Lain,

 

Running a full vacuum is a necessary maintenance step when using a PostGres database. That said, how often you run the vacuum and the benefit that you will see from it depends upon the amount of bloat in your system. Depending on the size of your database it can take several hours as you mentioned, so performing a full vacuum would really only be recommended one a year at the most. You can run vacuums against individual tables as well if there are only a few tables to target.

 

Regards,

Craig