Hi Didi,
El 2016-09-01 14:02, Yedidyah Bar David escribió:
On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola <[email protected]>
wrote:
Didi, Shirly, can you help here?
On Thu, Sep 1, 2016 at 8:52 AM, <[email protected]> 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?
Earlier today replied to a similar question, search list archives for
"Change Engine History Logging from Advanched to Basic".
Just to confirm: I already have basic DWH configured, and the content of
/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf is:
DWH_TABLES_KEEP_SAMPLES=24
DWH_TABLES_KEEP_HOURLY=720
DWH_TABLES_KEEP_DAILY=0
So according to [1] regarding "DWH_TABLES_KEEP_HOURLY":
The number of hours that hourly data is stored. The default is 60
days.
Hourly data more than two days old is aggregated into dailydata.
if I reduce that value to say 240 (10 days), any older entry from that
should be erased upon a DWH restart, right?
Thanks.
[1]:
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
Best,
Thanks.
_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users [1]
--
Sandro Bonazzola
Better technology. Faster innovation. Powered by community
collaboration.
See how it works at redhat.com [2]
[3]
--
Didi
Links:
------
[1] http://lists.ovirt.org/mailman/listinfo/users
[2] http://redhat.com
[3] https://www.redhat.com/it/about/events/red-hat-open-source-day-2016
_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users
