Removed the FULL subcommand for the database vacuum in hopes that this will improve vacuum speed.
Motivation and Context
The current database vacuum takes almost 6 hours to complete. The database vacuum requires system downtime while it is running. We were hoping that this would fit into a single 2 hour window.
How Has This Been Tested?
Specific code or questions that need feedback
The difference between a standard vacuum and a full vacuum is that a full vacuum reorganizes and defragments the tables while removing while a standard vacuum just marks the dead tuples as available for reuse without actually removing them. I am unsure which metrics we can check to see if there is a major difference in the outcomes we are hoping for with this vacuum.
Description
Removed the FULL subcommand for the database vacuum in hopes that this will improve vacuum speed.
Motivation and Context
The current database vacuum takes almost 6 hours to complete. The database vacuum requires system downtime while it is running. We were hoping that this would fit into a single 2 hour window.
How Has This Been Tested?
Specific code or questions that need feedback
The difference between a standard vacuum and a full vacuum is that a full vacuum reorganizes and defragments the tables while removing while a standard vacuum just marks the dead tuples as available for reuse without actually removing them. I am unsure which metrics we can check to see if there is a major difference in the outcomes we are hoping for with this vacuum.
Checklist: