Hi Temporary space is reclaimed as soon as possible. No need, not option for users to control those, except for explicitly created SQL tables himself. regards, Martin On 11/9/13 5:08 PM, Ashish Kumar Singh wrote:
Hi ,
While going through below section @ http://www.monetdb.org/book/export/html/242 :
I understand that monetdb can create a lot of intermediates over the period if time, and when memory is limited can keep on consuming hard disk space forever. Is there a way to reclaim this space if I want to?
Running out of diskspace
One of the features of MonetDB's execution model is that all intermediates are materialized as memory mapped files. A consequence of this approach is that when memory is too small to keep them around, they will be swapped to disk by the operating system. This can be seen as a decaying free space and ultimately a full disk. In turn this (should) lead to a single transaction abort and removing its disk claim. Evidently, filling your disk depends on the number of users and the complexity of their queries. It aids to the cost of running COPY INTO and queries concurrently.
If you have limited resources for concurrent access then the monetdb funnel may be an option to serialize the user requests. A single server can have multipled funnels.
Bets Regards,
Ashish
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list