I'd be grateful for some insight into the
VACUUM functionality within PostgreSQL 9.3. I read through the documentation and searched around a bit but could not find a definitive answer to this.
I'm setting up a weekly DB maintenance job for a 9.3 server.
Part of this will be a
VACUUM FULL. It's a smallish DB and I have a decent weekend maintenance window so I can run the
FULL without any issues.
Is there any point in adding the
ANALYZE option to the command?
According to the 9.3 documentation:
VACUUM FULLrewrites the entire contents of the table into a new disk file with no extra space, allowing unused space to be returned to the operating system.
If the table is completely recreated then do I need to specifically ask for
ANALYZE to happen or are the statistics updated automatically as the rows are written to the new version of the table?