Hello Everyone, We are using the current H2 version.
We have a purge process that deletes old data every 5 minutes. However, the database size on disk continues to grow until all space is used up. We are running on an embedded Linux system with only about 80GB free. But, we store lots and lots of data. We are using the following connection parameters: DB_CLOSE_DELAY=-1;MV_STORE=true;RETENTION_TIME=0;AUTO_SERVER=TRUE;DEFRAG_ALWAYS=TRUE We are currently shutting down our application once a week only to give h2 a chance to reclaim the deleted data space. We are running h2 inside of Spring and thus the database connection handling is handled by the framework. We have tried performing an occasional SHUTDOWN COMPACT but that jacked up the Spring connection pool. Our next step is to ditch h2 and go to Postgres. H2 is sufficient for what we are using it for excluding the database growth issue. We would like to solve this problem with H2. Any help would be greatly appreciated. Thanks, Mike. -- 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 visit https://groups.google.com/d/msgid/h2-database/9d6c8e75-b121-483c-967d-a16452b30174n%40googlegroups.com.
