Hi If you only delete a portion of table, the deleted row are solely marked as such and space is not reclaimed. If you delete *all* tuples, then the trimming of the table might be postponed until the commit scheduler takes action to realise it in a safe way. regards, Martin On 08/04/14 19:02, Radovan Bičiště wrote:
Hello, Thanks to the great new feature sys.storage() I'm able to see table size. As per documentation I would expect that "DELETE FROM table" without any condition will reclaim the disk space. According the sys.storage() it does not. I tried to delete and than select from sys.storage() and the table size was still the same. Am I doing something wrong? Thank you, Radovan _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list