I switched to blobs - I'm still seeing 53M of data tied to: >From MAT: Class Name Shallow Heap Retained Heap >>> org.h2.store.PageStore @ 0x163a4590 176 53,714,880 pageStore org.h2.engine.Database @ 0x163a3418 296 71,688 <Java Local> java.lang.Thread @ 0x163ad630 H2 Log Writer 2FF587C5-09FA-4195-A54E-AC5CDE5311AE Thread 104 440 database org.h2.engine.Session @ 0x1640fa78 » 200 928 value java.util.HashMap$Entry @ 0x1640f070 » 24 24 database org.h2.engine.Session @ 0x1640f088 »
On Jun 18, 12:23 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > > If I write to a column of type binary > > You have two options: BLOB and BINARY. The difference is > documented:http://h2database.com/html/datatypes.html#binary_typehttp://h2database.com/html/datatypes.html#blob_type > > > - the document says all the data is stored in memory > > Where exactly does it say that? > > > when are the H2 buffers cleared? > > It depends. There is a cache. I guess your problem is the memory usage > (when are the H2 buffers "freed"). > > > On the next > > write or after the write completes... > > It depends. But about this you shouldn't worry, at least not if you use BLOB. > > > if my value is 2m is it cached on disk or still stored in memory. > > If it's 2 MB, and if you don't have much memory, then you should > probably use BLOB. > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
