Hi,
We have recently upgrade our oVirt environment to 4.5.2 version. Environment is based on
hosted-engine. Since we have upgrade we noticed rapid incrase in /var partition in engine
VM. It is increasing very rapidly. If we vacuum ovirt_engine_history db, /var size reduces
but next day size will increase again upto 5-10%. We did db vacuuming couple of time but
not sure we it is increasing so rapidly.
Here is the partial output of vacuuming that was done on 26-08-22. Table
"host_interface_hourly_history" had more entries to be removed. Rest of the
table had not much entries. Previously table "host_interface_samples_history"
had entries to be removed.
Any Idea what can be the reason for that?
# dwh-vacuum -f -v
SELECT pg_catalog.set_config('search_path', '', false);
vacuumdb: vacuuming database "ovirt_engine_history"
RESET search_path;
SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=) ns.oid
LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=) t.oid
WHERE c.relkind OPERATOR(pg_catalog.=) ANY (array['r', 'm'])
ORDER BY c.relpages DESC;
SELECT pg_catalog.set_config('search_path', '', false);
VACUUM (FULL, VERBOSE) public.host_interface_samples_history;
INFO: vacuuming "public.host_interface_samples_history"
INFO: "host_interface_samples_history": found 3135 removable, 84609901
nonremovable row versions in 1564960 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU: user: 41.88 s, system: 14.93 s, elapsed: 422.83 s.
VACUUM (FULL, VERBOSE) public.host_interface_hourly_history;
INFO: vacuuming "public.host_interface_hourly_history"
INFO: "host_interface_hourly_history": found 252422 removable, 39904650
nonremovable row versions in 473269 pages
Please let me know if any further information is required.
Regards
Sohail