postgres.git / summary / log / commit / refs
commit 191a037d4f2d0a028c19e9ca29da72bc79d2236e
Author: Bruce Momjian <bruce@momjian.us>
Date: Thu Apr 16 16:45:40 2026 +0000
doc PG 19 relnotes: add author and move items
Reported-by: Richard Guo
Author: Richard Guo
Discussion: https://postgr.es/m/CAMbWs4_etzZZPMEzte8hJv2f4Tn6dGskg8v1R_N9uCd2of0kMQ@mail.gmail.com
doc/src/sgml/release-19.sgml | 83 ++++++++++++++++++++++----------------------
1 file changed, 41 insertions(+), 42 deletions(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 4cf1fc44e7e..6dcbebfa5db 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -49,7 +49,6 @@
</para>
<itemizedlist>
-
<!--
Author: Nathan Bossart <nathan@postgresql.org>
2026-02-11 [1d92e0c2c] Add password expiration warnings.
@@ -329,7 +328,7 @@ Author: Richard Guo <rguo@postgresql.org>
<listitem>
<para>
-Allow more LEFT JOINs to be converted to ANTI JOINs (Tender Wang)
+Allow more LEFT JOINs to be converted to ANTI JOINs (Tender Wang, Richard Guo)
<ulink url="&commit_baseurl;cf74558fe">§</ulink>
</para>
</listitem>
@@ -377,7 +376,7 @@ Author: Richard Guo <rguo@postgresql.org>
<listitem>
<para>
-Allow IS [NOT] DISTINCT FROM NULL to be converted to IS [NOT] NULL for proven null arguments (Richard Guo)
+Convert IS [NOT] DISTINCT FROM NULL to IS [NOT] NULL during constant folding (Richard Guo)
<ulink url="&commit_baseurl;f41ab5157">§</ulink>
</para>
@@ -452,6 +451,45 @@ This information is used by the optimizer in planning memory usage.
</para>
</listitem>
+<!--
+Author: Richard Guo <rguo@postgresql.org>
+2026-02-10 [0aaf0de7f] Optimize BooleanTest with non-nullable input
+-->
+
+<listitem>
+<para>
+Simplify IS [NOT] TRUE/FALSE/UNKNOWN to plain boolean expressions when the input is proven non-nullable (Richard Guo)
+<ulink url="&commit_baseurl;0aaf0de7f">§</ulink>
+</para>
+</listitem>
+
+<!--
+Author: Richard Guo <rguo@postgresql.org>
+2025-12-24 [10c4fe074] Simplify COALESCE expressions using non-nullable argumen
+Author: Richard Guo <rguo@postgresql.org>
+2025-12-24 [cb7b7ec7a] Optimize ROW(...) IS [NOT] NULL using non-nullable field
+-->
+
+<listitem>
+<para>
+Simplify COALESCE and ROW(...) IS [NOT] NULL to avoid evaluating unnecessary arguments (Richard Guo)
+<ulink url="&commit_baseurl;10c4fe074">§</ulink>
+<ulink url="&commit_baseurl;cb7b7ec7a">§</ulink>
+</para>
+</listitem>
+
+<!--
+Author: Richard Guo <rguo@postgresql.org>
+2026-02-10 [0a3796125] Optimize IS DISTINCT FROM with non-nullable inputs
+-->
+
+<listitem>
+<para>
+Simplify IS [NOT] DISTINCT FROM to equality/inequality operators when inputs are proven non-nullable (Richard Guo)
+<ulink url="&commit_baseurl;0a3796125">§</ulink>
+</para>
+</listitem>
+
<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-11-19 [057012b20] Speed up eqjoinsel() with lots of MCV entries.
@@ -687,45 +725,6 @@ Previously this always required a table rewrite.
</para>
</listitem>
-<!--
-Author: Richard Guo <rguo@postgresql.org>
-2026-02-10 [0aaf0de7f] Optimize BooleanTest with non-nullable input
--->
-
-<listitem>
-<para>
-Allow IS [NOT] TRUE/FALSE/UNKNOWN to be evaluated earlier for proven non-null arguments (Richard Guo)
-<ulink url="&commit_baseurl;0aaf0de7f">§</ulink>
-</para>
-</listitem>
-
-<!--
-Author: Richard Guo <rguo@postgresql.org>
-2025-12-24 [10c4fe074] Simplify COALESCE expressions using non-nullable argumen
-Author: Richard Guo <rguo@postgresql.org>
-2025-12-24 [cb7b7ec7a] Optimize ROW(...) IS [NOT] NULL using non-nullable field
--->
-
-<listitem>
-<para>
-Simplify COALESCE and ROW(...) IS [NOT] NULL to avoid evaluating unnecessary arguments (Richard Guo)
-<ulink url="&commit_baseurl;10c4fe074">§</ulink>
-<ulink url="&commit_baseurl;cb7b7ec7a">§</ulink>
-</para>
-</listitem>
-
-<!--
-Author: Richard Guo <rguo@postgresql.org>
-2026-02-10 [0a3796125] Optimize IS DISTINCT FROM with non-nullable inputs
--->
-
-<listitem>
-<para>
-Allow IS DISTINCT FROM to be evaluated earlier for non-constant arguments (Richard Guo)
-<ulink url="&commit_baseurl;0a3796125">§</ulink>
-</para>
-</listitem>
-
<!--
Author: Michael Paquier <michael@paquier.xyz>
2026-03-05 [34dfca293] Change default value of default_toast_compression to "lz
[parent: b4c1b2be300e]