Thanks for the clarification! I will try to pause operations on the database and see what happens. What do you mean with "while you run the compacter"? Is there a specific command to start the compacter. I thought it would start automatically or if I run SHUTDOWN COMPACT.
Noel Grandin schrieb am Dienstag, 14. Juni 2022 um 08:12:03 UTC+2: > > 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/dbf6d485-bb7d-4bae-96ec-81bdfcdc89dcn%40googlegroups.com.
