diff options
Diffstat (limited to 'doc/src/sgml/release-18.sgml')
| -rw-r--r-- | doc/src/sgml/release-18.sgml | 145 |
1 files changed, 77 insertions, 68 deletions
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index cdf47ac6d2a..3315ea52def 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -6,7 +6,7 @@ <formalpara> <title>Release date:</title> - <para>2025-??-??, CURRENT AS OF 2025-05-01</para> + <para>2025-??-??, CURRENT AS OF 2025-05-23</para> </formalpara> <sect2 id="release-18-highlights"> @@ -82,7 +82,8 @@ Deprecate MD5 password authentication (Nathan Bossart) </para> <para> -Warnings generated by their use can be disabled by the server variable md5_password_warnings. +Support for MD5 passwords will be removed in a future major version release. CREATE ROLE and ALTER ROLE now emit deprecation warnings when setting MD5 passwords. +These warnings can be disabled by setting the md5_password_warnings parameter to "off". </para> </listitem> @@ -459,8 +460,6 @@ Author: Peter Geoghegan <pg@bowt.ie> 2025-04-04 [92fe23d93] Add nbtree skip scan optimization. Author: Peter Geoghegan <pg@bowt.ie> 2025-04-04 [8a510275d] Further optimize nbtree search scan key comparisons. -Author: Peter Geoghegan <pg@bowt.ie> -2025-04-04 [8a510275d] Further optimize nbtree search scan key comparisons. --> <listitem> @@ -468,11 +467,11 @@ Author: Peter Geoghegan <pg@bowt.ie> Allow skip scans of btree indexes (Peter Geoghegan) <ulink url="&commit_baseurl;92fe23d93">§</ulink> <ulink url="&commit_baseurl;8a510275d">§</ulink> -<ulink url="&commit_baseurl;8a510275d">§</ulink> </para> <para> -This is effective if the earlier non-referenced columns contain few unique values. +This allows multi-column btree indexes to be used by queries that only +equality-reference the second or later indexed columns. </para> </listitem> @@ -570,6 +569,7 @@ Add an asynchronous I/O subsystem (Andres Freund, Thomas Munro, Nazir Bilal Yavu </para> <para> +This feature allows backends to queue multiple read requests, which allows for more efficient sequential scans, bitmap heap scans, vacuums, etc. This is enabled by server variable io_method, with server variables io_combine_limit and io_max_combine_limit added to control it. This also enables effective_io_concurrency and maintenance_io_concurrency values greater than zero for systems without fadvise() support. The new system view pg_aios shows the file handles being used for asynchronous I/O. @@ -589,27 +589,6 @@ Improve the locking performance of queries that access many relations (Tomas Von </listitem> <!-- -Author: Amit Langote <amitlan@postgresql.org> -2025-01-30 [bb3ec16e1] Move PartitionPruneInfo out of plan nodes into PlannedSt -Author: Amit Langote <amitlan@postgresql.org> -2025-01-31 [d47cbf474] Perform runtime initial pruning outside ExecInitNode() -Author: Amit Langote <amitlan@postgresql.org> -2025-02-07 [cbc127917] Track unpruned relids to avoid processing pruned relatio -Author: Amit Langote <amitlan@postgresql.org> -2025-02-20 [525392d57] Don't lock partitions pruned by initial pruning ---> - -<listitem> -<para> -Avoid the locking of pruned partitions during execution (Amit Langote) -<ulink url="&commit_baseurl;bb3ec16e1">§</ulink> -<ulink url="&commit_baseurl;d47cbf474">§</ulink> -<ulink url="&commit_baseurl;cbc127917">§</ulink> -<ulink url="&commit_baseurl;525392d57">§</ulink> -</para> -</listitem> - -<!-- Author: David Rowley <drowley@postgresql.org> 2024-08-20 [adf97c156] Speed up Hash Join by making ExprStates support hashing Author: David Rowley <drowley@postgresql.org> @@ -704,15 +683,12 @@ This more accurately reflects modern hardware. <!-- Author: Melanie Plageman <melanieplageman@gmail.com> 2025-03-12 [9219093ca] Modularize log_connections output -Author: Melanie Plageman <melanieplageman@gmail.com> -2025-03-12 [18cd15e70] Add connection establishment duration logging --> <listitem> <para> Increase the logging granularity of server variable log_connections (Melanie Plageman) <ulink url="&commit_baseurl;9219093ca">§</ulink> -<ulink url="&commit_baseurl;18cd15e70">§</ulink> </para> <para> @@ -721,6 +697,18 @@ This server variable was previously only boolean; these options are still suppo </listitem> <!-- +Author: Melanie Plageman <melanieplageman@gmail.com> +2025-03-12 [18cd15e70] Add connection establishment duration logging +--> + +<listitem> +<para> +Add log_connections option to report the duration of connection stages (Melanie Plageman) +<ulink url="&commit_baseurl;18cd15e70">§</ulink> +</para> +</listitem> + +<!-- Author: Tom Lane <tgl@sss.pgh.pa.us> 2025-04-07 [3516ea768] Add local-address escape "%L" to log_line_prefix. --> @@ -785,6 +773,33 @@ mode; tracking must be enabled with the server variable track_cost_delay_timing. </listitem> <!-- +Author: Masahiko Sawada <msawada@postgresql.org> +2024-08-13 [4c1b4cdb8] Add resource statistics reporting to ANALYZE VERBOSE. +Author: Masahiko Sawada <msawada@postgresql.org> +2024-09-09 [bb7775234] Add WAL usage reporting to ANALYZE VERBOSE output. +--> + +<listitem> +<para> +Add WAL, CPU, and average read statistics output to ANALYZE VERBOSE (Anthonin Bonnefoy) +<ulink url="&commit_baseurl;4c1b4cdb8">§</ulink> +<ulink url="&commit_baseurl;bb7775234">§</ulink> +</para> +</listitem> + +<!-- +Author: Michael Paquier <michael@paquier.xyz> +2025-02-17 [6a8a7ce47] Add information about WAL buffers full to VACUUM/ANALYZE +--> + +<listitem> +<para> +Add full WAL buffer count to VACUUM/ANALYZE (VERBOSE) and autovacuum log output (Bertrand Drouvot) +<ulink url="&commit_baseurl;6a8a7ce47">§</ulink> +</para> +</listitem> + +<!-- Author: Michael Paquier <michael@paquier.xyz> 2024-12-19 [9aea73fc6] Add backend-level statistics to pgstats Author: Michael Paquier <michael@paquier.xyz> @@ -985,21 +1000,6 @@ This is true even if the tables in different schemas have different column names </listitem> <!-- -Author: Daniel Gustafsson <dgustafsson@postgresql.org> -2025-04-08 [042a66291] Add function to get memory context stats for processes -Author: Daniel Gustafsson <dgustafsson@postgresql.org> -2025-04-08 [c57971034] Rename argument in pg_get_process_memory_contexts(). ---> - -<listitem> -<para> -Add function pg_get_process_memory_contexts() to report process memory context statistics (Rahila Syed) -<ulink url="&commit_baseurl;042a66291">§</ulink> -<ulink url="&commit_baseurl;c57971034">§</ulink> -</para> -</listitem> - -<!-- Author: David Rowley <drowley@postgresql.org> 2024-07-01 [12227a1d5] Add context type field to pg_backend_memory_contexts --> @@ -1250,12 +1250,15 @@ This is useful for operating system configuration. <!-- Author: Peter Eisentraut <peter@eisentraut.org> 2025-03-19 [4f7f7b037] extension_control_path +Author: Peter Eisentraut <peter@eisentraut.org> +2025-05-02 [81eaaa2c4] Make "directory" setting work with extension_control_pat --> <listitem> <para> Add server variable extension_control_path to specify the location of extension control files (Peter Eisentraut, Matheus Alcantara) <ulink url="&commit_baseurl;4f7f7b037">§</ulink> +<ulink url="&commit_baseurl;81eaaa2c4">§</ulink> </para> </listitem> @@ -1339,7 +1342,7 @@ Author: Amit Kapila <akapila@postgresql.org> <listitem> <para> -Change the default CREATE SUBSCRIPTION streaming option from "off" to "parallel" (Hayato Kuroda, Masahiko Sawada, Peter Smith, Amit Kapila) +Change the default CREATE SUBSCRIPTION streaming option from "off" to "parallel" (Vignesh C) <ulink url="&commit_baseurl;1bf1140be">§</ulink> </para> </listitem> @@ -1775,32 +1778,14 @@ Automatically include BUFFERS output in EXPLAIN ANALYZE (Guillaume Lelarge, Davi </listitem> <!-- -Author: Masahiko Sawada <msawada@postgresql.org> -2024-08-13 [4c1b4cdb8] Add resource statistics reporting to ANALYZE VERBOSE. -Author: Masahiko Sawada <msawada@postgresql.org> -2024-09-09 [bb7775234] Add WAL usage reporting to ANALYZE VERBOSE output. ---> - -<listitem> -<para> -Add WAL, CPU, and average read statistics output to EXPLAIN ANALYZE VERBOSE (Anthonin Bonnefoy) -<ulink url="&commit_baseurl;4c1b4cdb8">§</ulink> -<ulink url="&commit_baseurl;bb7775234">§</ulink> -</para> -</listitem> - -<!-- Author: Michael Paquier <michael@paquier.xyz> 2025-02-17 [320545bfc] Add information about WAL buffers being full to EXPLAIN -Author: Michael Paquier <michael@paquier.xyz> -2025-02-17 [6a8a7ce47] Add information about WAL buffers full to VACUUM/ANALYZE --> <listitem> <para> -Add full WAL buffer count to EXPLAIN (WAL), VACUUM/ANALYZE (VERBOSE), and autovacuum log output (Bertrand Drouvot) +Add full WAL buffer count to EXPLAIN (WAL) output (Bertrand Drouvot) <ulink url="&commit_baseurl;320545bfc">§</ulink> -<ulink url="&commit_baseurl;6a8a7ce47">§</ulink> </para> </listitem> @@ -2620,12 +2605,15 @@ Add pg_dump options --with-schema, --with-data, and --with-statistics (Jeff Davi <!-- Author: Nathan Bossart <nathan@postgresql.org> 2025-03-25 [9c49f0e8c] pg_dump: Add - -sequence-data. +Author: Nathan Bossart <nathan@postgresql.org> +2025-05-07 [acea3fc49] pg_dumpall: Add - -sequence-data. --> <listitem> <para> -Add pg_dump option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart) +Add pg_dump and pg_dumpall option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart) <ulink url="&commit_baseurl;9c49f0e8c">§</ulink> +<ulink url="&commit_baseurl;acea3fc49">§</ulink> </para> </listitem> @@ -2777,7 +2765,7 @@ This is to handle cases where a pre-Postgres 18 cluster's default CPU signedness </sect4> <sect4 id="release-18-logicalrep-app"> - <title>Logical Replication Applications></title> + <title>Logical Replication Applications</title> <itemizedlist> @@ -2872,6 +2860,18 @@ Injection points can now be created, but not run, via INJECTION_POINT_LOAD(), an </listitem> <!-- +Author: Michael Paquier <michael@paquier.xyz> +2025-05-10 [371f2db8b] Add support for runtime arguments in injection points +--> + +<listitem> +<para> +Support runtime arguments in injection points (Michael Paquier) +<ulink url="&commit_baseurl;371f2db8b">§</ulink> +</para> +</listitem> + +<!-- Author: Heikki Linnakangas <heikki.linnakangas@iki.fi> 2024-07-26 [20e0e7da9] Add test for early backend startup errors --> @@ -2924,13 +2924,22 @@ Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranm <!-- Author: Dean Rasheed <dean.a.rasheed@gmail.com> +2024-07-09 [ca481d3c9] Optimise numeric multiplication for short inputs. +Author: Dean Rasheed <dean.a.rasheed@gmail.com> +2024-08-15 [c4e44224c] Extend mul_var_short() to 5 and 6-digit inputs. +Author: Dean Rasheed <dean.a.rasheed@gmail.com> 2024-08-15 [8dc28d7eb] Optimise numeric multiplication using base-NBASE^2 arith +Author: Dean Rasheed <dean.a.rasheed@gmail.com> +2024-10-04 [9428c001f] Speed up numeric division by always using the "fast" alg --> <listitem> <para> -Improve the speed of multiplication (Joel Jacobson, Dean Rasheed) +Improve the speed of numeric multiplication and division (Joel Jacobson, Dean Rasheed) +<ulink url="&commit_baseurl;ca481d3c9">§</ulink> +<ulink url="&commit_baseurl;c4e44224c">§</ulink> <ulink url="&commit_baseurl;8dc28d7eb">§</ulink> +<ulink url="&commit_baseurl;9428c001f">§</ulink> </para> </listitem> |