Server - location of tmp database objects
Hello, I was wondering if there is a way to specify for database where to put tmp files? For example when we use temporary tables etc. it is filling our data disk. I have another disk on the machine that I would like to use for temporary tables etc. Thank you for any hints. Best regards, Radovan
Hi
At this moment that feature is not available, It is planned for a future release.
regards, Martin
On 8/27/13 7:39 AM, Radovan Bičiště wrote:
Hello, I was wondering if there is a way to specify for database where to put tmp files? For example when we use temporary tables etc. it is filling our data disk. I have another disk on the machine that I would like to use for temporary tables etc. Thank you for any hints. Best regards, Radovan
If there is consistency with where MonetDB writes the tmp table files, perhaps a short term solution would be a symbolic link to another disk, while leaving the rest of MonetDBs files alone. Is that a possibility?
Sent from my iPhone
On Aug 27, 2013, at 12:40 AM, Martin Kersten Martin.Kersten@cwi.nl wrote:
Hi
At this moment that feature is not available, It is planned for a future release.
regards, Martin
On 8/27/13 7:39 AM, Radovan Bičiště wrote:
Hello, I was wondering if there is a way to specify for database where to put tmp files? For example when we use temporary tables etc. it is filling our data disk. I have another disk on the machine that I would like to use for temporary tables etc. Thank you for any hints. Best regards, Radovan
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 2013-08-27 09:01, Brandon Jackson wrote:
If there is consistency with where MonetDB writes the tmp table files, perhaps a short term solution would be a symbolic link to another disk, while leaving the rest of MonetDBs files alone. Is that a possibility?
I'm afraid not. All files are allocated underneath a subdirectory in the database "farm". The names are based on an internal ID, and these IDs are allocated to both temporary and permanent BATs by a process which doesn't know anything about how the BAT will be used in the future (i.e. whether it is going to be part of a temporary table, intermediate result, or permanent table).
Sent from my iPhone
On Aug 27, 2013, at 12:40 AM, Martin Kersten Martin.Kersten@cwi.nl wrote:
Hi
At this moment that feature is not available, It is planned for a future release.
regards, Martin
On 8/27/13 7:39 AM, Radovan Bičiště wrote:
Hello, I was wondering if there is a way to specify for database where to put tmp files? For example when we use temporary tables etc. it is filling our data disk. I have another disk on the machine that I would like to use for temporary tables etc. Thank you for any hints. Best regards, Radovan
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
participants (4)
-
Brandon Jackson
-
Martin Kersten
-
Radovan Bičiště
-
Sjoerd Mullender