Re: [ovirt-users] Limit DWH database size

2016-09-15 Thread Yaniv Dary
If you want to make the db smaller with immediate affect, please do full vacuum and analyze after deleting the rows from the DB or waiting a day for the DWH to do this. Yaniv Dary Technical Product Manager Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 Tel

Re: [ovirt-users] Limit DWH database size

2016-09-02 Thread nicolas
I tried adjusting the DWH_TABLES_KEEP_HOURLY parameter to a very low value and also setting the DWH_SAMPLING parameter to 60 and restarted both ovirt-engine-dwhd and ovirt-engine daemons, however, the database is still huge. So even if I change those parameters should I manually clean up the

Re: [ovirt-users] Limit DWH database size

2016-09-01 Thread Shirly Radco
Another option is to set the DWH_SAMPLING back to 60 and restart dwh. This will lower the granularity of the dashboard calculations. The dwh db size grow since now it samples the statistics every 15 seconds instead of once a minute. Best regards, Shirly Radco On Sep 1, 2016 19:29,

Re: [ovirt-users] Limit DWH database size

2016-09-01 Thread Yedidyah Bar David
On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola wrote: > Didi, Shirly, can you help here? > > > On Thu, Sep 1, 2016 at 8:52 AM, wrote: > >> Hi, >> >> Since we upgraded to 4.0.x, DWH's PostgreSQL database is getting really >> huge. Is there a clean way to

Re: [ovirt-users] Limit DWH database size

2016-09-01 Thread Sandro Bonazzola
Didi, Shirly, can you help here? On Thu, Sep 1, 2016 at 8:52 AM, wrote: > Hi, > > Since we upgraded to 4.0.x, DWH's PostgreSQL database is getting really > huge. Is there a clean way to limit its size, like setting a maximal > retention time for DWH data? > > Thanks. >