30 Oct
2013
30 Oct
'13
7:01 p.m.
Hello,
I'm performing some bulk inserts into some tables (COPY INTO). Meanwhile some JOINs between those tables are executed and also some DELETEs.
During this JOIN's, the disk begins to fill up and only stops after there is no more space available (60GB in my case). Same for RAM. After a (long) while the space gets freed up.
The COPY INTO's are done without any significant delay.
The files that use that space are some .tail and .head in the database bat folder.
If the queries are not concurrent there aren't any problems. The JOIN it's not using any PK or FK.
Have some one noticed this before? Should I open a bug report?
Ruben Silva * *