PostgreSQL has an autovacuum and however much it improves with every version it has not removed the benefit of the occasional manual vacuum. There are 3 levels of effectiveness and load; autovacuum, vacuum (like reindex), and vacuum full (like a dump/restore). We find that a full vacuum can be of little benefit even over decades, but a regular vacuum can be of benefit in as little as a year.
- System Tools > Analytics > DB Index Fragmentation
gives an indication of if running a vacuum would be of benefit (more than 10 tables, over 30% fragmented). Noodle has a button for this and other tasks in
- System Tools > Settings > General > Import > Maintenance
But there is no progress report etc like with the official management client for PostgreSQL (PGAdmin4):
- https://www.pgadmin.org/download
- Log in > Server > Databases > Noodle > Right-click > Maintenance > VACUUM (settings and go)
or by running SQL:
- VACUUM VERBOSE ANALYZE;
We don't automate this for servers we don't manage because it can conflict with backups and usage.