Can someone please explain this error

Simon Windsor <simon.windsor@cornfield.org.uk> wrote:

Hi

I have just recevived this error

could not write to hash-join temporary file: No space left on device

Can someone please explain how I can stop this occuring. Whereis the hash-join
temporary file? How can I make it big? etc.

The query question runs fine in Oracle, MySQL and Postgres normally, but I
have seen this error twise recently. I have used df -k to check the
filesystems and none are full, and a Google search has revealed nothing.

How close to full are they? Is it possible that during load they occasionally
fill up for a short period of time, and then other activity cleans up some
files and frees space?

--
Bill Moran
Potential Technologies
http://www.potentialtech.com