| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tender Wang <tndrwang(at)gmail(dot)com> |
| Cc: | Tomasz Rybak <tomasz(dot)rybak(at)post(dot)pl>, pgsql-hackers(at)lists(dot)postgresql(dot)org, robertmhaas(at)gmail(dot)com, David Rowley <dgrowleyml(at)gmail(dot)com>, "Fujii(dot)Yuki(at)df(dot)MitsubishiElectric(dot)co(dot)jp" <Fujii(dot)Yuki(at)df(dot)mitsubishielectric(dot)co(dot)jp> |
| Subject: | Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() |
| Date: | 2024-07-06 09:32:41 |
| Message-ID: | CAMbWs48jJHxQfb0F0G1c6O=qgzNxRbJ-uE8FwpH=adAVmvnxSg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jun 19, 2024 at 10:55 AM Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> 于2024年6月18日周二 17:24写道：
>> I updated the patch to include a check in consider_parallel_nestloop
>> ensuring that inner_cheapest_total is not parameterized by outerrel
>> before materializing it. I also tweaked the comments, test cases and
>> commit message.
>
> Thanks for the work. Now it looks better.
> I have changed the status from "need review" to "ready for commiters" on the commitfest.
Here is a new rebase.
I'm planning to push it next week, barring any objections.
Thanks
Richard
| Attachment | Content-Type | Size |
|---|---|---|
| v6-0001-Consider-materializing-the-cheapest-inner-path-in-parallel-nestloop.patch | application/octet-stream | 5.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2024-07-06 09:34:18 | Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. |
| Previous Message | Nitin Jadhav | 2024-07-06 07:28:56 | Re: Show WAL write and fsync stats in pg_stat_io |