From aa82ebdc297073ab1bb51cfc0322a6f9e81a13f5 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 2 May 2025 19:58:54 -0400 Subject: [PATCH] doc PG 18 relnotes: reword and reorder items Also move ssl_groups to a more appropriate section. Reported-by: Jacob Champion (ssl_groups item) Discussion: https://postgr.es/m/CAOYmi+k_zpGaDOrwV46_j-O-a_hSWxcXM6h8vccq45Y28deP-g@mail.gmail.com --- doc/src/sgml/release-18.sgml | 347 ++++++++++++++++------------------- 1 file changed, 163 insertions(+), 184 deletions(-) diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 6faca897689..2654960eef8 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -65,8 +65,8 @@ Change time zone abbreviation handling (Tom Lane) -The system will now favor time zone abbreviation for the current session time zone before checking the server variable timezone_abbreviations. Previously timezone_abbreviations were -consulted first for matches. +The system will now favor the current session's time zone abbreviations before checking the server variable timezone_abbreviations. Previously timezone_abbreviations was +checked first. @@ -145,24 +145,12 @@ Author: Fujii Masao -Remove non-functioning support for RULE privileges in GRANT/REVOKE (Fujii Masao) +Remove non-functional support for RULE privileges in GRANT/REVOKE (Fujii Masao) § -These have been non-functioning since Postgres 8.2. - - - - - - - -Rename server variable ssl_ecdh_curve to ssl_groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) -§ +These have been non-functional since Postgres 8.2. @@ -231,7 +219,7 @@ Remove some unnecessary table self-joins (Andrey Lepikhov, Alexander Kuzmenkov, -This optimization can be disabled with server variable enable_self_join_elimination. +This optimization can be disabled using server variable enable_self_join_elimination. @@ -292,7 +280,7 @@ Allow the keys of SELECT DISTINCT to be internally reordered to avoid sorting (R -The optimizer feature can be disabled via enable_distinct_reordering. +This optimization can be disabled using enable_distinct_reordering. @@ -350,7 +338,7 @@ Author: Richard Guo -Allow merge join to use incremental sorts (Richard Guo) +Allow merge joins to use incremental sorts (Richard Guo) § @@ -383,7 +371,7 @@ Author: David Rowley --> -Allow partitions to be pruned earlier and quicker, and skipped in more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley) +Allow partitions to be pruned earlier, quicker, and skipped in more places (Amit Langote, Ashutosh Bapat, Yuya Watari, David Rowley) § § § @@ -402,7 +390,7 @@ Author: Richard Guo -Allow partitionwise join in more cases, and reduce its memory usage (Richard Guo, Tom Lane, Ashutosh Bapat) +Allow partitionwise joins in more cases, and reduce its memory usage (Richard Guo, Tom Lane, Ashutosh Bapat) § § @@ -474,7 +462,7 @@ Allow skip scans of btree indexes (Peter Geoghegan) -This is most useful if the earlier non-referenced columns contain few unique values. +This is effective if the earlier non-referenced columns contain few unique values. @@ -572,7 +560,7 @@ Add an asynchronous I/O subsystem (Andres Freund, Thomas Munro, Nazir Bilal Yavu -This is enabled by default and controlled by server variable io_method with server variables io_combine_limit and io_max_combine_limit added to control it. This also enables +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. @@ -605,8 +593,8 @@ Allow normal vacuums to freeze some pages, even though they are all-visible (Mel -This reduces the overhead of later full-relation freezing. The aggressiveness of this can be controlled by server variable vacuum_max_eager_freeze_failure_rate, and per-table setting -vacuum_max_eager_freeze_failure_rate. Previously vacuum never processed all-visible pages until freezing was required. +This reduces the overhead of later full-relation freezing. The aggressiveness of this can be controlled by server variable and per-table setting vacuum_max_eager_freeze_failure_rate. +Previously vacuum never processed all-visible pages until freezing was required. @@ -622,7 +610,7 @@ Add server variable vacuum_truncate to control file truncation during VACUUM (Na -A storage-level parameter with this name and behavior already existed. +A storage-level parameter with the same name and behavior already existed. @@ -663,7 +651,7 @@ Author: Melanie Plageman -Change server variable log_connections to log connections more granularly (Melanie Plageman) +Increase the logging granularity of server variable log_connections (Melanie Plageman) § § @@ -713,7 +701,7 @@ Modify pg_stat_all_tables and its variants to report the time spent in vacuum, a -The new fields are total_vacuum_time, total_autovacuum_time, total_analyze_time, and total_autoanalyze_time. +The new columns are total_vacuum_time, total_autovacuum_time, total_analyze_time, and total_autoanalyze_time. @@ -726,62 +714,14 @@ Author: Nathan Bossart -Add VACUUM and ANALYZE delay time reporting (Bertrand Drouvot, Nathan Bossart) +Add delay time reporting to VACUUM and ANALYZE (Bertrand Drouvot, Nathan Bossart) § § -This information appears in the autovacuum logs, the system views pg_stat_progress_vacuum and pg_stat_progress_analyze, and the output of VACUUM and ANALYZE when in VERBOSE mode. This -tracking must be enabled with the server variable track_cost_delay_timing. - - - - - - - -Add column pg_stat_checkpointer.num_done to report the number of completed checkpoints (Anton A. Melnikov) -§ - - - -Columns num_timed and num_requested count both completed and skipped checkpoints. - - - - - - - -Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav) -§ - - - -Also, modify the checkpoint server log message to use separate shared buffer and SLRU buffer values. - - - - - - - -Add columns to pg_stat_database to report parallel workers activity (Benoit Lobréau) -§ - - - -The new columns are parallel_workers_to_launch and parallel_workers_launched. +This information appears in the autovacuum logs, the system views pg_stat_progress_vacuum and pg_stat_progress_analyze, and the output of VACUUM and ANALYZE when in VERBOSE +mode; tracking must be enabled with the server variable track_cost_delay_timing. @@ -831,7 +771,7 @@ Author: Michael Paquier -Add wal I/O activity rows to pg_stat_io (Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier) +Add WAL I/O activity rows to pg_stat_io (Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier) § § § @@ -855,6 +795,25 @@ Change server variable track_wal_io_timing to control tracking WAL timing in pg_ + + + + +Remove read/sync columns from pg_stat_wal (Bertrand Drouvot) +§ +§ + + + +This removes columns wal_write, wal_sync, wal_write_time, and wal_sync_time. + + + + + + +Add column pg_stat_checkpointer.num_done to report the number of completed checkpoints (Anton A. Melnikov) +§ + + + +Columns num_timed and num_requested count both completed and skipped checkpoints. + + + + + + + +Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav) +§ + + + +Also, modify the checkpoint server log message to report separate shared buffer and SLRU buffer values. + + + -Remove read/sync fields from pg_stat_wal (Bertrand Drouvot) -§ -§ +Add columns to pg_stat_database to report parallel workers activity (Benoit Lobréau) +§ -This removes columns wal_write, wal_sync, wal_write_time, and wal_sync_time. +The new columns are parallel_workers_to_launch and parallel_workers_launched. @@ -1086,6 +1074,21 @@ Change server variable ssl_groups's default to include elliptic curve X25519 (Da + + + + +Rename server variable ssl_ecdh_curve to ssl_groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) +§ + + +The previous name still works. + + + - - - -Add support for Unicode case folding (Jeff Davis) -§ - - - - @@ -1857,6 +1850,7 @@ Author: Jeff Davis Improve Unicode full case mapping and conversion (Jeff Davis) +§ § @@ -2019,7 +2013,7 @@ Author: Tom Lane -Allow MIN/MAX aggregates on arrays and composite types (Aleksander Alekseev, Marat Buharov) +Allow MIN()/MAX() aggregates on arrays and composite types (Aleksander Alekseev, Marat Buharov) § § @@ -2032,7 +2026,7 @@ Author: Tom Lane -Add a WEEK option to EXTRACT (Tom Lane) +Add a WEEK option to EXTRACT() (Tom Lane) § @@ -2077,7 +2071,7 @@ Add UUID version 7 generation function uuidv7() (Andrey Borodin) -This UUID value is temporally sortable. Function uuidv4() has been added to explicitly generate version 4 UUIDs. +This UUID value is temporally sortable. Function alias uuidv4() has been added to explicitly generate version 4 UUIDs. @@ -2300,7 +2294,7 @@ Author: Michael Paquier -Add psql pipeline status to the prompt and add related state variables (Anthonin Bonnefoy) +Allow adding pipeline status to the psql prompt and add related state variables (Anthonin Bonnefoy) § @@ -2316,23 +2310,11 @@ Author: Michael Paquier -Allow psql to display the connection service name in the psql prompt or access it via psql variable (Michael Banck) +Allow adding the connection service name to the psql prompt or access it via psql variable (Michael Banck) § - - - - -Change psql's \conninfo to use tabular format and include more information (Álvaro Herrera, Maiquel Grassi, Hunaid Sohail) -§ - - - + + + +Change psql's \conninfo to use tabular format and include more information (Álvaro Herrera, Maiquel Grassi, Hunaid Sohail) +§ + + + - - - -Add pg_dump option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart) -§ - - - + + + +Add pg_dump option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart) +§ + + + @@ -2616,22 +2615,11 @@ Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Na § § § +§ -Extended statistics are not preserved. - - - - - - - -Add pg_upgrade option --no-statistics (Corey Huinker, Jeff Davis) -§ +Extended statistics are not preserved. Also add pg_upgrade option --no-statistics to disable statistics preservation. @@ -2744,7 +2732,7 @@ Author: Amit Kapila -Add pg_createsubscriber option -R/--remove to remove publications (Shubham Khanna) +Add pg_createsubscriber option --remove to remove publications (Shubham Khanna) § @@ -3093,23 +3081,14 @@ Add documentation section about API and ABI compatibility (David Wheeler, Peter - - - -Remove configure option --disable-spinlocks (Thomas Munro) -§ - - - - -Remove configure option --disable-atomics (Thomas Munro) +Remove configure options --disable-spinlocks and --disable-atomics (Thomas Munro) +§ § @@ -3125,7 +3104,7 @@ Author: Tom Lane -Remove support for HPPA/PA-RISC architecture (Tom Lane) +Remove support for the HPPA/PA-RISC architecture (Tom Lane) § @@ -3158,7 +3137,7 @@ Author: Robert Haas -Add extension pg_overexplain which allows for additional EXPLAIN output useful for debugging (Robert Haas) +Add extension pg_overexplain which adds debug details to EXPLAIN output (Robert Haas) § @@ -3184,7 +3163,7 @@ Add output columns to postgres_fdw_get_connections() (Hayato Kuroda, Sagar Dilip -New output column "used_in_xact" indicates if the foreign data wrapper is being used by a current transaction, and "closed" indicates if it is closed, "user_name" indicates the +New output column "used_in_xact" indicates if the foreign data wrapper is being used by a current transaction, "closed" indicates if it is closed, "user_name" indicates the user name, and "remote_backend_pid" indicates the remote backend process identifier. @@ -3220,33 +3199,33 @@ Allow SCRAM authentication from the client to be passed to dblink servers (Mathe -Add REJECT_LIMIT to control the number of invalid rows file_fdw can ignore (Atsushi Torikoshi) -§ +Add on_error and log_verbosity options to file_fdw (Atsushi Torikoshi) +§ -This is active when ON_ERROR = 'ignore'. +These control how file_fdw handles and reports invalid file rows. -Add on_error and log_verbosity options to file_fdw (Atsushi Torikoshi) -§ +Add REJECT_LIMIT to control the number of invalid rows file_fdw can ignore (Atsushi Torikoshi) +§ -These control how file_fdw handles and reports invalid file rows. +This is active when ON_ERROR = 'ignore'. @@ -3334,21 +3313,6 @@ The existing function pg_buffercache_evict() now returns the buffer flush status - - - - -Allow extensions to use the server's cumulative statistics API (Michael Paquier) -§ -§ - - - + + + +Allow extensions to use the server's cumulative statistics API (Michael Paquier) +§ +§ + -- 2.30.2