Hey All.
I need to setup history and trends retention period per item instead of using Global overrides. I know you can freely modify item retention on the Templates, but it will be overridden by the housekeeper settings. Unless I disable global overrides for history and trends, I wont be able to modify these settings.
These should not be an issue normally. But while I was looking through the docs and as I understood correctly, this will stop the housekeeping from cleaning old TimescaleDB partitions.
My question is how do I set the retention per Item without affecting the housekeeper functionality?
I need to setup history and trends retention period per item instead of using Global overrides. I know you can freely modify item retention on the Templates, but it will be overridden by the housekeeper settings. Unless I disable global overrides for history and trends, I wont be able to modify these settings.
These should not be an issue normally. But while I was looking through the docs and as I understood correctly, this will stop the housekeeping from cleaning old TimescaleDB partitions.
If using TimescaleDB, in order to take full advantage of TimescaleDB automatic partitioning of history and trends tables, Override item history period and Override item trend period options must be enabled as well as Enable internal housekeeping option for history and trends. Otherwise, data kept in these tables will still be stored in partitions, however, the housekeeper will not drop outdated partitions, and warnings about incorrect configuration will be displayed. When dropping of outdated partitions is enabled, Zabbix server and frontend will no longer keep track of deleted items, and history for deleted items will be cleared when an outdated partition is deleted.