| From: | Sergey Koposov <Sergey(dot)Koposov(at)ed(dot)ac(dot)uk> |
|---|---|
| To: | "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <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:44:19 |
| Message-ID: | beb051161520fc48248c2f90582eb15c6a71d239.camel@ed.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, 2025-05-02 at 18:12 -0400, Tom Lane wrote:
> 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) ?
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 buidheann carthannais a th’ ann an Oilthigh Dhùn Èideann, clàraichte an Alba, àireamh clàraidh SC005336.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2025-05-03 01:22:48 | Re: BUG #18741: Detaching a partition referencing a partitioned table fails with a trigger-related error |
| Previous Message | Tom Lane | 2025-05-02 22:12:58 | Re: BUG #18909: Query creates millions of temporary files and stalls |