[ovirt-users] Request for feedback on your db vacuum status

[Roy Golan]

Hi all,

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.

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):

INFO:  vacuuming "pg_catalog.pg_ts_template"
INFO:  index "pg_ts_template_tmplname_index" now contains 5 row versions in
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 here


[1] http://lists.ovirt.org/pipermail/devel/2016-December/014484.html


Thanks,
Roy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20161208/56c46a89/attachment-0001.html>