Home > mailing lists

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

From	jayesh thakare
Subject	pgsql_tmp consuming most of the space.
Date	November 9 10:40:44
Msg-id	CAFhqqtzy+bq3q5=BSGQqqv53G9xse92784r42bLagVyKcx1=eg@mail.gmail.com Whole thread Raw
Responses	Re: pgsql_tmp consuming most of the space.
List	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

From: ravi k
Date: 09 November, 09:45:57
Subject: Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16

From: Ron Johnson
Date: 09 November, 11:04:09
Subject: Re: pgsql_tmp consuming most of the space.