| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Andy Fan <zhihuifan1213(at)163(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: First draft of PG 17 release notes |
| Date: | 2024-05-11 05:57:31 |
| Message-ID: | CAApHDvqAQgq27LgYmJ85VVGTR0=hRW6HHq2oZgK0ZiYC_a+Eww@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 11 May 2024 at 17:32, Andy Fan <zhihuifan1213(at)163(dot)com> wrote:
> Do you think we need to add the following 2 items?
>
> - 9f133763961e280d8ba692bcad0b061b861e9138 this is an optimizer
> transform improvement.
I think this should be in the release notes.
Suggest:
* Allow correlated IN subqueries to be transformed into joins (Andy
Fan, Tom Lane)
> - a8a968a8212ee3ef7f22795c834b33d871fac262 this is an optimizer costing
> improvement.
>
> Both of them can generate a better plan on some cases.
I think this should be present too.
Suggest:
* Improve optimizer's ability to use cheap startup plans when querying
partitioned tables, inheritance parents and for UNION ALL (Andy Fan,
David Rowley)
Both under "E.1.3.1.1. Optimizer"
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey M. Borodin | 2024-05-11 06:45:33 | Re: Weird test mixup |
| Previous Message | Andy Fan | 2024-05-11 05:27:25 | Re: First draft of PG 17 release notes |