Re: BUG #16739: Temporary files not deleting from data folder on disk
| От | Maxim Boguk |
|---|---|
| Тема | Re: BUG #16739: Temporary files not deleting from data folder on disk |
| Дата | |
| Msg-id | CAK-MWwTceRPAzgndNQomRLB_no43EWEAVK=efG8-VabbTVm5Kw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #16739: Temporary files not deleting from data folder on disk (Manoj Kumar <manojkumar@ameyo.com>) |
| Ответы |
Re: BUG #16739: Temporary files not deleting from data folder on disk
|
| Список | pgsql-bugs |
On Tue, Nov 24, 2020 at 5:57 PM Manoj Kumar <manojkumar@ameyo.com> wrote:
I have checked the files, but these files are temporary and vanish once the Postgres service is restarted.
This has been seen many times.
Adding more data to support my point in form of attachment.
It seems that these temp files are the result of normal query execution (and will be cleared when query finishes).
Have you tried enabling log_temp_files and check what query generates these temp files?
It is a very common situation when a single badly written query generates hundred gigabytes of temp files until the end of disk space.
Alternatively, you can try enabling temp_file_limit to limit the maximum size of temp files per query.
Kind regards,
Maxim
Maxim Boguk
Senior Postgresql DBA
https://dataegret.com/
Phone RU: +7 985 433 0000
Phone UA: +380 99 143 0000
Phone AU: +61 45 218 5678
LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
Skype: maxim.boguk
"Доктор, вы мне советовали так не делать, но почему мне по-прежнему больно когда я так делаю ещё раз?"
Senior Postgresql DBA
https://dataegret.com/
Phone RU: +7 985 433 0000
Phone UA: +380 99 143 0000
Phone AU: +61 45 218 5678
LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
Skype: maxim.boguk
"Доктор, вы мне советовали так не делать, но почему мне по-прежнему больно когда я так делаю ещё раз?"
В списке pgsql-bugs по дате отправления: