Running on linux, 64-bit kernel, sun jvm 1.6.0, what is the limit of
the total memory that HSQLDB will use for rows in memory?

>From the FAQ (at http://hsqldb.org/web/hsqlFAQ.html):

"The current (1.8.0) size limit of an HSQLDB database is 8GB for all
CACHED tables, 2GB for each TEXT table and less than 2GB for all
memory tables."

But I am not sure this tells me enough about how much will HSQLDB fit
in memory.

If the machine has 8GB of physical RAM and the JVM is set to use all
of it, can HSQLDB go up to, say 6GB, for the rows in memory? This is
provided, of course, that we set the cache numbers appropriately.

Thanks.