Delete histoyr_uint Table Zabbix

[pradeepspa]

Hello,

I am using zabbix 3.2 running on postgres database. The table size of history_uint has grown upto 187 GB and I think housekeeper couldn't clear them all. When I try to delete the content older than 180 days, its taking for ever. Is there any other way to clean up the table? This is causing lots of performance issue in zabbix server.

[volter]

You need a long-term solution of some kind. The usual answer to this is table partitioning. Depending on your version of PG, there may be different solutions. Version 10 has something built in, but I don't know if it's totally usable yet.

Maybe this can help you: https://zabbix.org/wiki/Troubleshoot...8PostgreSQL.29

I'm using this: https://github.com/keithf4/pg_partman

You usually want to turn off the housekeeper for the partitioned tables then.

[kloczek]

Read the sticky post on this forum.

https://www.zabbix.com/forum/showthread.php?t=9925

[pradeepspa]

Thank you. I will look into it.

[tcilmo]

You also might have to run housekeeper manually to help cleanup the tables, since by default it runs once an hour. Keep in mind, doing so might affect performance until the tables are cleaned up.

zabbix_server -R housekeeper_execute

You could even script the housekeeper to run in a continuous loop. If the housekeeper runs with another instance is already running, that attempt is just ignored.

counter=1
while [ $counter -le 600000000000000 ]
do
    zabbix_server -R housekeeper_execute
    sleep 15
    ((counter++))
done

[pradeepspa]

You also might have to run housekeeper manually to help cleanup the tables, since by default it runs once an hour. Keep in mind, doing so might affect performance until the tables are cleaned up.

zabbix_server -R housekeeper_execute

You could even script the housekeeper to run in a continuous loop. If the housekeeper runs with another instance is already running, that attempt is just ignored.

counter=1
while [ $counter -le 600000000000000 ]
do
    zabbix_server -R housekeeper_execute
    sleep 15
    ((counter++))
done

Thank you. I have tried this way it helped reducing the load. I will keep an eye on it.