Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql_tmp consuming most of the space. - Mailing list pgsql-general

From Ron Johnson
Subject Re: pgsql_tmp consuming most of the space.
Date
Msg-id CANzqJaAW1aNcg95N=PEH44XFCUhEPsL7rVM4b10kkR0LBgEP0w@mail.gmail.com
Whole thread Raw
In response to pgsql_tmp consuming most of the space.  (jayesh thakare <thakarejayesh700@gmail.com>)
List pgsql-general
Tree view
On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare <thakarejayesh700@gmail.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!

pgsql-general by date:

Previous
From: jayesh thakare
Date:
Subject: pgsql_tmp consuming most of the space.
Next
From: Achilleas Mantzios
Date:
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4