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