diff options
| author | Bruce Momjian <bruce@momjian.us> | 2024-05-14 20:36:36 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2024-05-14 20:37:01 -0400 |
| commit | 1a48f8b40dc0fe0af67303d7e05df5f93cad36fb (patch) | |
| tree | 4a54616fb79cb00ed1167d654dfbdb969dc673ce | |
| parent | f535f350c1f9b5a9c4f10583992576c3af505275 (diff) | |
| download | postgresql-1a48f8b40dc0fe0af67303d7e05df5f93cad36fb.tar.gz postgresql-1a48f8b40dc0fe0af67303d7e05df5f93cad36fb.zip | |
doc PG 17 relnotes: add two optimizer items
One is about subqueries becoming joins and the other is about optimizing
LIMIT by improving startup cost.
Reported-by: Andy Fan
Discussion: https://postgr.es/m/87h6f4ncc6.fsf@163.com
Reviewed-by: David Rowley
Backpatch-through: master
| -rw-r--r-- | doc/src/sgml/release-17.sgml | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/doc/src/sgml/release-17.sgml b/doc/src/sgml/release-17.sgml index 38c14970822..fa0a703629c 100644 --- a/doc/src/sgml/release-17.sgml +++ b/doc/src/sgml/release-17.sgml @@ -357,6 +357,28 @@ Improve optimization of range values when using containment operators <@ and </listitem> <!-- +Author: Alexander Korotkov <akorotkov@postgresql.org> +2024-02-15 [9f1337639] Pull up ANY-SUBLINK with the necessary lateral support. +--> + +<listitem> +<para> +Allow correlated IN subqueries to be transformed into joins (Andy Fan, Tom Lane) +</para> +</listitem> + +<!-- +Author: David Rowley <drowley@postgresql.org> +2023-10-05 [a8a968a82] Consider cheap startup paths in add_paths_to_append_rel +--> + +<listitem> +<para> +Improve optimization of the LIMIT clause on partitioned tables, inheritance parents, and UNION ALL queries (Andy Fan, David Rowley) +</para> +</listitem> + +<!-- Author: Tom Lane <tgl@sss.pgh.pa.us> 2023-07-14 [e08d74ca1] Allow plan nodes with initPlans to be considered paralle --> |