Re: BUG #18909: Query creates millions of temporary files and stalls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: skoposov(at)ed(dot)ac(dot)uk
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18909: Query creates millions of temporary files and stalls
Date: 2025-05-02 22:12:58
Message-ID: 2051617.1746223978@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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) ?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergey Koposov 2025-05-02 22:44:19 Re: BUG #18909: Query creates millions of temporary files and stalls
Previous Message PG Bug reporting form 2025-05-02 18:45:48 BUG #18909: Query creates millions of temporary files and stalls