<p dir="ltr">Another option is to set the DWH_SAMPLING back to 60 and restart 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 seconds instead of once a minute.</p>
<p dir="ltr">Best regards,<br>
Shirly Radco</p>
<div class="gmail_extra"><br><div class="gmail_quote">On Sep 1, 2016 19:29, <<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>> wrote:<br type="attribution"><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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola <<a href="mailto:sbonazzo@redhat.com" target="_blank">sbonazzo@redhat.com</a>><br>
wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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></blockquote>
<br>
Earlier today replied to a similar question, search list archives for<br>
"Change Engine History Logging from Advanched to Basic".<br>
<br>
</blockquote>
<br>
Just to confirm: I already have basic DWH configured, and the content of /etc/ovirt-engine-dwh/ovirt-en<wbr>gine-dwhd.conf.d/10-setup-scal<wbr>e.conf 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 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 that should be erased upon a DWH restart, right?<br>
<br>
Thanks.<br>
<br>
[1]: <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>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Best,<br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks.<br>
______________________________<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> [1]<br>
</blockquote>
<br>
--<br>
<br>
Sandro Bonazzola<br>
Better technology. Faster innovation. Powered by community<br>
collaboration.<br>
See how it works at <a href="http://redhat.com" rel="noreferrer" target="_blank">redhat.com</a> [2]<br>
<br>
[3]<br>
</blockquote>
<br>
--<br>
<br>
Didi<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] <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>
</blockquote></div></div>