Hello all,
I'm new here so I do ask for your understanding.
From some period of time I have a problem with my zabbix database (engine postgres).
One of table is growing up to more then 122 GB
zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history_uint') ); pg_size_pretty ---------------- 122 GB (1 row)
That force on me to manually vacuum database to decrease size. I checked whole configuration and autovacuum is set.
But today I discovered that maybe it is not a issue. I need confirmation my suspicions. Based on page https://www.zabbix.com/documentation...#database_size
I made calculations. Data from my zabbix
Number of items - 24647
Refresh rate - 60 seconds
We would like to keep 14 days of history
And based on example, I discovered that my Zabbix needs ~ 255GB DB! Anyone can confirm my calculations ? It was done base on example
About my env.
There is one main node - zabbix server
One remote node with database - postgres
and 3 more external proxies.
I'm new here so I do ask for your understanding.
From some period of time I have a problem with my zabbix database (engine postgres).
One of table is growing up to more then 122 GB
zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history_uint') ); pg_size_pretty ---------------- 122 GB (1 row)
That force on me to manually vacuum database to decrease size. I checked whole configuration and autovacuum is set.
But today I discovered that maybe it is not a issue. I need confirmation my suspicions. Based on page https://www.zabbix.com/documentation...#database_size
I made calculations. Data from my zabbix
Number of items - 24647
Refresh rate - 60 seconds
We would like to keep 14 days of history
And based on example, I discovered that my Zabbix needs ~ 255GB DB! Anyone can confirm my calculations ? It was done base on example
About my env.
There is one main node - zabbix server
One remote node with database - postgres
and 3 more external proxies.