Purging recorder doesn't reduce hass database size

Configuration
1

Hi,

When I call :

recorder.purge
keep_days: 1
repack: true

all the entries older than a day are removed, but the size of the MariaDB database keeps growing.

image
SQL requests used :

  • SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="hass_db" GROUP BY table_schema;
  • SELECT max(time_fired), min(time_fired) from events;

Am I doing something wrong ?

2

A few hours after the purge, the size of the database is now 167.91 MB.