Deleted host still have records in History table

[nima0102]

Hi
I have deleted a few hosts in zabbix,but their records in History table and trend table was not deleted.and there are still rows that related to removed hosts.
Are records automatically removed from other table after related host is deleted?or I have to manually remove them?
Is this delete procedure related to "Housekeeping" process?it means,Does Housekeeping do delete rows from other tables after host removing?if so, Do I have to change parameter in config zabbix_server.config ?

Thanks for any help or guidance

[alex790]

I have the same problem. I deleted a bunch of hosts which were monitored at fast pace for a few years. I was expecting my 15GB Postgres DB to at least drop to less than 5GB, but it appears after the house keeper has run that the DB is the same size as before, and the history and trends table still have the same amount of records.

I now have for example (Is the housekeeper working with zabbix 1.8.2?)

zabbix=# select count(*) from housekeeper;
count
-------
8

zabbix=# select count(*) from history_uint where itemid not in ( select itemid from items );
count
----------
14164574

zabbix=# select count(*) from history where itemid not in ( select itemid from items );
count
----------
33384202