From: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
---|---|
To: | Manoj Kumar <manojkumar(at)ameyo(dot)com> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16739: Temporary files not deleting from data folder on disk |
Date: | 2020-11-24 18:51:04 |
Message-ID: | CAK-MWwTceRPAzgndNQomRLB_no43EWEAVK=efG8-VabbTVm5Kw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Nov 24, 2020 at 5:57 PM Manoj Kumar <manojkumar(at)ameyo(dot)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
"Доктор, вы мне советовали так не делать, но почему мне по-прежнему больно
когда я так делаю ещё раз?"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-11-24 18:59:02 | Re: BUG #16739: Temporary files not deleting from data folder on disk |
Previous Message | David Zhang | 2020-11-24 18:36:33 | Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted |