Re: [ovirt-users] Limit DWH database size

Hi Didi, El 2016-09-01 14:02, Yedidyah Bar David escribió: > On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola <sbonazzo(a)redhat.com&gt; > wrote: > > Didi, Shirly, can you help here? >> >> On Thu, Sep 1, 2016 at 8:52 AM, <nicolas(a)devels.es&gt; 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_Enterp rise_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 >>> Users(a)ovirt.org >>> 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 >