public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: pgsql_tmp consuming most of the space.
Date: Sat, 9 Nov 2024 00:04:09 -0500
Message-ID: <CANzqJaAW1aNcg95N=PEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w@mail.gmail.com> (raw)
In-Reply-To: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com>
References: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com>
On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare <[email protected]>
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!
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql_tmp consuming most of the space.
In-Reply-To: <CANzqJaAW1aNcg95N=PEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox