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.
I'm currently running something like this every day on our MaaS: largefile' postgresql/
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_
sudo du -sh /var/lib/
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.