Hi,
I am using Ubuntu 14.04 64 bit (but I have seen the same result for MacOS) and the server version is
# MonetDB 5 server v11.21.5 "Jul2015"
# Serving database 'demo', using 4 threads
# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 3.847 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Thanks,
Alex
Anthony Damico schrieb am 14:54 Dienstag, 13.Oktober 2015:
hi, are you on windows? mserver version?
On Tue, Oct 13, 2015 at 5:46 PM, wrote:
Hi,
Right now I am evaluating MonetDB and try to analyze a dataset that consists of 10 million rows. The data set has 2 tables, table a stores 10 million rows, table b stores 1 million rows.
Both tables are being joined and some statistical values are being calculated (QUARTILE, AVG, SUM and GROUP BY).
MonetDB is promising fast here. When starting up the database and executing the query the result is being returned within 4 seconds.
I tried to execute the same SQL query 1000 times sequentially and to my surprise after the 60th iteration monetDB crashed because of insuffcient disk space.
As far as I read intermediate results are being materialized within the bat folder. The .tail files are not being removed after a query was executed successfully and the files are not even removed after the database conenction is being closed.
When I restart the server (dbfarm) the files are cleaned up perfectly. I am just wondering if this default behaviour can be changed? Are there any ways to enforce cleaning up the files? How to avoid a server crash because of insufficient memory?
For the system I am planning to use monetDB for I am not able to restart the server before I execute the SQL queries.
Thank you very much,
Alex
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
