Hi, >> 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)." >> > > This sound like the feature we're looking for.
I want to make sure there is no misunderstanding: Currently the database file shrinks automatically when the database is closed. To be able to shrink, data from the end of the file is moved to the free space. This reorganization is running for up to one second, that means it may not shrink fully. To shrink it fully, run "shutdown compact". Currently empty space in the database file is re-used at runtime. If you delete a lot of data, and then add a lot of data, the empty space is re-used. The database file only grows if there is no more empty space. What you ask is to automatically shrink the database file without closing the database. Why exactly do you need this feature? Why can't you wait until the database is closed? 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.
