Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb35f827

Browse files
committed
doc: update PG 14 release notes based on current feedback
1 parent1906cc0 commitb35f827

File tree

1 file changed

+59
-26
lines changed

1 file changed

+59
-26
lines changed

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

Lines changed: 59 additions & 26 deletions
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 parsecertain discarded tokens in quotes (Alexander Korotkov)
88+
Fix to_tsquery() and websearch_to_tsquery() to properly parsequery 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 nowoutputs '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.,bothwebsearch_to_tsquery('"pg_class pg"')and to_tsquery('pg_class &lt;-&gt;
93+
pg') used to output '( pg &amp; class ) &lt;-&gt; pg',but nowboth 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-
Changepassword_encryption's default to scram-sha-256 (Peter Eisentraut)
120+
Changethe 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 pagesin the free space map (Peter Geoghegan)
520+
Allow VACUUM to eagerly add newly deleted btree pagesto 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 withnon-CNcertificate 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 tostandbys (Tomas Vondra, Dilip Kumar, Amit Kapila, Ajin Cherian, Nikhil Sontakke, Stas Kelvich)
1553+
Allow logical replication to stream long in-progress transactions tosubscribers (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 ofjsonb (Dmitry Dolgov)
2389+
Allow subscripting ofJSONB and simplify the implementation of subscripting (Dmitry Dolgov)
23422390
</para>
23432391

23442392
<para>
2345-
Subscriptingcan be used to extract from and assign tojsonb documents.
2393+
JSONB subscriptingcan be used to extract from and assign toJSONB 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)
[8]ページ先頭
©2009-2025 Movatter.jp