Zabbix Postgres DB growth

[bmoore]

Hi,

We're trying to reduce the amount of space being used by our Zabbix implementation with the following configuration:

Hosts = 16
Items = 4349
Triggers = 605
VPS = 56.63

Historical data = 30 days

Our DB currently stands at ~30GB after four months activity.

Within Postgres I've run the following commands to clear old data:

---------------------------

SELECT pg_size_pretty(pg_database_size('zabbix')) As fulldbsize;

SELECT pg_size_pretty(pg_total_relation_size('history')) As fulltblsize, pg_size_pretty(pg_relation_size('history')) As justthetblsize;

truncate table history;

vacuum analyze;

---------------------------

Looking around the web I haven't been able to find an exact answer. Any help would be much appreciated.

Thanks in advance.

[Colttt]

historical data=30days.. that include trends??

[bmoore]

I haven't amended the trend configuration, the plan is that it will either be kept indefinitely or for one year. Either way we've only been using Zabbix for 4 months or so.

I should add that our Zabbix version is 2.2

When you change a setting like historical data does Zabbix automatically scrub that data from the DB according to a schedule or process?

Thanks.

[bmoore]

Anyone have thoughts on how we should proceed?