On Thu, May 9, 2024 at 02:37:57PM +0800, Richard Guo wrote:
>
> On Thu, May 9, 2024 at 12:04 PM Bruce Momjian <[email protected]> wrote:
>
> I have committed the first draft of the PG 17 release notes; you can
> see the results here:
>
> https://momjian.us/pgsql_docs/release-17.html
>
>
> Thanks for working on that.
>
> For this item:
>
>
> Allow the optimizer to improve CTE plans by using the sort order of
> columns referenced in earlier CTE clauses (Jian Guo)
>
>
> I think you mean a65724dfa. The author should be 'Richard Guo'.
Wow the CTE item above it was done by Jian Guo. I probably copied the
text from the line above it, modified the description, but thought the
author's name was the same, but it was not. Fixed.
> And I'm wondering if it is more accurate to state it as "Allow the
> optimizer to improve plans for the outer query by leveraging the sort
> order of a CTE's output."
>
> I think maybe a similar revision can be applied to the item just above
> this one.
Okay, I went with this text:
<!--
Author: Tom Lane <[email protected]>
2023-11-17 [f7816aec2] Extract column statistics from CTE references,
if possib
-->
<listitem>
<para>
Allow the optimizer to improve CTE plans by considering the statistics
of columns referenced in earlier row output clauses (Jian Guo, Tom Lane)
</para>
</listitem>
<!--
Author: Tom Lane <[email protected]>
2024-03-26 [a65724dfa] Propagate pathkeys from CTEs up to the outer
query.
-->
<listitem>
<para>
Allow the optimizer to improve CTE plans by considering the sort order
of columns referenced in earlier row output clauses (Richard Guo)
</para>
</listitem>
I did not use "leveraging" because I am concerned non-native English
speakers might find the term confusing.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
