Re: PG 18 release notes draft committed

[Amit Langote]

Hi Bruce,

On Fri, May 2, 2025 at 11:44 AM Bruce Momjian <br...@momjian.us> wrote:
> I have committd the first draft of the PG 18 release notes.
>
> I will continue improving it until beta 1, and until the final release.
> I will probably add markup in 1-3 weeks.  Let the feedback begin.  ;-)

Thanks as always for working on this.

I noticed the release notes currently combine several
partition-related commits under one item:

+<!--
+Author: Amit Langote <amit...@postgresql.org>
+2025-01-30 [bb3ec16e1] Move PartitionPruneInfo out of plan nodes into PlannedSt
+Author: Amit Langote <amit...@postgresql.org>
+2025-01-31 [d47cbf474] Perform runtime initial pruning outside ExecInitNode()
+Author: Amit Langote <amit...@postgresql.org>
+2025-02-07 [cbc127917] Track unpruned relids to avoid processing pruned relatio
+Author: Amit Langote <amit...@postgresql.org>
+2025-02-20 [525392d57] Don't lock partitions pruned by initial pruning
+Author: Amit Langote <amit...@postgresql.org>
+2025-04-04 [88f55bc97] Make derived clause lookup in EquivalenceClass more effi
+Author: David Rowley <drow...@postgresql.org>
+2025-04-08 [d69d45a5a] Speedup child EquivalenceMember lookup in planner
+-->
+<listitem>
+<para>
+Allow partitions to be pruned earlier and quicker, and skipped in
more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley)
+<ulink url="&commit_baseurl;bb3ec16e1">&sect;</ulink>
+<ulink url="&commit_baseurl;d47cbf474">&sect;</ulink>
+<ulink url="&commit_baseurl;cbc127917">&sect;</ulink>
+<ulink url="&commit_baseurl;525392d57">&sect;</ulink>
+<ulink url="&commit_baseurl;88f55bc97">&sect;</ulink>
+<ulink url="&commit_baseurl;d69d45a5a">&sect;</ulink>
+</para>
+</listitem>

But I think these really fall into three separate improvements:

1. Speed up execution of cached plans by deferring locks on partitions
subject to pruning (Amit Langote)
(bb3ec16e1, d47cbf474, cbc127917, 525392d57)

2. Speed up child EquivalenceMember lookup in planner (Yuya Watari,
David Rowley)
(d69d45a5a)

3. Speed up derived clause lookup in EquivalenceClass (Ashutosh Bapat)
(88f55bc97)

Alternatively, 2 and 3 can be combined as:

2. Speed up partition planning by improving EquivalenceClass lookups
(Yuya Watari, David Rowley, Ashutosh Bapat)

I think 1 should go under Partitioning, which I see is currently missing.

Any thoughts, David?

Can work on a patch if you'd like.

-- 
Thanks, Amit Langote