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

2023-05-22 Thread Andrei Tokar
And to confirm that problem is still there, please run it against at least latest released version (2.1.214), or even better against current git build. I have that feeling that you just run queries with LOB in the result which causes extensive LOB cloning. Try to add ;LOB_TIMEOUT=1000 (1 sec

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

2023-05-22 Thread Andreas Reichel
Greetings! On Sun, 2023-05-21 at 23:42 -0700, Arjun Sahoo wrote: > Reproducing the test case is easy, keep on ingesting and deleting > records, you will see the memory usage increasing over time. If if > query the table simultaneously , you will reach the trend faster. You will need to write a