Alessandra Bilardi <bilardi(at)cribi(dot)unipd(dot)it> writes:
> ERROR: could not write to hash-join temporary file: No space left on device
Check your queries. I suspect you've written an incorrectly constrained
join that is producing many more rows than you expect.
regards, tom lane