House keeping settings and advice please

[G0nz0uk]

Hello,

Zabbix version v7.4.9

Postgres v18 with TSDB 2.26

Zabbix DB size is 102GB (although when using databasus to back up it's 11gb)

I've trying to reduce the size of the DB and it's growth. I had the history on 60days and trend on 90days, I've set the history to 30days and trend to 60days, but data is not reducing after leaving things for a couple of days.

I've noticed in the zabbix_server.conf that these are not set, should they be and if so what would you suggest?

### Option: HousekeepingFrequency
# How often Zabbix will perform housekeeping procedure (in hours).
# Housekeeping is removing outdated information from the database.
# To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency
# hours of outdated information are deleted in one housekeeping cycle, for each item.
# To lower load on server startup housekeeping is postponed for 30 minutes after server start.
# With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option.
# In this case the period of outdated information deleted in one housekeeping cycle is 4 times the
# period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days.
#
# Mandatory: no
# Range: 0-24
# Default:
# HousekeepingFrequency=1

### Option: MaxHousekeeperDelete
# The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
# [housekeeperid], [tablename], [field], [value].
# No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
# will be deleted per one task in one housekeeping cycle.
# If set to 0 then no limit is used at all. In this case you must know what you are doing!
#
# Mandatory: no
# Range: 0-1000000
# Default:
# MaxHousekeeperDelete=5000

These are the settings I have in the GUI

[cyber]

If you have set global values to 31d, then you can mark whatever in your item config, it will be overrun. Your DB is probably not shrinking as there is nothing to shrink...

If some setting in server/proxy/agent config file is commented, it means it uses "default" value, which does nto have to be specified. Only if you want to change it, you uncomment the line and add your own value.