Alessandra Bilardi <bilardi@cribi.unipd.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