<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On 8 December 2016 at 17:01, Baptiste Agasse <span dir="ltr"><<a href="mailto:baptiste.agasse@lyra-network.com" target="_blank">baptiste.agasse@lyra-network.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><div><br></div><div><br></div><div><span id="gmail-m_-2692478806496787314zwchr">----- Le 8 Déc 16, à 15:18, Roy Golan <<a href="mailto:rgolan@redhat.com" target="_blank">rgolan@redhat.com</a>> a écrit :<br></span></div><div><blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px;color:rgb(0,0,0);font-weight:normal;font-style:normal;text-decoration:none;font-family:helvetica,arial,sans-serif;font-size:12pt"><div><div class="gmail-h5"><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">INFO: vacuuming "pg_catalog.pg_ts_template"<br>INFO: index "pg_ts_template_tmplname_<wbr>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">http://paste.fedoraproject.<wbr>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">http://lists.ovirt.org/<wbr>pipermail/devel/2016-December/<wbr>014484.html</a><br><br><br></div><div>Thanks,<br></div><div>Roy<br></div></div><br></div></div><span class="gmail-">______________________________<wbr>_________________<br>Users mailing list<br><a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br><a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br></span></blockquote></div><div><br></div><div><a href="http://paste.fedoraproject.org/501769/48120789/" target="_blank">http://paste.fedoraproject.<wbr>org/501769/48120789/</a></div><div><br></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></div><div><br></div><div>Have a nice day.<br></div><div><br></div><div>Regards.<span class="gmail-HOEnZb"><font color="#888888"><br></font></span></div><span class="gmail-HOEnZb"><font color="#888888"><div><br></div><div>-- <br></div><div>Baptiste<br><br></div></font></span></div></div></blockquote><div><br></div><div>Baptiste thank you very much for submitting this, very helpful. <br></div><div>I wonder if it was the engine or dwh db who took most of the 8gb. <br></div><div>FYI there is a discussion on increasing the interval to 60 on <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1395608"><b>Bug 1395608</b></a> -<span id="gmail-summary_alias_container">
<span id="gmail-short_desc_nonedit_display">DWH sampling is too high</span></span> </div></div><br></div></div>