6
6
7
7
<formalpara>
8
8
<title>Release date:</title>
9
- <para>2021-??-?? (AS OF 2021-06-20 )</para>
9
+ <para>2021-??-?? (AS OF 2021-09-18 )</para>
10
10
</formalpara>
11
11
12
12
<sect2>
@@ -411,7 +411,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
411
411
<listitem>
412
412
<!--
413
413
Author: Tom Lane <tgl@sss.pgh.pa.us>
414
- 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
414
+ 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
415
415
-->
416
416
417
417
<para>
@@ -767,7 +767,7 @@ Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
767
767
<listitem>
768
768
<!--
769
769
Author: Fujii Masao <fujii@postgresql.org>
770
- 2020-12-08 [e2ac3fed3] Speed up rechecking if relation needs to be vacuumed or
770
+ 2020-12-08 [e2ac3fed3] Speed up rechecking if relation needs to be vacuumed or
771
771
-->
772
772
773
773
<para>
@@ -858,24 +858,6 @@ Author: Noah Misch <noah@leadboat.com>
858
858
859
859
<listitem>
860
860
<!--
861
- Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
862
- 2021-04-08 [0827e8af7] autovacuum: handle analyze for partitioned tables
863
- -->
864
-
865
- <para>
866
- <link linkend="autovacuum">Autovacuum</link> now analyzes
867
- partitioned tables (Yuzuko Hosoya, Álvaro Herrera)
868
- </para>
869
-
870
- <para>
871
- Insert, update, and delete tuple counts from partitions are now
872
- propagated to their parent tables so autovacuum knows when to
873
- process them.
874
- </para>
875
- </listitem>
876
-
877
- <listitem>
878
- <!--
879
861
Author: Michael Paquier <michael@paquier.xyz>
880
862
2021-03-23 [5aed6a1fc] Add per-index stats information in verbose logs of autov
881
863
-->
@@ -1184,13 +1166,13 @@ Author: David Rowley <drowley@postgresql.org>
1184
1166
-->
1185
1167
1186
1168
<para>
1187
- Add executor method tocache results from the inner- side ofnested
1188
- loopjoins (David Rowley)
1169
+ Add executor method tomemoize results from the inner side ofa
1170
+ nested- loopjoin (David Rowley)
1189
1171
</para>
1190
1172
1191
1173
<para>
1192
1174
This is useful if only a small percentage of rows is checked on
1193
- the inner side and is controlled by <xref
1175
+ the inner side. It can be disabled via <xref
1194
1176
linkend="guc-enable-memoize"/>.
1195
1177
</para>
1196
1178
</listitem>
@@ -1281,7 +1263,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
1281
1263
Author: Tom Lane <tgl@sss.pgh.pa.us>
1282
1264
2021-03-02 [0c3405cf1] Improve performance of regular expression back-reference
1283
1265
Author: Tom Lane <tgl@sss.pgh.pa.us>
1284
- 2021-03-02 [4604f83fd] Suppress unnecessary regex subre nodes in a couple more
1266
+ 2021-03-02 [4604f83fd] Suppress unnecessary regex subre nodes in a couple more
1285
1267
Author: Tom Lane <tgl@sss.pgh.pa.us>
1286
1268
2021-03-08 [6c20bdb2a] Further tweak memory management for regex DFAs.
1287
1269
Author: Tom Lane <tgl@sss.pgh.pa.us>
@@ -1298,7 +1280,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
1298
1280
<listitem>
1299
1281
<!--
1300
1282
Author: Michael Paquier <michael@paquier.xyz>
1301
- 2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization
1283
+ 2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization
1302
1284
Author: Michael Paquier <michael@paquier.xyz>
1303
1285
2020-10-23 [783f0cc64] Improve performance of Unicode {de,re}composition in the
1304
1286
-->
@@ -1613,7 +1595,7 @@ Author: Andrew Dunstan <andrew@dunslane.net>
1613
1595
<listitem>
1614
1596
<!--
1615
1597
Author: Tom Lane <tgl@sss.pgh.pa.us>
1616
- 2020-09-03 [8f8154a50] Allow records to span multiple lines in pg_hba.conf and
1598
+ 2020-09-03 [8f8154a50] Allow records to span multiple lines in pg_hba.conf and
1617
1599
-->
1618
1600
1619
1601
<para>
@@ -1899,7 +1881,7 @@ Author: Thomas Munro <tmunro@postgresql.org>
1899
1881
<listitem>
1900
1882
<!--
1901
1883
Author: Michael Paquier <michael@paquier.xyz>
1902
- 2020-07-12 [b1e48bbe6] Include replication origins in SQL functions for commit
1884
+ 2020-07-12 [b1e48bbe6] Include replication origins in SQL functions for commit
1903
1885
-->
1904
1886
1905
1887
<para>
@@ -1913,7 +1895,7 @@ Author: Michael Paquier <michael@paquier.xyz>
1913
1895
<listitem>
1914
1896
<!--
1915
1897
Author: Michael Paquier <michael@paquier.xyz>
1916
- 2020-07-12 [b1e48bbe6] Include replication origins in SQL functions for commit
1898
+ 2020-07-12 [b1e48bbe6] Include replication origins in SQL functions for commit
1917
1899
-->
1918
1900
1919
1901
<para>
@@ -2131,7 +2113,7 @@ Author: Amit Kapila <akapila@postgresql.org>
2131
2113
<listitem>
2132
2114
<!--
2133
2115
Author: Tom Lane <tgl@sss.pgh.pa.us>
2134
- 2020-09-18 [06a7c3154] Allow most keywords to be used as column labels without
2116
+ 2020-09-18 [06a7c3154] Allow most keywords to be used as column labels without
2135
2117
-->
2136
2118
2137
2119
<para>
@@ -2220,7 +2202,7 @@ Author: Peter Eisentraut <peter@eisentraut.org>
2220
2202
<listitem>
2221
2203
<!--
2222
2204
Author: Tom Lane <tgl@sss.pgh.pa.us>
2223
- 2021-04-13 [6c0373ab7] Allow table-qualified variable names in ON CONFLICT ...
2205
+ 2021-04-13 [6c0373ab7] Allow table-qualified variable names in ON CONFLICT ...
2224
2206
-->
2225
2207
2226
2208
<para>
@@ -2414,7 +2396,7 @@ Author: Peter Eisentraut <peter@eisentraut.org>
2414
2396
Author: Peter Eisentraut <peter@eisentraut.org>
2415
2397
2021-01-30 [dfb75e478] Add primary keys and unique constraints to system catalo
2416
2398
Author: Tom Lane <tgl@sss.pgh.pa.us>
2417
- 2021-02-02 [62f34097c] Build in some knowledge about foreign-key relationships
2399
+ 2021-02-02 [62f34097c] Build in some knowledge about foreign-key relationships
2418
2400
-->
2419
2401
2420
2402
<para>
@@ -2500,6 +2482,8 @@ Author: Alexander Korotkov <akorotkov@postgresql.org>
2500
2482
2020-12-29 [db6335b5b] Add support of multirange matching to the existing range
2501
2483
Author: Alexander Korotkov <akorotkov@postgresql.org>
2502
2484
2020-12-30 [62097a4cc] Fix selectivity estimation @> (anymultirange, anyrange)
2485
+ Author: Alexander Korotkov <akorotkov@postgresql.org>
2486
+ 2021-07-18 [244ad5415] Support for unnest(multirange)
2503
2487
-->
2504
2488
2505
2489
<para>
@@ -2908,7 +2892,7 @@ Author: Peter Eisentraut <peter@eisentraut.org>
2908
2892
<listitem>
2909
2893
<!--
2910
2894
Author: Tom Lane <tgl@sss.pgh.pa.us>
2911
- 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
2895
+ 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
2912
2896
-->
2913
2897
2914
2898
<para>
@@ -2921,7 +2905,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
2921
2905
<listitem>
2922
2906
<!--
2923
2907
Author: Tom Lane <tgl@sss.pgh.pa.us>
2924
- 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
2908
+ 2021-02-25 [2a0af7fe4] Allow complemented character class escapes within regex
2925
2909
-->
2926
2910
2927
2911
<para>
@@ -2986,7 +2970,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
2986
2970
<listitem>
2987
2971
<!--
2988
2972
Author: Tom Lane <tgl@sss.pgh.pa.us>
2989
- 2021-03-08 [fed10d4ee] Properly mark pg_stat_get_subscription() as returning a
2973
+ 2021-03-08 [fed10d4ee] Properly mark pg_stat_get_subscription() as returning a
2990
2974
-->
2991
2975
2992
2976
<para>
@@ -3223,6 +3207,19 @@ Author: Dean Rasheed <dean.a.rasheed@gmail.com>
3223
3207
3224
3208
<listitem>
3225
3209
<!--
3210
+ Author: Fujii Masao <fujii@postgresql.org>
3211
+ 2021-09-01 [d760d942c] pgbench: Fix bug in measurement of disconnection delays.
3212
+ -->
3213
+
3214
+ <para>
3215
+ Include disconnection times in the reconnection overhead measured
3216
+ by <application>pgbench</application> with <option>-C</option>
3217
+ (Yugo Nagata)
3218
+ </para>
3219
+ </listitem>
3220
+
3221
+ <listitem>
3222
+ <!--
3226
3223
Author: Tom Lane <tgl@sss.pgh.pa.us>
3227
3224
2020-09-17 [99175141c] Improve common/logging.c's support for multiple verbosit
3228
3225
-->
@@ -3281,7 +3278,7 @@ Author: Michael Paquier <michael@paquier.xyz>
3281
3278
<listitem>
3282
3279
<!--
3283
3280
Author: Tom Lane <tgl@sss.pgh.pa.us>
3284
- 2021-01-05 [7d80441d2] Allow psql's \dt and \di to show TOAST tables and their
3281
+ 2021-01-05 [7d80441d2] Allow psql's \dt and \di to show TOAST tables and their
3285
3282
-->
3286
3283
3287
3284
<para>
@@ -3357,7 +3354,7 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
3357
3354
Author: Michael Paquier <michael@paquier.xyz>
3358
3355
2020-07-21 [c273d9d8c] Rework tab completion of COPY and \copy in psql
3359
3356
Author: Michael Paquier <michael@paquier.xyz>
3360
- 2020-07-30 [f1af75c5f] Include partitioned tables for tab completion of VACUUM
3357
+ 2020-07-30 [f1af75c5f] Include partitioned tables for tab completion of VACUUM
3361
3358
Author: Michael Paquier <michael@paquier.xyz>
3362
3359
2020-08-11 [1f75b4541] Improve tab completion of REINDEX in psql
3363
3360
Author: Michael Paquier <michael@paquier.xyz>
@@ -3379,13 +3376,13 @@ Author: Thomas Munro <tmunro@postgresql.org>
3379
3376
Author: Fujii Masao <fujii@postgresql.org>
3380
3377
2021-02-25 [6b40d9bdb] Improve tab-completion for TRUNCATE.
3381
3378
Author: Michael Paquier <michael@paquier.xyz>
3382
- 2021-03-19 [5b2266e33] Improve tab completion of IMPORT FOREIGN SCHEMA with \h
3379
+ 2021-03-19 [5b2266e33] Improve tab completion of IMPORT FOREIGN SCHEMA with \h
3383
3380
Author: Tom Lane <tgl@sss.pgh.pa.us>
3384
3381
2021-04-08 [d1fcbde57] Add support for tab-completion of type arguments in \df,
3385
3382
Author: Fujii Masao <fujii@postgresql.org>
3386
3383
2021-04-12 [81e094bdf] Support tab-complete for TRUNCATE on foreign tables.
3387
3384
Author: Michael Paquier <michael@paquier.xyz>
3388
- 2021-04-21 [22b2dec31] Add CURRENT_ROLE to list of roles for tab completion of
3385
+ 2021-04-21 [22b2dec31] Add CURRENT_ROLE to list of roles for tab completion of
3389
3386
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
3390
3387
2021-04-26 [6dd1042ed] psql: tab-complete ALTER ... DETACH CONCURRENTLY / FINAL
3391
3388
Author: Michael Paquier <michael@paquier.xyz>
@@ -3587,15 +3584,21 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
3587
3584
<!--
3588
3585
Author: Peter Eisentraut <peter@eisentraut.org>
3589
3586
2021-01-06 [4656e3d66] Replace CLOBBER_CACHE_ALWAYS with run-time GUC
3587
+ Author: Tom Lane <tgl@sss.pgh.pa.us>
3588
+ 2021-07-01 [d04770801] Add - -clobber-cache option to initdb, for CCA testing.
3589
+ Author: Tom Lane <tgl@sss.pgh.pa.us>
3590
+ 2021-07-13 [6201fa3c1] Rename debug_invalidate_system_caches_always to debug_di
3590
3591
-->
3591
3592
3592
3593
<para>
3593
- Add <xref linkend="guc-debug-discard-caches"/>
3594
+ Add <xref linkend="guc-debug-discard-caches"/> parameter
3594
3595
to control cache flushing for test purposes (Craig Ringer)
3595
3596
</para>
3596
3597
3597
3598
<para>
3598
3599
Previously this behavior could only be set at compile time.
3600
+ To invoke it during <application>initdb</application>, use the new
3601
+ option <option>--discard-caches</option>.
3599
3602
</para>
3600
3603
</listitem>
3601
3604
@@ -3714,6 +3717,30 @@ Author: Tom Lane <tgl@sss.pgh.pa.us>
3714
3717
</para>
3715
3718
</listitem>
3716
3719
3720
+ <listitem>
3721
+ <!--
3722
+ Author: Tom Lane <tgl@sss.pgh.pa.us>
3723
+ 2021-06-19 [6991e774e] Provide feature-test macros for libpq features added in
3724
+ -->
3725
+
3726
+ <para>
3727
+ Provide feature-test macros in <filename>libpq-fe.h</filename>
3728
+ for recently-added <application>libpq</application> features
3729
+ (Tom Lane, Álvaro Herrera)
3730
+ </para>
3731
+
3732
+ <para>
3733
+ Historically, applications have usually used compile-time checks
3734
+ of <literal>PG_VERSION_NUM</literal> to test whether a feature is
3735
+ available. But that's normally the server version, which might
3736
+ not be a good guide to <application>libpq</application>'s
3737
+ version. <filename>libpq-fe.h</filename> now
3738
+ offers <literal>#define</literal> symbols denoting
3739
+ application-visible features added in v14; the intent is to keep
3740
+ adding symbols for such features in future versions.
3741
+ </para>
3742
+ </listitem>
3743
+
3717
3744
</itemizedlist>
3718
3745
3719
3746
</sect3>
@@ -3969,7 +3996,7 @@ Author: Tomas Vondra <tomas.vondra@postgresql.org>
3969
3996
<listitem>
3970
3997
<!--
3971
3998
Author: Fujii Masao <fujii@postgresql.org>
3972
- 2021-04-07 [a3740c48e] postgres_fdw: Allow partitions specified in LIMIT TO to
3999
+ 2021-04-07 [a3740c48e] postgres_fdw: Allow partitions specified in LIMIT TO to
3973
4000
-->
3974
4001
3975
4002
<para>