I am running a H2 2.1.212 and I wonder why the automatic compact feature does not shrink the database size.
My application is continuously collecting data (around 100 inserts per second). Most of the data is removed once a day. The data is kept in 4300 tables.
The database file size is around 5 GB. When running a manual SHUTDOWN COMPACT it is compacted to 40 MB.
I expected that the automatic compact algorithm of the MV_STORE is able to keep the database smaller than it is. Are there any known circumstances why the compact algorithm does not run or does not give good results?
I already tried to use the latest git code but the results are the same.
Here are some infos from the information_schema.settings table with the relevant parameters: