Thank you very much. I'm wondering that this mode is storing data in a file on disk. I thought that it is an in memory off-heap storage layer? Are there some documentations around?
Best, Sebastian Am Samstag, 9. März 2013 08:10:45 UTC+1 schrieb Noel Grandin: > > Java tends to be quite promiscous with it's memory usage. > You could try using the new experimental nioMem: mode, which stores the > data outside the GC heap in the native process heap, but you'd still need > to limit the VM's memory usage with -XMx > > > On Fri, Mar 8, 2013 at 9:40 PM, Sebastian B <[email protected]<javascript:> > > wrote: > >> Hi there, >> >> currently I'm trying to use H2 as a buffer for some read mostly tables in >> an external PostgresSQL database. >> >> The smallest of my data-sources (<VARCHAR, VARCHAR, INT>) got a size of >> around 110MB on disk managed by postgres. >> Now I'm a bit curious, because I can't see why H2 needs around 850 MB to >> represent that data in main memory. >> In addition to the default memory mode, I also tried to use ..:memFS or >> ...memLZF, but couldn't decrease the memory consumption much. >> >> My problem is, that I got some much bigger data-sources as well that I >> have to put into main memory. >> >> Thanks and best regards, >> >> Sebastian >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
