Search Postgresql Archives

Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings,
A function aborts with the error in the subject line despite the available free space on the disk.
I have a bunch of other questions regarding the underlying reason but first things first: why is pg telling me no space is left on device when there is space?

the only config param I can see relevant to this is temp_file_limit which I've set to -1, but it made no difference. How can I make sure that as long as there is disk space available, I don't get this error?

Regards
Seref


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux