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
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
Unfortunately CTE's in H2 are currently pretty bad, and nobody has felt
sufficiently motivated to do the surgery that is necessary to accomodate
them really well.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and
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