Reclaiming maas space

[Jim Tilander]

Hi,

I’m experimenting with maas and uploading new images for Windows, several new ~4Gb images each day. At some point I ran out of space on my maas server, inspecting it a little bit closer it looks like the pgqsl database is very very large. I found a relevant entry here: https://bugs.launchpad.net/maas/+bug/1459876 <https://bugs.launchpad.net/maas/+bug/1459876>

So doing a "maas-region db_vacuum_lobjects” doesn’t seem to clean out the overwritten image it seems like. Below I’m doing a du -hs of /var/lib/postgresql before and after an image upload as well as after the vacuum. 

13G     /var/lib/postgresql
Uploading
19G     /var/lib/postgresql
Cleanup database
vacuumdb: vacuuming database "maasdb"
Database vacuumed successfully.
19G     /var/lib/postgresql

It seems though that the database is not shrinking. I’m iterating and making a new windows image over and over again, uploading it with:

maas admin boot-resources create name=windows/win2012r2 architecture=amd64/generic filetype=ddtgz content@=myimage.raw.tgz

I’ve already filled up one server with these commands, and I’m wondering what kind of regular maintenance I need to do to keep the database files under control and not explode as they do now.

Best,
Jim Tilander



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/maas-devel/attachments/20170127/ac211f3a/attachment.html>