On 06-09-2012 16:28:28 -0600, Cory Isaacson wrote:
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.
Upgrade to Jul2012 release, which includes significant improvements in memory handling.