public inbox for [email protected]  

help / color / mirror / Atom feed

From: jayesh thakare <[email protected]>
To: [email protected]
Subject: pgsql_tmp consuming most of the space.
Date: Sat, 9 Nov 2024 10:10:44 +0530
Message-ID: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com> (raw)

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?


pgsql_tmp contains temperorary files during sub query execution. Then why
files are not getting deleted automatically after query completion?


What are parameters that can be tuned to solve such issues in future?



Regards,
Jayeshthakare
Postgresql dba
Clover infotech

view thread (2+ messages)  latest in thread

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: <CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@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