By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Can someone please explain this error

P: n/a
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: 01454 617689
Mob: 07960 321599

---------------------------(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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.