Hi all, 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: AUTO_COMPACT_FILL_RATE 90 info.FILL_RATE 19 info.CHUNKS_FILL_RATE 27 info.CHUNKS_FILL_RATE_RW 27 info.FILE_SIZE 4916121600 info.CHUNK_COUNT 490 info.PAGE_COUNT 1594967 info.PAGE_COUNT_LIVE 440730 info.PAGE_SIZE 4096 info.CACHE_MAX_SIZE 16 info.CACHE_SIZE 15 info.CACHE_HIT_RATIO 85 info.TOC_CACHE_HIT_RATIO 99 info.LEAF_RATIO 44 Thanks! Ulrich -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/ae5bf92d-f61a-4cac-981a-9e1b51d7d49fn%40googlegroups.com.
