| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | James Coleman <jtc331(at)gmail(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Parallelize correlated subqueries that execute within each worker |
| Date: | 2023-06-26 06:47:57 |
| Message-ID: | CAMbWs4-=RZ8JKkEzc6qrX_YJbp0WnfM9++2dQHdshsq0bz1+2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jun 12, 2023 at 10:23 AM James Coleman <jtc331(at)gmail(dot)com> wrote:
> BTW are you by any chance testing on ARM macOS? I reproduced the issue
> there, but for some reason I did not reproduce the error (and the plan
> wasn't parallelized) when I tested this on linux. Perhaps I missed
> setting something up; it seems odd.
Hmm, that's weird. I was also testing that query on linux. But please
note that several GUC settings are needed to generate parallel plan for
that query.
set min_parallel_table_scan_size to 0;
set parallel_setup_cost to 0;
set parallel_tuple_cost to 0;
Thanks
Richard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2023-06-26 06:57:56 | Improve comment on cid mapping (was Re: Adding CommandID to heap xlog records) |
| Previous Message | Ronan Dunklau | 2023-06-26 06:38:35 | Re: Add GUC to tune glibc's malloc implementation. |