<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div><br></div><div><br></div><div><span id="zwchr" data-marker="__DIVIDER__">----- Le 8 Déc 16, à 15:18, Roy Golan <rgolan@redhat.com> a écrit :<br></span></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div dir="ltr"><div><div><div><div><div><div>Hi all,<br><br></div>Following the thread about vacuum tool [1] I would like to 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 of one table):<br><br><span style="font-family: monospace,monospace;" data-mce-style="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 versions were removed.<br>0 index pages have been deleted, 0 are currently reusable.<br>CPU 0.00s/0.00u sec elapsed 0.00 sec.<br></span><br><br></div>1. sudo 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="http://paste.fedoraproject.org/" target="_blank" data-mce-href="http://paste.fedoraproject.org/">http://paste.fedoraproject.org/</a> and reply with the link here<br><br><br>[1] <a href="http://lists.ovirt.org/pipermail/devel/2016-December/014484.html" target="_blank" data-mce-href="http://lists.ovirt.org/pipermail/devel/2016-December/014484.html">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@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br></blockquote></div><div><br></div><div>http://paste.fedoraproject.org/501769/48120789/</div><div><br data-mce-bogus="1"></div><div>But, we run a full vacuum about one month ago that have free about 8GB of space and we set DWH_SAMPLING=60 to decrease data size of DWH (install is ~ 1y and half old, updated from 3.5 to 3.6 to 4.0).<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Have a nice day.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Regards.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div data-marker="__SIG_POST__">-- <br></div><div>Baptiste<br><br></div></div></body></html>