Re: 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