Hi, Currently the database file only shrinks when closing the database (shrinks for up to 2 seconds by default, and fully shrinks when running "shutdown compact"). However empty space is automatically re-used even without closing the database (that's different from versions 1.1.x).
It's possible to implement "shrink while running", however so far I didn't consider this very urgent. There is already a feature request: "Automatically compact databases from time to time (as a background process)." I will add a new request: "Compact databases without having to close the database (vacuum)." (more urgent). Could you explain what is your use case? Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
