In general, compacting should work while the db is running, but it's fairly conservative, so if you have running queries or open transactions, that can keep a lot of stuff alive that should be compacted. Also, if you are adding stuff to the db while compacting, even if the compacter frees up a ton of space, there will likely be trailing entries in the file that prevent the file from being truncated.
If you can temporarily pause all your queries or operations while you run the compacter, that might help. Possibly we should look into an option that does that (pausing) automatically. -- 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/CAFYHVnVzL66xyFJpt4PJ5GV4oX8oO1wBapqmAcVuO_vxEAQ9yA%40mail.gmail.com.
