Can someone please explain this error

[Simon Windsor]

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.

Simon
--
Simon Windsor
Email: si***********@cornfield.org.uk
Tel: [phone]
Mob: [phone]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Bill Moran]

Simon Windsor <si***********@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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org