diff options
author | Bruce Momjian <bruce@momjian.us> | 2025-05-05 11:59:56 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2025-05-05 11:59:56 -0400 |
commit | cf847d6340a6620251315fccae3bd87d2116d308 (patch) | |
tree | 94a1e0606d51c15d178fea28b905e7279ea92650 | |
parent | 627acc3caa74caa736b2c5587e944d2ea510ea67 (diff) | |
download | postgresql-cf847d6340a6620251315fccae3bd87d2116d308.tar.gz postgresql-cf847d6340a6620251315fccae3bd87d2116d308.zip |
doc PG 18 relnotes: split partition optimizer item into two
Reported-by: David Rowley
Discussion: https://postgr.es/m/CAApHDvohfoJ0D9eiUuVyHU_kq2Y7A_jAjWVsUt0Fm7Gw1Q=1cQ@mail.gmail.com
-rw-r--r-- | doc/src/sgml/release-18.sgml | 24 |
1 files changed, 17 insertions, 7 deletions
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 @@ -374,6 +374,21 @@ Improve the performance of hash joins (David Rowley) <!-- Author: Amit Langote <amitlan@postgresql.org> +2025-04-04 [88f55bc97] Make derived clause lookup in EquivalenceClass more effi +Author: David Rowley <drowley@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 <amitlan@postgresql.org> 2025-01-30 [bb3ec16e1] Move PartitionPruneInfo out of plan nodes into PlannedSt Author: Amit Langote <amitlan@postgresql.org> 2025-01-31 [d47cbf474] Perform runtime initial pruning outside ExecInitNode() @@ -381,20 +396,15 @@ Author: Amit Langote <amitlan@postgresql.org> 2025-02-07 [cbc127917] Track unpruned relids to avoid processing pruned relatio Author: Amit Langote <amitlan@postgresql.org> 2025-02-20 [525392d57] Don't lock partitions pruned by initial pruning -Author: Amit Langote <amitlan@postgresql.org> -2025-04-04 [88f55bc97] Make derived clause lookup in EquivalenceClass more effi -Author: David Rowley <drowley@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> |