Postgres Pro
Downloads
Home   >   mailing lists

Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device - Mailing list pgsql-novice

From legrand legrand
Subject Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device
Date
Msg-id 1573595959210-0.post@n3.nabble.com
Whole thread Raw
In response to PSQLException: ERROR: could not write to hash-join temporary file: Nospace left on device  (Calvin Kim <calvinkhkim@gmail.com>)
Responses Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device
List pgsql-novice
Tree view 
Hello,

main problem is that one or many queries have generated more than 2TB of
temp space ...
I would start by querying pg_stat_activity or pg_stat_statements (if
installed and enabled) 
to identify some long queries, then try to understand why it generates so
much hash join temp space  

Regards
PAscal 



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html

pgsql-novice by date:

Previous
From: Calvin Kim
Date:
Subject: PSQLException: ERROR: could not write to hash-join temporary file: Nospace left on device
Next
From: legrand legrand
Date:
Subject: Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device