Re: [h2] In-Memory H2 deleted rows not garbage collected.

2023-05-21 Thread Noel Grandin
(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

Re: [h2] In-Memory H2 deleted rows not garbage collected.

2023-05-21 Thread Andreas Reichel
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

Re: [h2] In-Memory H2 deleted rows not garbage collected.

2023-05-21 Thread Noel Grandin
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