Re: [MonetDB-users] Vacuum command missing

2011/7/14 Eugene Prokopiev :

I can't find VACUUM command in http://www.monetdb.org/Documentation, I see only vacuum cleaning algorithm mention in http://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions. So, how can phisicaly delete rows after marking them as deleted?

I see it's impossible now - http://bugs.monetdb.org/show_bug.cgi?id=2541 :( So I have only 2 options: 1) copy all table contents to another table, drop old table, copy again 2) emulate partitions with VIEW AS SELECT * FROM T1 UNION SELECT * FROM T2 UNION ... and drop old partition -- Thanks, Eugene Prokopiev