Comment 2 for bug 1660418

Revision history for this message
Paul Larson (pwlars) wrote :

I'm currently running something like this every day on our MaaS:
time sudo -u postgres vacuumlo -v maasdb
time sudo maas-region db_vacuum_lobjects
time sudo -u postgres psql maasdb -c 'vacuum full verbose maasserver_largefile'
sudo du -sh /var/lib/postgresql/

The sudo maas-region db_vacuum_lobjects often takes up to an hour for us, but this has enabled us to keep the size of everything under /var/lib/postgresql down to about 20-30GB. It sometimes grows a little higher than that, but comes back down after running this.