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]> 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]. > 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. > > > -- 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.
