<div dir="ltr"><div>You can configure the DWH via the conf.d to save less records.<br></div>See the readme in that folder.<br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><pre cols="72"><span style="font-family:arial,helvetica,sans-serif">Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: <a href="mailto:ydary@redhat.com" target="_blank">ydary@redhat.com</a>
IRC : ydary</span></pre>
</div></div></div></div></div>
<br><div class="gmail_quote">On Wed, Oct 14, 2015 at 5:15 AM, Eric Wong <span dir="ltr"><<a href="mailto:Eric.Wong@solvians.com" target="_blank">Eric.Wong@solvians.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Helvetica","sans-serif"">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</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><u></u> <u></u></span></p>
</div>
</div>
<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>
<br></blockquote></div><br></div>