5:01 p.m.
------=_Part_36891129_1203489647.1481209273258
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
----- Le 8 D=C3=A9c 16, =C3=A0 15:18, Roy Golan <rgolan(a)redhat.com> a =C3=
=A9crit :=20
Hi all,
Following the thread about vacuum tool [1] I would like to gather
some fe=
edback
about your deployment's db vacuum status The info is completely
anonymous=
and
function running it is a read only reporting one and should have
little o=
r no
effect on the db.
The result can be pretty verbose but again will not disclose
sensitive in=
fo.
Anyway review it before pasting it. It should look something like
that(a
snippet of one table):
INFO: vacuuming "pg_catalog.pg_ts_template"
INFO: index "pg_ts_template_tmplname_index" now contains 5 row versions i=
n 2
pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
1. sudo su - postgres -c "psql engine -c 'vacuum
verbose'" &> /tmp/vacuum=
.log
2. review the /tmp/vacuum.log
3. paste it to http://paste.fedoraproject.org/ and reply with the
link he=
re
Thanks,
Roy
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
http://paste.fedoraproject.org/501769/48120789/=20
But, we run a full vacuum about one month ago that have free about 8GB of s=
pace and we set DWH_SAMPLING=3D60 to decrease data size of DWH (install is =
~ 1y and half old, updated from 3.5 to 3.6 to 4.0).=20
Have a nice day.=20
Regards.=20
--=20
Baptiste=20
------=_Part_36891129_1203489647.1481209273258
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><body><div style=3D"font-family: arial, helvetica, sans-serif;
font-s=
ize: 12pt; color:
#000000"><div><br></div><div><br></div><div><span
id=3D"z=
wchr" data-marker=3D"__DIVIDER__">----- Le 8 D=C3=A9c 16, =C3=A0 15:18,
Roy=
Golan &lt;rgolan(a)redhat.com&gt; a =C3=A9crit
:<br></span></div><div data-m=
arker=3D"__QUOTED_TEXT__"><blockquote style=3D"border-left: 2px solid
#1010=
FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; =
font-style: normal; text-decoration: none; font-family: Helvetica,Arial,san=
s-serif; font-size: 12pt;" data-mce-style=3D"border-left: 2px solid #1010FF=
; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; fo=
nt-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-=
serif; font-size: 12pt;"><div
dir=3D"ltr"><div><div><div><div><div><div>Hi
=
all,<br><br></div>Following the thread about vacuum tool [1] I would
like t=
o gather some feedback about your deployment's db vacuum status The info is=
completely anonymous and function running it is a read only reporting one =
and should have little or no effect on the db.<br><br></div>The result
can =
be pretty verbose but again will not disclose sensitive info. Anyway =
review it before pasting it. It should look something like that(a snippet o=
f one table):<br><br><span style=3D"font-family:
monospace,monospace;" data=
-mce-style=3D"font-family: monospace,monospace;">INFO: vacuuming
"pg_=
catalog.pg_ts_template"<br>INFO: index
"pg_ts_template_tmplname_index=
" now contains 5 row versions in 2 pages<br>DETAIL: 0 index row
versi=
ons were removed.<br>0 index pages have been deleted, 0 are currently reusa=
ble.<br>CPU 0.00s/0.00u sec elapsed 0.00
sec.<br></span><br><br></div>1. su=
do su - postgres -c "psql engine -c 'vacuum verbose'"
&> /tmp/=
vacuum.log<br><br></div>2. review the
/tmp/vacuum.log<br><br></div>3. paste=
it to <a href=3D"http://paste.fedoraproject.org/"
target=3D"_blank" data-m=
ce-href=3D"http://paste.fedoraproject.org/">http://paste.fed...
</a> and reply with the link here<br><br><br>[1] <a
href=3D"http://lists.ov=
irt.org/pipermail/devel/2016-December/014484.html" target=3D"_blank"
data-m=
ce-href=3D"http://lists.ovirt.org/pipermail/devel/2016-December/0144...
">http://lists.ovirt.org/pipermail/devel/2016-December/014484.html</a><br><=
br><br></div><div>Thanks,<br></div><div>Roy<br></div></div><br>____________=
___________________________________<br>Users mailing list<br>Users(a)ovirt.or=
g<br>http://lists.ovirt.org/mailman/listinfo/users<br></bl...
iv><br></div><div>http://paste.fedoraproject.org/501...
<br data-mce-bogus=3D"1"></div><div>But,
we run a full vacuum about one mo=
nth ago that have free about 8GB of space and we
set DWH_SAMPLING=3D60 to d=
ecrease data size of DWH (install is ~ 1y and half old, updated from 3.5 to=
3.6 to 4.0).<br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"1"><=
/div><div>Have a nice day.<br
data-mce-bogus=3D"1"></div><div><br data-mce-=
bogus=3D"1"></div><div>Regards.<br
data-mce-bogus=3D"1"></div><div><br data=
-mce-bogus=3D"1"></div><div
data-marker=3D"__SIG_POST__">-- <br></div><div>=
Baptiste<br><br></div></div></body></html>
------=_Part_36891129_1203489647.1481209273258--