Skip to content

Commit cf109ff

Browse files
bmomjianbmomjian
committed
doc: PG 16 relnotes, misc updates
* document to_reg* accepting OIDs * document pg_log_standby_snapshot() * document pg_input_is_valid() and pg_input_error_info() * handle rename of function to pg_split_walfile_name() * fix character encoding problem for Przemyslaw Sztoch * remove partition section Reported-by: jian he, Tom Lane, Bertrand Drouvot
1 parent 1c006c0 commit cf109ff

File tree

1 file changed

+64
-38
lines changed

1 file changed

+64
-38
lines changed

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

Lines changed: 64 additions & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -91,6 +91,21 @@ Processing such indexes is still possible using REINDEX SYSTEM and reindexedb --
9191
</para>
9292
</listitem>
9393

94+
<!--
95+
Author: Tom Lane <tgl@sss.pgh.pa.us>
96+
2023-01-11 [8bf6ec3ba] Improve handling of inherited GENERATED expressions.
97+
-->
98+
99+
<listitem>
100+
<para>
101+
Tighten GENERATED expression restrictions on inherited and partitioned tables (Amit Langote, Tom Lane)
102+
</para>
103+
104+
<para>
105+
Columns of parent/partitioned and child/partition tables must all have the same generation status, though now the actual generation expressions can be different.
106+
</para>
107+
</listitem>
108+
94109
<!--
95110
Author: Michael Paquier <michael@paquier.xyz>
96111
2023-03-14 [5c1b66280] Rework design of functions in pg_walinspect
@@ -198,41 +213,6 @@ Remove symbolic links for the postmaster binary (Peter Eisentraut)
198213
<sect3 id="release-16-server">
199214
<title>Server</title>
200215

201-
<sect4 id="release-16-partitioning">
202-
<title><link linkend="ddl-partitioning">Partitioning</link></title>
203-
204-
<itemizedlist>
205-
206-
<!--
207-
Author: David Rowley <drowley@postgresql.org>
208-
2022-08-02 [3592e0ff9] Have ExecFindPartition cache the last found partition
209-
-->
210-
211-
<listitem>
212-
<para>
213-
Improve performance by caching RANGE and LIST partition lookups (Amit Langote, Hou Zhijie, David Rowley)
214-
</para>
215-
</listitem>
216-
217-
<!--
218-
Author: Tom Lane <tgl@sss.pgh.pa.us>
219-
2023-01-11 [8bf6ec3ba] Improve handling of inherited GENERATED expressions.
220-
-->
221-
222-
<listitem>
223-
<para>
224-
Tighten GENERATED expression restrictions on inherited and partitioned tables (Amit Langote, Tom Lane)
225-
</para>
226-
227-
<para>
228-
Columns of parent/partitioned and child/partition tables must all have the same generation status, though now the actual generation expressions can be different.
229-
</para>
230-
</listitem>
231-
232-
</itemizedlist>
233-
234-
</sect4>
235-
236216
<sect4 id="release-16-optimizer">
237217
<title>Optimizer</title>
238218

@@ -386,6 +366,17 @@ Allow aggregate functions string_agg() and array_agg() to be parallelized (David
386366
</para>
387367
</listitem>
388368

369+
<!--
370+
Author: David Rowley <drowley@postgresql.org>
371+
2022-08-02 [3592e0ff9] Have ExecFindPartition cache the last found partition
372+
-->
373+
374+
<listitem>
375+
<para>
376+
Improve performance by caching RANGE and LIST partition lookups (Amit Langote, Hou Zhijie, David Rowley)
377+
</para>
378+
</listitem>
379+
389380
<!--
390381
Author: David Rowley <drowley@postgresql.org>
391382
2023-04-07 [1cbbee033] Add VACUUM/ANALYZE BUFFER_USAGE_LIMIT option
@@ -1144,7 +1135,7 @@ Author: Michael Paquier <michael@paquier.xyz>
11441135

11451136
<listitem>
11461137
<para>
1147-
Add function pg_dissect_walfile_name() to report the segment and timeline values of WAL file names (Bharath Rupireddy)
1138+
Add function pg_split_walfile_name() to report the segment and timeline values of WAL file names (Bharath Rupireddy)
11481139
</para>
11491140
</listitem>
11501141

@@ -1299,9 +1290,20 @@ Author: Andres Freund <andres@anarazel.de>
12991290
<para>
13001291
Allow logical decoding on standbys (Bertrand Drouvot, Andres Freund, Amit Khandekar)
13011292
</para>
1293+
</listitem>
1294+
1295+
<!--
1296+
Author: Andres Freund <andres@anarazel.de>
1297+
2023-04-08 [0fdab27ad] Allow logical decoding on standbys
1298+
-->
1299+
1300+
<listitem>
1301+
<para>
1302+
Add function pg_log_standby_snapshot() to force creation of a WAL snapshot (Bertrand Drouvot)
1303+
</para>
13021304

13031305
<para>
1304-
This adds the function pg_log_standby_snapshot(). TEXT?
1306+
WAL snapshots are required for logical slot creation so this function speeds their creation on standbys.
13051307
</para>
13061308
</listitem>
13071309

@@ -1648,6 +1650,19 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
16481650
<para>
16491651
Remove support for datetime input that prefixes year-month-day by Y/M/D (Joseph Koshakow)
16501652
</para>
1653+
</listitem>
1654+
1655+
<!--
1656+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1657+
2022-12-09 [1939d2628] Add test scaffolding for soft error reporting from input
1658+
Author: Michael Paquier <michael@paquier.xyz>
1659+
2023-02-28 [b8da37b3a] Rework pg_input_error_message(), now renamed pg_input_er
1660+
-->
1661+
1662+
<listitem>
1663+
<para>
1664+
Add functions pg_input_is_valid() and pg_input_error_info() to check for type conversion errors (Tom Lane)
1665+
</para>
16511666
</listitem>
16521667

16531668
</itemizedlist>
@@ -1742,7 +1757,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
17421757

17431758
<listitem>
17441759
<para>
1745-
Add functions to add, subtract, and generate timestamptz values in a specified time zone (Przemysław Sztoch, Gurjeet Singh)
1760+
Add functions to add, subtract, and generate timestamptz values in a specified time zone (Przemyslaw Sztoch, Gurjeet Singh)
17461761
</para>
17471762

17481763
<para>
@@ -1881,6 +1896,17 @@ Author: Peter Eisentraut <peter@eisentraut.org>
18811896
<para>
18821897
Add the byte specification ('B') to pg_size_bytes() (Peter Eisentraut)
18831898
</para>
1899+
</listitem>
1900+
1901+
<!--
1902+
Author: Tom Lane <tgl@sss.pgh.pa.us>
1903+
2022-12-27 [3ea7329c9] Simplify the implementations of the to_reg* functions.
1904+
-->
1905+
1906+
<listitem>
1907+
<para>
1908+
Allow to_reg* functions to accept OIDs parameters (Tom Lane)
1909+
</para>
18841910
</listitem>
18851911

18861912
</itemizedlist>

0 commit comments

Comments
 (0)