diff options
| author | Bruce Momjian <bruce@momjian.us> | 2025-05-09 23:39:34 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2025-05-09 23:40:02 -0400 |
| commit | 99ddf8615c215bb81655574b9a9f7e8ebb2cb89e (patch) | |
| tree | 2e55e88a7d0a0deed1b24b96c7ca425863345b8f | |
| parent | c259ba881c1098e75b53d5b232600b49e3301058 (diff) | |
| download | postgresql-99ddf8615c215bb81655574b9a9f7e8ebb2cb89e.tar.gz postgresql-99ddf8615c215bb81655574b9a9f7e8ebb2cb89e.zip | |
doc PG 18 relnotes: mv. hash joins and GROUP BY item to General
Reported-by: David Rowley
Discussion: https://postgr.es/m/CAApHDvqJz+Zf7a6abisqoTGottDSRD+YPx=aQSgCsCKD476vGA@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/release-18.sgml | 56 |
1 files changed, 28 insertions, 28 deletions
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 14d6a375bec..cdf47ac6d2a 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -377,34 +377,6 @@ Allow merge joins to use incremental sorts (Richard Guo) </listitem> <!-- -Author: David Rowley <drowley@postgresql.org> -2024-08-20 [adf97c156] Speed up Hash Join by making ExprStates support hashing -Author: David Rowley <drowley@postgresql.org> -2024-12-11 [0f5738202] Use ExprStates for hashing in GROUP BY and SubPlans -Author: Jeff Davis <jdavis@postgresql.org> -2025-03-24 [4d143509c] Create accessor functions for TupleHashEntry. -Author: Jeff Davis <jdavis@postgresql.org> -2025-03-24 [a0942f441] Add ExecCopySlotMinimalTupleExtra(). -Author: Jeff Davis <jdavis@postgresql.org> -2025-03-24 [626df47ad] Remove 'additional' pointer from TupleHashEntryData. ---> - -<listitem> -<para> -Improve the performance and reduce memory usage of hash joins and GROUP BY (David Rowley, Jeff Davis) -<ulink url="&commit_baseurl;adf97c156">§</ulink> -<ulink url="&commit_baseurl;0f5738202">§</ulink> -<ulink url="&commit_baseurl;4d143509c">§</ulink> -<ulink url="&commit_baseurl;a0942f441">§</ulink> -<ulink url="&commit_baseurl;626df47ad">§</ulink> -</para> - -<para> -This also improves hash set operations used by EXCEPT, and hash lookups of subplan values. -</para> -</listitem> - -<!-- Author: Amit Langote <amitlan@postgresql.org> 2025-04-04 [88f55bc97] Make derived clause lookup in EquivalenceClass more effi Author: David Rowley <drowley@postgresql.org> @@ -638,6 +610,34 @@ Avoid the locking of pruned partitions during execution (Amit Langote) </listitem> <!-- +Author: David Rowley <drowley@postgresql.org> +2024-08-20 [adf97c156] Speed up Hash Join by making ExprStates support hashing +Author: David Rowley <drowley@postgresql.org> +2024-12-11 [0f5738202] Use ExprStates for hashing in GROUP BY and SubPlans +Author: Jeff Davis <jdavis@postgresql.org> +2025-03-24 [4d143509c] Create accessor functions for TupleHashEntry. +Author: Jeff Davis <jdavis@postgresql.org> +2025-03-24 [a0942f441] Add ExecCopySlotMinimalTupleExtra(). +Author: Jeff Davis <jdavis@postgresql.org> +2025-03-24 [626df47ad] Remove 'additional' pointer from TupleHashEntryData. +--> + +<listitem> +<para> +Improve the performance and reduce memory usage of hash joins and GROUP BY (David Rowley, Jeff Davis) +<ulink url="&commit_baseurl;adf97c156">§</ulink> +<ulink url="&commit_baseurl;0f5738202">§</ulink> +<ulink url="&commit_baseurl;4d143509c">§</ulink> +<ulink url="&commit_baseurl;a0942f441">§</ulink> +<ulink url="&commit_baseurl;626df47ad">§</ulink> +</para> + +<para> +This also improves hash set operations used by EXCEPT, and hash lookups of subplan values. +</para> +</listitem> + +<!-- Author: Melanie Plageman <melanieplageman@gmail.com> 2025-02-11 [052026c9b] Eagerly scan all-visible pages to amortize aggressive va Author: Melanie Plageman <melanieplageman@gmail.com> |