Re: Fwd: temp_file_limit?

Поиск
Список
Период
Сортировка
От Frits Jalvingh
Тема Re: Fwd: temp_file_limit?
Дата
Msg-id CAKhTGFWt2wEX73_GaQmXVUvBf2coyufWoNJ2QkHSZkfr3otdtg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: temp_file_limit?  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-performance
@Thomas


Thanks for helping identifying the issue. I think it would be nice to clean up those obsoleted files during the run because running out of disk is reality not a good thing to have ;) Of course the bad estimates leading to the resize are the real issue but this at least makes it less bad.

Thanks for the tip about disabling parallel_hash but I also found it in the source. As mentioned before I disable (on production systems) all parallelism, not just for this issue but to prevent the OOM killer from killing Postgres - which happens way more often with parallelism on...

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

Предыдущее
От: Frits Jalvingh
Дата:
Сообщение: Re: Fwd: temp_file_limit?
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Fwd: temp_file_limit?