Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #18909: Query creates millions of temporary files and stalls
Date
Msg-id 2051617.1746223978@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18909: Query creates millions of temporary files and stalls  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18909: Query creates millions of temporary files and stalls
List pgsql-bugs
Tree view 
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) ?

            regards, tom lane

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18909: Query creates millions of temporary files and stalls
Next
From: Sergey Koposov
Date:
Subject: Re: BUG #18909: Query creates millions of temporary files and stalls