v1-0001-Fix-draft-of-PG-19-release-notes.patch
application/octet-stream
Filename: v1-0001-Fix-draft-of-PG-19-release-notes.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v1-0001
Subject: Fix draft of PG 19 release notes
| File | + | − |
|---|---|---|
| doc/src/sgml/release-19.sgml | 41 | 41 |
From a9076dec5e96d073df8825557ac53afa486e34af Mon Sep 17 00:00:00 2001 From: Richard Guo <guofenglinux@gmail.com> Date: Thu, 16 Apr 2026 15:56:32 +0900 Subject: [PATCH v1] Fix draft of PG 19 release notes --- doc/src/sgml/release-19.sgml | 82 ++++++++++++++++++------------------ 1 file changed, 41 insertions(+), 41 deletions(-) diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml index 76bbfc0891d..0016e8ec775 100644 --- a/doc/src/sgml/release-19.sgml +++ b/doc/src/sgml/release-19.sgml @@ -329,7 +329,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 +377,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 +452,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 +726,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 -- 2.39.5 (Apple Git-154)