I have been using MonetDB in production for some time now, and I have nothing to complain about. My database has tables with more than 30 columns and 30 million records, and I perform analysis through cubes in Pentaho / Saiku. I have restarted the server several times before, and never had any problem with data loss. However, after running a query today that was consuming a lot of resources, I decided to stop the database, and when I restarted it, data from some columns have disappeared. How can that happen? Were the data still uncommitted? I am concerned that running the query in MonetDB has changed the data or reorganised the database.
