| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgsql_tmp consuming most of the space. |
| Date: | 2024-11-09 05:04:09 |
| Message-ID: | CANzqJaAW1aNcg95N=PEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare <thakarejayesh700(at)gmail(dot)com>
wrote:
> Hi all,
>
> In one of our production environment..
>
> pgsql_tmp is taking about half of the space in FS.
> And temp files are from Jan 2024.
>
> Our data fs is about to reach 98% percent..
>
> Kindly suggest us what should be done to resolve this issue?
>
Delete the pgsql_tmp file from *before* the last time the postmaster
started.
> pgsql_tmp contains temperorary files during sub query execution. Then why
> files are not getting deleted automatically after query completion?
>
Queries crashing can cause it. What version of PG are you running?
> What are parameters that can be tuned to solve such issues in future?
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2024-11-09 05:46:04 | Re: Can we directly upgrade postgresql from 13 to 15.4 |
| Previous Message | jayesh thakare | 2024-11-09 04:40:44 | pgsql_tmp consuming most of the space. |