I was trying to copy a part of huge table (create table as select) but I had not enough disk space (I had 30 GB free space ) so before the copy completed I got "lost connection". Therefore, I dropped a table (which has 20 GB) but I still have only 30GB of free space (I've restarted the server ). I've not noticed if I had had this problem before, because I had enough storage space so I'm not sure if I can reproduce the problem (which I still have).
Baraa
> Date: Mon, 1 Dec 2014 09:31:03 +0100
> From: Stefan.Manegold@cwi.nl
> To: users-list@monetdb.org
> Subject: Re: Release Disk Space
>
> Hi Baraa,
>
> if you delete (i.e., drop) a table, MonetDB should free the respective disk space sometime after the drop has been committed.
> If it does not, I consider this a bug.
> If you can repeat the behavior (i.e., disk space not freed after committed drop of a table),
> please file a bug report (including the instructions how to reproduce) via http://bugs.monetdb.org/
>
> For now, you can also try to stop and restart your MonetDB server,
> and see whether this frees up disk space.
> If you do so, please report your opservations.
>
> Thanks!
>
> Best,
> Stefan
>
> ----- Original Message -----
> > Hello,
> > I'm using MonetDB (on ubuntu) for doing some performance tests. I had added
> > and deleted a lot of tables and right now I have no more free disk space
> > since it seems that MonetDB does not clean up disk space after dropping
> > tables.
> >
> > I would like to know the best way to clean up (as much as possible) disk
> > space on MonetDB.
> >
> > Thank you for your help,
> > Baraa
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
>
> --
> | Stefan.Manegold@CWI.nl | DB Architectures (DA) |
> | www.CWI.nl/~manegold/ | Science Park 123 (L321) |
> | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list