MIME-Version: 1.0
References: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com>
In-Reply-To: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 9 Nov 2024 00:04:09 -0500
Message-ID: <CANzqJaAW1aNcg95N=PEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w@mail.gmail.com>
Subject: Re: pgsql_tmp consuming most of the space.
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000da079e062673cc6d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAW1aNcg95N%3DPEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w%40mail.gmail.com>
Precedence: bulk

--000000000000da079e062673cc6d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Nov 8, 2024 at 11:51=E2=80=AFPM jayesh thakare <thakarejayesh700@gm=
ail.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?
>


--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000da079e062673cc6d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Nov 8, 2024 at 11:51=E2=80=AFPM j=
ayesh thakare &lt;<a href=3D"mailto:thakarejayesh700@gmail.com">thakarejaye=
sh700@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi all,<div dir=
=3D"auto"><br></div><div dir=3D"auto">In one of our production environment.=
.</div><div dir=3D"auto"><br></div><div dir=3D"auto">pgsql_tmp is taking ab=
out half of the space in FS.</div><div dir=3D"auto">And temp files are from=
 Jan 2024.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Our data fs i=
s about to reach 98% percent..</div><div dir=3D"auto"><br></div><div dir=3D=
"auto">Kindly suggest us what should be done to resolve this issue?</div></=
div></blockquote><div><br></div><div>Delete the pgsql_tmp file from <b>befo=
re</b>=C2=A0the last time the postmaster started.</div><div>=C2=A0</div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=
=3D"auto">pgsql_tmp contains temperorary files during sub query execution. =
Then why files are not getting deleted automatically after query completion=
?<br></div></div></blockquote><div><br></div><div>Queries crashing can caus=
e it.=C2=A0 What version of PG are you running?</div><div>=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"=
auto">What are parameters that can be tuned to solve such issues in future?=
</div><div dir=3D"auto"></div></div></blockquote></div><div><br clear=3D"al=
l"></div><div><br></div><div><br></div><span class=3D"gmail_signature_prefi=
x">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr=
">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39=
;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></d=
iv></div></div>

--000000000000da079e062673cc6d--