Plaese see nice recent message here <https://github.com/h2database/h2database/issues/4061#issuecomment-2155993198>. I hope it will help to manage your expectations about database file size. On Monday, June 3, 2024 at 5:32:12 AM UTC-4 Rinse Lemstra wrote:
> My databases (mvstore) are growing rapidly, much more than I would expect > based on the entered data. I also see CPU usage increasing. > > Performing a DEFRAG reduces the database size significantly, sometimes by > 60-70%. Running SCRIPT TO / RUNSCRIPT also has a similar effect. > > How can I identify what 'pollution' is consuming so much space? Browsing > through the INFORMATION_SCHEMA has not provided any clues. > > We recently started using "CREATE MEMORY LOCAL TEMPORARY TABLE IF NOT > EXISTS" more frequently. Could this be related to the problem? > -- 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/dbd67b4e-e095-4548-bed3-55122e4feb9en%40googlegroups.com.
