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

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device
Дата
Msg-id 1573595959210-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на PSQLException: ERROR: could not write to hash-join temporary file: Nospace left on device  (Calvin Kim <calvinkhkim@gmail.com>)
Ответы Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Calvin Kim
Дата:
Сообщение: PSQLException: ERROR: could not write to hash-join temporary file: Nospace left on device
Следующее
От: legrand legrand
Дата:
Сообщение: Re: PSQLException: ERROR: could not write to hash-join temporaryfile: No space left on device