-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
None
-
None
-
None
-
Production
Hi,
In our environment we are using zabbix for monitoring and database as postgresql.
The problem we are having is postgresdb size has increased ad reach to 824GB. Now we need to cleanup the old data
Few observation
zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history') ); pg_size_pretty ---------------- 191 GB (1 row) zabbix=# SELECT pg_size_pretty( pg_total_relation_size('trends_uint') ); pg_size_pretty ---------------- 21 GB (1 row) zabbix=# SELECT pg_size_pretty( pg_total_relation_size('history_uint') ); pg_size_pretty ---------------- 566 GB (1 row)
Most of the space are occupied by above tables. Please help us to clean above tables without effecting the monitoring
Regards
jithin