5:15 a.m.
--_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello oVirt guru out there:
I notice our oVirt engine postgres db size is growing quite fast for past c=
ouple of months. I checked the database size. Found that our ovirt_engine=
_history is 73GB in size.
engine=3D# \connect ovirt_engine_history
You are now connected to database "ovirt_engine_history" as user
"postgres"=
.
ovirt_engine_history=3D# SELECT pg_size_pretty( pg_database_size( current_d=
atabase() ) ) As human_size
, pg_database_size( current_database() ) As raw_size;
human_size | raw_size
------------+-------------
73 GB | 78444213368
(1 row)
Brief check the records, there are entries dated back 2014.
I want to see if there is a safe way to archive and remove some of the olde=
r records?
Thanks,
Eric
--_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html;
charset=3Diso-8859-=
1">
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span
style=3D"font-size:8.5pt;font-family:"Hel=
vetica","sans-serif"">Hello oVirt guru out
there:<br>
<br>
I notice our oVirt engine postgres db size is growing quite fast for past c=
ouple of months. I checked the database size. Found that our ov=
irt_engine_history is 73GB in size. <br>
<br>
<br>
engine=3D# \connect ovirt_engine_history<br>
You are now connected to database "ovirt_engine_history" as user =
"postgres".<br>
ovirt_engine_history=3D# SELECT pg_size_pretty( pg_database_size( current_d=
atabase() ) ) 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 olde=
r records?<br>
<br>
Thanks,<br>
Eric</span><o:p></o:p></p>
<p class=3D"MsoNormal"><span
style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif""><o:p> </o:p></span></p>
</div>
</body>
</html>
--_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_--
6:38 p.m.
You can configure the DWH via the conf.d to save less records.
See the readme in that folder.
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: ydary(a)redhat.com
IRC : ydary
On Wed, Oct 14, 2015 at 5:15 AM, Eric Wong <Eric.Wong(a)solvians.com> wrote:
Hello oVirt guru out there:
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.
engine=# \connect ovirt_engine_history
You are now connected to database "ovirt_engine_history" as user
"postgres".
ovirt_engine_history=# SELECT pg_size_pretty( pg_database_size(
current_database() ) ) As human_size
, pg_database_size( current_database() ) As raw_size;
human_size | raw_size
------------+-------------
73 GB | 78444213368
(1 row)
Brief check the records, there are entries dated back 2014.
I want to see if there is a safe way to archive and remove some of the
older records?
Thanks,
Eric
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
3283
days inactive
3326
days old
1 comments
2 participants
participants (2)
-
Eric Wong -
Yaniv Dary