public inbox for [email protected]
help / color / mirror / Atom feedpgsql_tmp consuming most of the space.
2+ messages / 2 participants
[nested] [flat]
* pgsql_tmp consuming most of the space.
@ 2024-11-09 04:40 jayesh thakare <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: jayesh thakare @ 2024-11-09 04:40 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql_tmp consuming most of the space.
@ 2024-11-09 05:04 Ron Johnson <[email protected]>
parent: jayesh thakare <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Ron Johnson @ 2024-11-09 05:04 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <[email protected]>
On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare <[email protected]>
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!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-11-09 05:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-09 04:40 pgsql_tmp consuming most of the space. jayesh thakare <[email protected]>
2024-11-09 05:04 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox