Once upon a time, Lucie Leistnerova <lleis...@redhat.com> said:
> you can use engine tools: engine-vacuum and dwh-vacuum.
> It can do full vacuum with -f option and also it runs with
> engine-setup when you choose it.
engine-vacuum doesn't appear to touch the DWB DB, and I don't have a
dwh-vacuum (on 4.1). After reading a RHBZ, the issue was the various
*_samples_* tables, so I did:
########################
systemctl stop ovirt-engine-dwhd.service
. /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf
PGPASSWORD="$DWH_DB_PASSWORD" psql \
-h "$DWH_DB_HOST" \
-p "$DWH_DB_PORT" \
-U "$DWH_DB_USER" \
-d "$DWH_DB_DATABASE" \
<<'EOF'
vacuum full host_interface_samples_history;
vacuum full vm_disk_samples_history;
vacuum full vm_disks_usage_samples_history;
vacuum full vm_interface_samples_history;
vacuum full vm_samples_history;
EOF
systemctl start ovirt-engine-dwhd.service
########################
That reduced my Postgres DB size from 15G to 1.4G.
--
Chris Adams <c...@cmadams.net>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/QBBWM2TSQUGPTZHQ5LCWHJUHI37HKC46/
