Also it will be interesting to know if large memory usage is due to intermediate results then when can be expect them to be cleaned?  ON statement and connection close??

Regards,

Ashish

From: Ashish Kumar Singh
Sent: Saturday, November 10, 2012 3:09 PM
To: users-list@monetdb.org
Cc: Ashish Kumar Singh
Subject: Database Memory Usage

HI All,

While calculating monetdb size I am observing below :

When I am inserting records to Monet DB using JDBC total memory  and VM usage is going to 10 G + but when I see file system size of the database directory it is showing something like 1 GB .

Is some compression coming to picture here while storing data in file system?

Any pointers will be helpful.

Regards,

Ashish