Bugs item #1651599, was opened at 2007-02-04 05:58 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1651599&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: relational (relational) Assigned to: Niels Nes (nielsnes) Summary: caching of inserts causes extreme memory consumption Initial Comment: I'm not sure if this is a bug, but at least it is very annoying: Depending on the data (on more homogenous data, for example data with less null columns it seems to happen far more slowly), inserting rows into tables fills the memory quite fast. The memory consumption seems to be correlated to the number after "sql_cache.s" in the output lines like "function sql_cache.s54_1(A0:int,A1:int,A2:int,A3:int,A4:int,A5:int,A6:int):void# 0 (s54_1:void)<-(A0:int)(A1:int)(A2:int)(A3:int)(A4:int)(A5:int)(A6:int)" printed when MonetDB5 has been compiled using the -DDEBUG_CALLMAL preprocessor flag, which leads me to the assumption that the inserted rows fill up some kind of row data cache. If this is the intended behavior, it would be fine to know if there is a way to flush the cache (partially?) or otherwise limit or explicitly decrease the memory usage of a running server (maybe using mal/mil). Currently, I'm forced to restart the server periodically. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1651599&group_id=56967 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
