On Tue, 2022-06-14 at 08:11 +0200, Noel Grandin wrote: > In general, compacting should work while the db is running, but it's > fairly conservative
Noel, not arguing, you know that we do love H2 and are grateful. Although I never saw any online defragmention doing anything. We have 300 MB defragmented content blown up to 20 GByte. The databases are idle during the night and most time the day. Heavy Delete/Write/Querying happens only in the early morning -- but it never shrinks, only grows, until "SHUTDOWN DEFRAG". Best regards Andreas -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/13bd3bcaa898278cb3bd4d4fb2228d855ca42a39.camel%40manticore-projects.com.
