dbatoCloud Solution <dbatocloud17@xxxxxxxxx> 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
