2 Replies Latest reply on Oct 28, 2013 9:44 AM by mcron

Reduce database size

mcron Oct 24, 2013 9:04 AM

We are running Virtualization Manager v6.0.0.10001. My goal is to reduce the size of the database and the length of time that the data is retained. I have changed the "Days to Retain Performance Data Hourly Rollups" value to 60 days from the default 90 days.

My expectation is that the data that is older than 60 days will be pruned out and the database size will decrease. Is this correct? If so, when should I expect to see a reduction in the database size?

Thanks for the help.

Re: Reduce database size

bmrad Oct 25, 2013 11:44 AM (in response to mcron)

Hi,

You should see the DB shrink in about 24 hours or so. You can get further reductions by changing "Days to Retain Raw Performance Data" to a smaller number (default is 14 days).
You could also do a manual vacuum on the DB as well (link to Postgres instructions below). Note if you decide to do a FULL vacuum, then you need to shut down the VMan service first.

PostgreSQL: Documentation: 8.3: VACUUM

Let me know if you need additional information.

Brian
Like (0)

Actions
- Re: Reduce database size
  
  mcron Oct 28, 2013 9:44 AM (in response to bmrad)
  
  Brian, thanks for your response. I am seeing the reduction that I expected. And thanks for the VACUUM steps as well.
  
  McR
  
  Like (0)
  
  Actions

Go to original post