For the second time in a few weeks I've got a corrupted database. Each time the corruption occurs when trying to insert (via COPY into) data into a large table and the row count exceeds 100-110M. Each time the database terminates and a restart never allows another connection to the SQL interface.
I've checked and no column is coming close to the 2G limit as well. The largest column is approximately 900M.
My question is this:
Would a switch to version five improve my results? Is version five more stable w.r.t. large (100M+) table handling?
This stability issue is rather disappointing because MonetDB has done so well in all of my other testing. Query performance compared to other (commercial/non-commercial) products was outstanding for result sets of 5 - 750000 rows.
Also, I wish there were better controls over maximum RAM usage.