On 10/14/19 3:07 PM, Chris Adams wrote:
Once upon a time, Lucie Leistnerova <lleistne@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). Ah, you are right. dwh-vacuum was added in 4.2. 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.
-- Lucie Leistnerova Senior Quality Engineer, QE Cloud, RHVM Red Hat EMEA IRC: lleistne @ #rhev-qe