Re: [h2] In-Memory H2 deleted rows not garbage collected.
(1) That is not expected behaviour, my H2 databases grow to a point and then stabilise (and I run my H2 databases pretty hard) (2) in-memory is slightly different, we have a couple of places where we do things different because we know it's a memory database -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnWxhGSnbE36c5ySxua2M%2BbXT-6LzUS8HHyq1O4Z%2BQsTLw%40mail.gmail.com.
Re: [h2] In-Memory H2 deleted rows not garbage collected.
Noel, question for better understanding please: Would a MEM database not grow exactly as a File backed database keeps growing forever? Or in other words, is there any difference between a MEMORY database and File backed at TEMP FS? I ask because all my file backed H2 databases keep growing and never release all filespace until I export to file, create new and compress. So I would expect the same (mis-) behavior for any memory DB. Setting up a reliable test should be easy: Create a DB, populate with an indexed table and data and run queries continuously for a longer time. Check if size peaks or grows forever. Cheers Andreas -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/725d35848838abedb93e986fe512b580d4415a7b.camel%40manticore-projects.com.
Re: [h2] In-Memory H2 deleted rows not garbage collected.
I don't have any obvious answers. You can try 2 things. First, try building H2 from git master and seeing if the changes since the last official release help. If that doesn't help, we're going to need a standalone test case (no Spring, etc) to reproduce the problem and then we might be able to fix it. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnWR-m8vzvi9LE7XBf59CJRLGz_x_rm2CrauUL%3DchW3O1g%40mail.gmail.com.