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.
