Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device
legrand legrand <[email protected]> Tue, 12 Nov 2019 14:59:19 -0700 (MST)
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <[email protected]> |
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