<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,  &lt;<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>&gt; 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 &lt;<a href="mailto:sbonazzo@redhat.com" target="_blank">sbonazzo@redhat.com</a>&gt;<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, &lt;<a href="mailto:nicolas@devels.es" target="_blank">nicolas@devels.es</a>&gt; 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&#39;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>
&quot;Change Engine History Logging from Advanched to Basic&quot;.<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 &quot;DWH_TABLES_KEEP_HOURLY&quot;:<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>