dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> writes:
> ERROR: could not write to hash-join temporary file: No space left on device
> Call getNextException to see other errors in the batch.
> (java.sql.BatchUpdateException)
If there's a reasonable amount of free disk space when the problem
query isn't running, this is likely telling you that you have a
query logic error. That is, you're commanding the DB to form some
unreasonably large join product, perhaps as a result of a missing
WHERE constraint.
regards, tom lane