[MonetDB-users] Copy Into and .new files

Hi,

I am doing a lot of COPY INTOs, and I have noticed that sometimes while doing this MonetDB seems to hang while its process memory is slowly rising.

I then noticed that while this is happening, files with a '.new' extension are added to the dbfarm folders.

Now suddenly I reached a state in which no '.new' files are created at all, and the COPY INTOs work much faster because no 'hanging' occurs in which something is loaded into memory.

What's the explanation for this? What can I do in order to always have COPY INTOs write directly to the final files without the '.new' intermediates?

Thanks.