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

Postgres "could not write to hash-join temporary file"

P: 1

We've recently started getting errors like this:
Last error:
ERROR: could not write to hash-join temporary file: No space left on device
But there is plenty of space on the all the drives.

Does anyone know what might be causing this?

My postgres version string is:
"PostgreSQL 7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.3 20041125 (Red Hat 3.4.3-6.EL4)"

Any help much appreciated,
Aug 5 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.