pgsql_tmp consuming most of the space.

From: jayesh thakare <thakarejayesh700(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgsql_tmp consuming most of the space.
Date: 2024-11-09 04:40:44
Message-ID: CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-11-09 05:04:09 Re: pgsql_tmp consuming most of the space.
Previous Message ravi k 2024-11-09 03:45:57 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16