On Mon, May 5, 2025 at 09:42:10PM +1200, David Rowley wrote: > On Fri, 2 May 2025 at 16:01, Amit Langote <amitlangot...@gmail.com> wrote: > > +Allow partitions to be pruned earlier and quicker, and skipped in > > more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley) > > > > Alternatively, 2 and 3 can be combined as: > > > 2. Speed up partition planning by improving EquivalenceClass lookups > > (Yuya Watari, David Rowley, Ashutosh Bapat) > > > Any thoughts, David? > > I agree that 88f55bc97 and d69d45a5a should be in their own item. > Likely no need to go into detail about the speed up being about > "EquivalenceClass lookups". I imagine something like "Reduce planner > overheads when planning queries to partitioned and inheritance parent > tables" > > Then for bb3ec16e1, d47cbf474, cbc127917 and 525392d57, something like > "Defer locking of partitions during execution until after partition > elimination". The release notes for 11.0 called it "partition > elimination", so I went with that naming.
Okay, I split them up and went with the attached patch. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 6054df4f818..86c4a231684 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -372,6 +372,21 @@ Improve the performance of hash joins (David Rowley) </para> </listitem> +<!-- +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 more efficienty (Ashutosh Bapat, Yuya Watari, David Rowley) +<ulink url="&commit_baseurl;88f55bc97">§</ulink> +<ulink url="&commit_baseurl;d69d45a5a">§</ulink> +</para> +</listitem> + <!-- Author: Amit Langote <amit...@postgresql.org> 2025-01-30 [bb3ec16e1] Move PartitionPruneInfo out of plan nodes into PlannedSt @@ -381,20 +396,15 @@ 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, quicker, and skipped in more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley) +Avoid the locking of pruned partitions during planning (Amit Langote) <ulink url="&commit_baseurl;bb3ec16e1">§</ulink> <ulink url="&commit_baseurl;d47cbf474">§</ulink> <ulink url="&commit_baseurl;cbc127917">§</ulink> <ulink url="&commit_baseurl;525392d57">§</ulink> -<ulink url="&commit_baseurl;88f55bc97">§</ulink> -<ulink url="&commit_baseurl;d69d45a5a">§</ulink> </para> </listitem>
