6 Sep
2012
6 Sep
'12
10:28 p.m.
We have MonetDb running in the AWS cloud, with about 32GB of physical RAM. Our process uses COPY INTO every few minutes to load small chunks of data (usually 1000 rows at a time). That seems to work fine. There are a few users running queries against MonetDb, and now at least once/day we have to start/stop MonetDb. We see very high disk I/O (mainly I/O wait), so it appears that memory usage is high and does not get released. We are using the April 2012 release. The JDBC client is used for these queries. Overall MonetDb is doing a very good job, but this slowdown makes it appear unstable to end users. If there are any suggestions on how to improve this please let us know. cmi --