Steps to reproduce:

1. Useing postgresql version 16
2. Create 2.000.000 items generating around 2200 NVPS with trends 3y and history 30d
3. Activate Housekeeper Interval every 1 hour and max deletion to 1.000.000.
4. Monitor the data volume over time.

Even with 24h housekeeping interval triggered hourly by cron doesnt make a difference.

Result:

• The housekeeper is not deleting data as expected, leading to a continuous increase in the database size.
• Runtime of the housekeeping takes around 7-10 days
• The delete tuples actions do not exceed the insert actions. 
  
• While debugging current run (started at: 2024-12-29)  it send following example sql statement:
  delete from history_uint where itemid=11090321 and clock<1732146104 (2024-11-20)
  item settings:
  I would assume that the sql statement looks like followind:
  delete from history_uint where itemid=11090321 and clock<{Current clock - 30d} limit 100000; 

Expected:

• We expect the housekeeper to efficiently manage data retention and delete unnecessary data in a timely manner.