Skip to content

Commit b35f827

Browse files
bmomjianbmomjian
committed
doc: update PG 14 release notes based on current feedback
1 parent 1906cc0 commit b35f827

File tree

1 file changed

+59
-26
lines changed

1 file changed

+59
-26
lines changed

‎doc/src/sgml/release-14.sgml

+59-26
Original file line numberDiff line numberDiff line change
@@ -85,12 +85,12 @@ Author: Alexander Korotkov <akorotkov@postgresql.org>
8585
-->
8686

8787
<para>
88-
Fix to_tsquery() and websearch_to_tsquery() to properly parse certain discarded tokens in quotes (Alexander Korotkov)
88+
Fix to_tsquery() and websearch_to_tsquery() to properly parse query text containing discarded tokens (Alexander Korotkov)
8989
</para>
9090

9191
<para>
92-
Certain discarded tokens, like underscore, caused the output of these functions to produce incorrect tsquery output, e.g., websearch_to_tsquery('"pg_class pg"') used to output '( pg &amp; class )
93-
&lt;-&gt; pg',but now outputs 'pg &lt;-&gt; class &lt;-&gt; pg'.
92+
Certain discarded tokens, like underscore, caused the output of these functions to produce incorrect tsquery output, e.g., both websearch_to_tsquery('"pg_class pg"') and to_tsquery('pg_class &lt;-&gt;
93+
pg') used to output '( pg &amp; class ) &lt;-&gt; pg', but now both output 'pg &lt;-&gt; class &lt;-&gt; pg'.
9494
</para>
9595
</listitem>
9696

@@ -117,11 +117,12 @@ Author: Peter Eisentraut <peter@eisentraut.org>
117117
-->
118118

119119
<para>
120-
Change password_encryption's default to scram-sha-256 (Peter Eisentraut)
120+
Change the default of the password_encryption server parameter to scram-sha-256 (Peter Eisentraut)
121121
</para>
122122

123123
<para>
124124
Previously it was md5. All new passwords will be stored as SHA256 unless this server variable is changed or the password is already md5-hashed.
125+
Also, the legacy (and undocumented) boolean-like values which were previously synonyms of <literal>md5</literal> are no longer accepted.
125126
</para>
126127
</listitem>
127128

@@ -516,7 +517,7 @@ Author: Peter Geoghegan <pg@bowt.ie>
516517
-->
517518

518519
<para>
519-
Allow VACUUM to eagerly add newly deleted btree pages in the free space map (Peter Geoghegan)
520+
Allow VACUUM to eagerly add newly deleted btree pages to the free space map (Peter Geoghegan)
520521
</para>
521522

522523
<para>
@@ -645,6 +646,25 @@ Allow the arbitrary collations of partition boundary values (Tom Lane)
645646
<para>
646647
Previously it had to match the collation of the partition key.
647648
</para>
649+
</listitem>
650+
651+
<listitem>
652+
<!--
653+
Author: Tom Lane <tgl@sss.pgh.pa.us>
654+
2021-03-31 [86dc90056] Rework planning and execution of UPDATE and DELETE.
655+
Author: Tom Lane <tgl@sss.pgh.pa.us>
656+
2021-04-06 [a1115fa07] Postpone some more stuff out of ExecInitModifyTable.
657+
Author: Tom Lane <tgl@sss.pgh.pa.us>
658+
2021-04-06 [c5b7ba4e6] Postpone some stuff out of ExecInitModifyTable.
659+
-->
660+
661+
<para>
662+
Improve the performance of updates/deletes on partitioned tables when only a few partitions are affected (Amit Langote, Tom Lane)
663+
</para>
664+
665+
<para>
666+
This also allows run-time pruning of updates/deletes on partitioned tables.
667+
</para>
648668
</listitem>
649669

650670
</itemizedlist>
@@ -940,6 +960,23 @@ Author: David Rowley <drowley@postgresql.org>
940960
<para>
941961
Allow window functions to perform incremental sorts (David Rowley)
942962
</para>
963+
</listitem>
964+
965+
<listitem>
966+
<!--
967+
Author: Michael Paquier <michael@paquier.xyz>
968+
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization
969+
Author: Michael Paquier <michael@paquier.xyz>
970+
2020-10-23 [783f0cc64] Improve performance of Unicode {de,re}composition in the
971+
-->
972+
973+
<para>
974+
Dramatically improve Unicode normalization (John Naylor)
975+
</para>
976+
977+
<para>
978+
This speeds normalize() and IS NORMALIZED.
979+
</para>
943980
</listitem>
944981

945982
</itemizedlist>
@@ -1159,6 +1196,17 @@ Author: Fujii Masao <fujii@postgresql.org>
11591196
<para>
11601197
Add wait event WalReceiverExit to report WAL receiver exit wait time (Fujii Masao)
11611198
</para>
1199+
</listitem>
1200+
1201+
<listitem>
1202+
<!--
1203+
Author: Peter Eisentraut <peter@eisentraut.org>
1204+
2021-02-17 [f40c6969d] Routine usage information schema tables
1205+
-->
1206+
1207+
<para>
1208+
Implement information schema view routine_column_usage to track columns referenced by function and procedure default expressions (Peter Eisentraut)
1209+
</para>
11621210
</listitem>
11631211

11641212
</itemizedlist>
@@ -1181,7 +1229,7 @@ Allow the certificate's distinguished name (DN) to be matched for client certifi
11811229
</para>
11821230

11831231
<para>
1184-
The new pg_hba.conf keyword "clientname=DN" allows comparison with non-CN certificate attributes and can be combined with ident maps.
1232+
The new pg_hba.conf keyword "clientname=DN" allows comparison with certificate attributes beyond the CN and can be combined with ident maps.
11851233
</para>
11861234
</listitem>
11871235

@@ -1502,7 +1550,7 @@ Author: Amit Kapila <akapila@postgresql.org>
15021550
-->
15031551

15041552
<para>
1505-
Allow logical replication to stream long in-progress transactions to standbys (Tomas Vondra, Dilip Kumar, Amit Kapila, Ajin Cherian, Nikhil Sontakke, Stas Kelvich)
1553+
Allow logical replication to stream long in-progress transactions to subscribers (Tomas Vondra, Dilip Kumar, Amit Kapila, Ajin Cherian, Nikhil Sontakke, Stas Kelvich)
15061554
</para>
15071555

15081556
<para>
@@ -1648,7 +1696,7 @@ Author: Amit Kapila <akapila@postgresql.org>
16481696
-->
16491697

16501698
<para>
1651-
Allow logical decoding to more efficiently process cache invalidation messages
1699+
Allow logical decoding to more efficiently process cache invalidation messages (Dilip Kumar)
16521700
</para>
16531701

16541702
<para>
@@ -2234,7 +2282,7 @@ Add date_bin function (John Naylor)
22342282
</para>
22352283

22362284
<para>
2237-
WHAT DOES THIS DO?
2285+
The function date_bin "bins" the input timestamp into a specified interval aligned with a specified origin.
22382286
</para>
22392287
</listitem>
22402288

@@ -2338,11 +2386,11 @@ Author: Alexander Korotkov <akorotkov@postgresql.org>
23382386
-->
23392387

23402388
<para>
2341-
Allow subscripting of jsonb (Dmitry Dolgov)
2389+
Allow subscripting of JSONB and simplify the implementation of subscripting (Dmitry Dolgov)
23422390
</para>
23432391

23442392
<para>
2345-
Subscripting can be used to extract from and assign to jsonb documents.
2393+
JSONB subscripting can be used to extract from and assign to JSONB documents. Extensions and built-in data types can now implement subscripting more easily.
23462394
</para>
23472395
</listitem>
23482396

@@ -2409,21 +2457,6 @@ Allow more flexible data types for default values of lead() and lag() window fun
24092457
</para>
24102458
</listitem>
24112459

2412-
<listitem>
2413-
<!--
2414-
Author: Michael Paquier <michael@paquier.xyz>
2415-
2020-10-23 [783f0cc64] Improve performance of Unicode {de,re}composition in the
2416-
-->
2417-
2418-
<para>
2419-
Dramatically improve Unicode normalization (John Naylor)
2420-
</para>
2421-
2422-
<para>
2423-
WHAT OPERATIONS USE THIS?
2424-
</para>
2425-
</listitem>
2426-
24272460
<listitem>
24282461
<!--
24292462
Author: Peter Eisentraut <peter@eisentraut.org>

0 commit comments

Comments
 (0)