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?