Re: BUG #18909: Query creates millions of temporary files and stalls - Mailing list pgsql-bugs

From Sergey Koposov
Subject Re: BUG #18909: Query creates millions of temporary files and stalls
Date
Msg-id beb051161520fc48248c2f90582eb15c6a71d239.camel@ed.ac.uk
Whole thread Raw
In response to Re: BUG #18909: Query creates millions of temporary files and stalls  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18909: Query creates millions of temporary files and stalls
List pgsql-bugs
On Fri, 2025-05-02 at 18:12 -0400, Tom Lane wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
> > I have a query: ...
> > that I ran (from python client), and after it didn't finish in ~ an hour, i
> > started to investigate, finding that the pgsql_tmp folder had 15 million
> > temporary files from that query.
>
> Does it behave any better if you disable parallelism
> (set max_parallel_workers_per_gather = 0) ?

Yes, I've just tried and that also prevents the issue.

   S
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. Is e
buidheanncarthannais a th’ ann an Oilthigh Dhùn Èideann, clàraichte an Alba, àireamh clàraidh SC005336.
 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18909: Query creates millions of temporary files and stalls
Next
From: Tender Wang
Date:
Subject: Re: BUG #18741: Detaching a partition referencing a partitioned table fails with a trigger-related error