decreasing table size
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
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
Hi, Thank you for the explanation. It does not work for us though. We took the approach where we do the following steps: 1. delete all data from the table if there are any. 2. insert data right away. The problem seems to be that we insert data right after the delete. We need to drop the table and create it again if it exists. I assume there is no way to tell the commit scheduler to garbage collect storage immediately. We use the version 11.17.13 (Jan-2014 SP1). Thank you. I really appreciate all your help. Radovan P.S. Can anyone please take a look on the bug 3456 ? It has been there for a couple of weeks. I understand this is an opensource project but I would welcome any leads. On 04/09/2014 12:09 AM, Martin Kersten wrote:
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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Martin Kersten -
Radovan Bičiště