Hello, We faced issue with long running databases in H2 v2.1.214 which file size never goes down until all database connection are closed (with the same amount of data).
This leads to ever growing database that can reach problematic file size on the long term while the actual data inside is stable. We were able to highlight a difference in the behavior of H2 V2.1.214 and H2 V1.4.200 in the auto compaction process while inserting and deleting over and over the same line within the database. Details of the test case that highlights the difference can be found on the GitHub ticket : https://github.com/h2database/h2database/issues/3848 Is that change of behavior between the two version expected? If so, with the current behavior, do you have any advices to ensure that the database file size stays stable on the long term when using the H2 V2.1.214? (we would like to avoid having to compact the database regularly) Best regards, Pierre-Olivier -- 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/ecb1b131-344d-4ed2-9f05-813cf8ad8a64n%40googlegroups.com.
