To be a little more precise, MonetDB is designed from a main-memory perspective and works happily with multiple GB databases. It aggressively use the memory available to keep a hotset readily available in RAM. During query processing, the virtual memory allocated by MonetDB may be much larger then your RAM, because it memory-maps columns. The system keeps an eye on not over-stressing the RAM footprint of the OS platform using operator scheduling. regards, Martin On 6/15/12 8:44 AM, Franck Routier wrote:
I think it is a good monetdb practice to manage the memory monetd is allocated at the OS level. Typically on Linux, you will have to use ulimit. Don't know how (if) your Windows flavour can handle that, but AFAIK, this is the way to go.
Franck
Le 15/06/2012 08:37, Fabian Groffen a écrit :
Hi liangmeng,
On 15-06-2012 09:10:25 +0800, liangmeng wrote:
i'am new here, i install monetdb of windows 64bit version, after copy into table from several very large files(about 10G each), i found that monetdb occupied too much momery, almost 100% of total 32G , and it keeps occupying, after 24hours, it still don't release the memory, what's the matter? MonetDB is a *main-memory* database. It will basically keep as much in memory as it can.
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users