<div dir="ltr">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.<div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><pre cols="72"><span style="font-family:arial,helvetica,sans-serif">Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: <a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a>
IRC : ydary</span></pre>
</div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Sep 2, 2016 at 12:07 PM, <span dir="ltr"><<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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.<br>
<br>
So even if I change those parameters should I manually clean up the database? If so, what's the recommended way?<br>
<br>
Thanks.<div><div class="h5"><br>
<br>
El 2016-09-01 19:26, Shirly Radco escribió:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
Another option is to set the DWH_SAMPLING back to 60 and restart<br>
dwh.<br>
This will lower the granularity of the dashboard calculations.<br>
The dwh db size grow since now it samples the statistics every 15<br>
seconds instead of once a minute.<br>
<br>
Best regards,<br>
Shirly Radco<br>
<br>
On Sep 1, 2016 19:29, <<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Didi,<br>
<br>
El 2016-09-01 14:02, Yedidyah Bar David escribió:<br>
On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola<br>
<<a href="mailto:sbonazzo@redhat.com" target="_blank">sbonazzo@redhat.com</a>><br>
wrote:<br>
<br>
Didi, Shirly, can you help here?<br>
<br>
On Thu, Sep 1, 2016 at 8:52 AM, <<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>> wrote:<br>
<br>
Hi,<br>
<br>
Since we upgraded to 4.0.x, DWH's PostgreSQL database is getting<br>
really huge. Is there a clean way to limit its size, like setting<br>
a maximal retention time for DWH data?<br>
</blockquote>
<br>
Earlier today replied to a similar question, search list archives for<br>
"Change Engine History Logging from Advanched to Basic".<br>
<br>
Just to confirm: I already have basic DWH configured, and the content<br>
of /etc/ovirt-engine-dwh/ovirt-en<wbr>gine-dwhd.conf.d/10-setup-scal<wbr>e.conf<br>
is:<br>
<br>
DWH_TABLES_KEEP_SAMPLES=24<br>
DWH_TABLES_KEEP_HOURLY=720<br>
DWH_TABLES_KEEP_DAILY=0<br>
<br>
So according to [1] regarding "DWH_TABLES_KEEP_HOURLY":<br>
<br>
The number of hours that hourly data is stored. The default is 60<br>
days.<br>
Hourly data more than two days old is aggregated into dailydata.<br>
<br>
if I reduce that value to say 240 (10 days), any older entry from<br>
that should be erased upon a DWH restart, right?<br>
<br>
Thanks.<br>
<br>
[1]:<br>
<a href="https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.6/pdf/Reports_and_Data_Warehouse_Guide/Red_Hat_Enterprise_Virtualization-3.6-Reports_and_Data_Warehouse_Guide-en-US.pdf" rel="noreferrer" target="_blank">https://access.redhat.com/docu<wbr>mentation/en-US/Red_Hat_Enterp<wbr>rise_Virtualization/3.6/pdf/<wbr>Reports_and_Data_Warehouse_<wbr>Guide/Red_Hat_Enterprise_<wbr>Virtualization-3.6-Reports_<wbr>and_Data_Warehouse_Guide-en-<wbr>US.pdf</a><br></div></div>
[3]<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Best,<br>
<br>
<br>
<br>
Thanks.<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
</span><a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a> [1] [1]<span class=""><br>
<br>
--<br>
<br>
Sandro Bonazzola<br>
Better technology. Faster innovation. Powered by community<br>
collaboration.<br></span>
See how it works at <a href="http://redhat.com" rel="noreferrer" target="_blank">redhat.com</a> [2] [2]<br>
<br>
[3]<br>
</blockquote>
<br>
--<br>
<br>
Didi<br>
<br>
Links:<br>
------<br>
[1] <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a> [1]<br>
[2] <a href="http://redhat.com" rel="noreferrer" target="_blank">http://redhat.com</a> [2]<br>
[3]<br>
<a href="https://www.redhat.com/it/about/events/red-hat-open-source-day-2016" rel="noreferrer" target="_blank">https://www.redhat.com/it/abou<wbr>t/events/red-hat-open-source-<wbr>day-2016</a><br>
[4]<span class=""><br>
<br>
<br>
Links:<br>
------<br>
[1] <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
[2] <a href="http://redhat.com" rel="noreferrer" target="_blank">http://redhat.com</a><br>
[3]<br>
</span><a href="https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.6/pdf/Reports_and_Data_Warehouse_Guide/Red_Hat_Enterprise_Virtualization-3.6-Reports_and_Data_Warehouse_Guide-en-US.pdf" rel="noreferrer" target="_blank">https://access.redhat.com/docu<wbr>mentation/en-US/Red_Hat_Enterp<wbr>rise_Virtualization/3.6/pdf/<wbr>Reports_and_Data_Warehouse_<wbr>Guide/Red_Hat_Enterprise_<wbr>Virtualization-3.6-Reports_<wbr>and_Data_Warehouse_Guide-en-<wbr>US.pdf</a><br>
[4] <a href="https://www.redhat.com/it/about/events/red-hat-open-source-day-2016" rel="noreferrer" target="_blank">https://www.redhat.com/it/abou<wbr>t/events/red-hat-open-source-<wbr>day-2016</a><br>
</blockquote><div class="HOEnZb"><div class="h5">
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</div></div></blockquote></div><br></div>