Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device
Date: 2019-11-12 21:59:19
Message-ID: 1573595959210-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message legrand legrand 2019-11-12 22:03:12 Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device
Previous Message Calvin Kim 2019-11-12 21:28:05 PSQLException: ERROR: could not write to hash-join temporary file: No space left on device