<p dir="ltr">You can change the setting for how long data is saved in the dwh conf directory, there is a readme with details in the folder. </p>
<p dir="ltr">---<br>
Yaniv Dary<br>
Technical Product Manager<br>
Red Hat Israel Ltd.<br>
34 Jerusalem Road<br>
Building A, 4th floor<br>
Ra'anana, Israel 4350109</p>
<p dir="ltr">Tel : +972 (9) 7692306<br>
8272306<br>
Email: <a href="mailto:ydary@redhat.com">ydary@redhat.com</a><br>
IRC : ydary</p>
<div class="gmail_quote">On Oct 13, 2015 17:08, "Eric Wong" <<a href="mailto:Eric.Wong@solvians.com">Eric.Wong@solvians.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello oVirt guru out there:<br>
<br>
I notice our oVirt engine postgres db size is growing quite fast for past couple of months. I checked the database size. Found that our ovirt_engine_history is 73GB in size.<br>
<br>
<br>
engine=# \connect ovirt_engine_history<br>
You are now connected to database "ovirt_engine_history" as user "postgres".<br>
ovirt_engine_history=# SELECT pg_size_pretty( pg_database_size( current_database() ) ) As human_size<br>
, pg_database_size( current_database() ) As raw_size;<br>
human_size | raw_size<br>
------------+-------------<br>
73 GB | 78444213368<br>
(1 row)<br>
<br>
<br>
Brief check the records, there are entries dated back 2014.<br>
<br>
I want to see if there is a safe way to archive and remove some of the older records?<br>
<br>
Thanks,<br>
Eric<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div>