Hi Sohail,
I really can't find any reason for that if the changes between 4.4.10 to
4.5.2, it might be something in your local environment configuration.
Sorry for not helping much, still trying to think if it's a bug, in the
meanwhile I would suggest switching dwh and grafana to separate vm, it's
not a complicated process.
Thanks, and please keep me updated!
Aviv
On Thu, Sep 8, 2022 at 1:45 PM wrote:
> Hi Aviv,
>
> Thanks for your reply. We upgrade from 4.4.7 to 4.4.10 and then 4.5.2
> We observed it started to increase since we upgraded to 4.5.2. I have to
> do dwh vacuuming every 2-3 days. Here for example.
> --
> omitted output.
> [root@manager ~]# 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 94115 removable, 70244664
> nonremovable row versions in 1903718 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU: user: 36.72 s, system: 12.91 s, elapsed: 195.78 s.
> VACUUM (FULL, VERBOSE) public.host_interface_hourly_history;
> INFO: vacuuming "public.host_interface_hourly_history"
> INFO: "host_interface_hourly_history": found 126645 removable, 40469226
> nonremovable row versions in 482262 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU: user: 20.71 s, system: 5.58 s, elapsed: 115.83 s.
> VACUUM (FULL, VERBOSE) public.vm_disks_usage_samples_history;
> INFO: vacuuming "public.vm_disks_usage_samples_history"
> INFO: "vm_disks_usage_samples_history": found 2028 removable, 1672491
> nonremovable row versions in 307111 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU: user: 4.35 s, system: 3.77 s, elapsed: 51.81 s.
>
> -
> We have the plans to switch dwh and grafana to separate vm. Meanwhile we
> were curious to know the reason of this rapid increase.
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/privacy-policy.html
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/NOD2S7Q27GV2F7P2WG5BIAKMLDQHZPJ5/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/IWO4COYHSNYXTTIGVVY4DPWOWNSX6RRV/
