From bb43c97babdf09efbd97bb535d2acb522678f977 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 17 Jun 2025 20:00:38 -0400 Subject: [PATCH] doc PG 18 relnotes: add markup, still need to add links --- doc/src/sgml/release-18.sgml | 545 ++++++++++++++++++----------------- 1 file changed, 274 insertions(+), 271 deletions(-) diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 0b49e237216..ab83b155400 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -60,13 +60,13 @@ Author: Peter Eisentraut -Change initdb default to enable data checksums (Greg Sabino Mullane) +Change initdb default to enable data checksums (Greg Sabino Mullane) § -Checksums can be disabled with the new initdb option --no-data-checksums. -pg_upgrade requires matching cluster checksum settings, so this new +Checksums can be disabled with the new initdb option . +pg_upgrade requires matching cluster checksum settings, so this new option can be useful to upgrade non-checksum old clusters. @@ -83,7 +83,7 @@ Change time zone abbreviation handling (Tom Lane) -The system will now favor the current session's time zone abbreviations before checking the server variable timezone_abbreviations. Previously timezone_abbreviations was +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. @@ -100,8 +100,8 @@ Deprecate MD5 password authentication (Nathan Bossart) -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". +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. @@ -112,12 +112,12 @@ Author: David Rowley -Change VACUUM and ANALYZE to process the inheritance children of a parent (Michael Harris) +Change VACUUM and ANALYZE to process the inheritance children of a parent (Michael Harris) § -The previous behavior can be performed by using the new ONLY option. +The previous behavior can be performed by using the new ONLY option. @@ -130,14 +130,15 @@ Author: Tom Lane -Prevent COPY FROM from treating \. as an end-of-file marker when reading CSV files (Daniel Vérité, Tom Lane) +Prevent COPY FROM from treating \. as an end-of-file marker when reading CSV files (Daniel Vérité, Tom Lane) § § -psql will still treat \. as an end-of-file marker when reading CSV files from STDIN. Older psql clients connecting to Postgres 18 servers might experience \copy problems. This -release also enforces that \. must appear alone on a line. +psql will still treat \. as an end-of-file marker when reading CSV files from STDIN. Older psql clients connecting to PostgreSQL 18 servers might +experience \copy problems. This +release also enforces that \. must appear alone on a line. @@ -153,7 +154,7 @@ Disallow unlogged partitioned tables (Michael Paquier) -Previously ALTER TABLE SET [UN]LOGGED did nothing, and the creation of an unlogged partitioned table did not cause its children to be unlogged. +Previously ALTER TABLE SET [UN]LOGGED did nothing, and the creation of an unlogged partitioned table did not cause its children to be unlogged. @@ -164,12 +165,12 @@ Author: Tom Lane -Execute AFTER triggers as the role that was active when trigger events were queued (Laurenz Albe) +Execute AFTER triggers as the role that was active when trigger events were queued (Laurenz Albe) § -Previously such triggers were run as the role that was active at trigger execution time (e.g., at COMMIT). This is significant for cases where the role is changed between queue time and +Previously such triggers were run as the role that was active at trigger execution time (e.g., at COMMIT). This is significant for cases where the role is changed between queue time and transaction commit. @@ -181,12 +182,12 @@ Author: Fujii Masao -Remove non-functional 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-functional since Postgres 8.2. +These have been non-functional since PostgreSQL 8.2. @@ -197,12 +198,12 @@ Author: David Rowley -Remove column pg_backend_memory_contexts.parent (Melih Mutlu) +Remove column pg_backend_memory_contexts.parent (Melih Mutlu) § -This is now longer needed since pg_backend_memory_contexts.path was added. +This is no longer needed since pg_backend_memory_contexts.path was added. @@ -218,7 +219,7 @@ Author: Fujii Masao -Change pg_backend_memory_contexts.level and pg_log_backend_memory_contexts() to be one-based (Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao) +Change pg_backend_memory_contexts.level and pg_log_backend_memory_contexts() to be one-based (Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao) § § § @@ -257,12 +258,12 @@ Author: Alexander Korotkov -Remove some unnecessary table self-joins (Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina) +Automatically remove some unnecessary table self-joins (Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina) § -This optimization can be disabled using server variable enable_self_join_elimination. +This optimization can be disabled using server variable enable_self_join_elimination. @@ -273,7 +274,7 @@ Author: Alexander Korotkov -Convert some 'IN (VALUES ...)' to 'x = ANY ...' for better optimizer statistics (Alena Rybakina, Andrei Lepikhov) +Convert some IN (VALUES ...) to x = ANY ... for better optimizer statistics (Alena Rybakina, Andrei Lepikhov) § @@ -285,7 +286,7 @@ Author: Alexander Korotkov -Allow transforming OR-clauses to arrays for faster index processing (Alexander Korotkov, Andrey Lepikhov) +Allow transforming OR-clauses to arrays for faster index processing (Alexander Korotkov, Andrey Lepikhov) § @@ -303,7 +304,7 @@ Author: David Rowley -Speed up the processing of INTERSECT, EXCEPT, window aggregates, and view column aliases (Tom Lane, David Rowley) +Speed up the processing of INTERSECT, EXCEPT, window aggregates, and view column aliases (Tom Lane, David Rowley) § § § @@ -318,12 +319,12 @@ Author: Richard Guo -Allow the keys of SELECT DISTINCT to be internally reordered to avoid sorting (Richard Guo) +Allow the keys of SELECT DISTINCT to be internally reordered to avoid sorting (Richard Guo) § -This optimization can be disabled using enable_distinct_reordering. +This optimization can be disabled using enable_distinct_reordering. @@ -334,12 +335,12 @@ Author: David Rowley -Ignore GROUP BY columns that are functionally dependent on other columns (Zhang Mingli, Jian He, David Rowley) +Ignore GROUP BY columns that are functionally dependent on other columns (Zhang Mingli, Jian He, David Rowley) § -If a GROUP BY clause includes all columns of a unique index, as well as other columns of the same table, those other columns are redundant and can be dropped +If a GROUP BY clause includes all columns of a unique index, as well as other columns of the same table, those other columns are redundant and can be dropped from the grouping. This was already true for non-deferred primary keys. @@ -357,7 +358,7 @@ Author: Richard Guo -Allow some HAVING clauses on GROUPING SETS to be pushed to WHERE clauses (Richard Guo) +Allow some HAVING clauses on GROUPING SETS to be pushed to WHERE clauses (Richard Guo) § § § @@ -365,7 +366,7 @@ Allow some HAVING clauses on GROUPING SETS to be pushed to WHERE clauses (Richar -This allows earlier row filtering. This release also fixes some GROUPING SETS queries that used to return incorrect results. +This allows earlier row filtering. This release also fixes some GROUPING SETS queries that used to return incorrect results. @@ -378,7 +379,7 @@ Author: Dean Rasheed -Improve row estimates for generate_series() using numeric and timestamp values (David Rowley, Song Jinzhou) +Improve row estimates for generate_series() using numeric and timestamp values (David Rowley, Song Jinzhou) § § @@ -391,7 +392,7 @@ Author: Richard Guo -Allow the optimizer to use "Right Semi Join" plans (Richard Guo) +Allow the optimizer to use Right Semi Join plans (Richard Guo) § @@ -463,7 +464,7 @@ Author: Tom Lane -Improve SQL-language function plan caching (Alexander Pyhalov, Tom Lane) +Improve SQL-language function plan caching (Alexander Pyhalov, Tom Lane) § § @@ -536,7 +537,7 @@ Author: Tomas Vondra -Allow GIN indexes to be created in parallel (Tomas Vondra, Matthias van de Meent) +Allow GIN indexes to be created in parallel (Tomas Vondra, Matthias van de Meent) § @@ -548,7 +549,7 @@ Author: Heikki Linnakangas -Allow values to be sorted to speed rangetype GiST and btree index builds (Bernd Helmle) +Allow values to be sorted to speed range-type GiST and btree index builds (Bernd Helmle) § @@ -605,8 +606,8 @@ Add an asynchronous I/O subsystem (Andres Freund, Thomas Munro, Nazir Bilal Yavu 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 +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. @@ -638,7 +639,7 @@ Author: Jeff Davis -Improve the performance and reduce memory usage of hash joins and GROUP BY (David Rowley, Jeff Davis) +Improve the performance and reduce memory usage of hash joins and GROUP BY (David Rowley, Jeff Davis) § § § @@ -647,7 +648,7 @@ Improve the performance and reduce memory usage of hash joins and GROUP BY (Davi -This also improves hash set operations used by EXCEPT, and hash lookups of subplan values. +This also improves hash set operations used by EXCEPT, and hash lookups of subplan values. @@ -666,7 +667,7 @@ 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 and per-table setting vacuum_max_eager_freeze_failure_rate. +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. @@ -678,7 +679,7 @@ Author: Nathan Bossart -Add server variable vacuum_truncate to control file truncation during VACUUM (Nathan Bossart, Gurjeet Singh) +Add server variable vacuum_truncate to control file truncation during VACUUM (Nathan Bossart, Gurjeet Singh) § @@ -696,7 +697,7 @@ Author: Melanie Plageman -Increase server variables effective_io_concurrency's and maintenance_io_concurrency's default values to 16 (Melanie Plageman) +Increase server variables effective_io_concurrency's and maintenance_io_concurrency's default values to 16 (Melanie Plageman) § § @@ -722,7 +723,7 @@ Author: Melanie Plageman -Increase the logging granularity of server variable log_connections (Melanie Plageman) +Increase the logging granularity of server variable log_connections (Melanie Plageman) § @@ -738,7 +739,7 @@ Author: Melanie Plageman -Add log_connections option to report the duration of connection stages (Melanie Plageman) +Add log_connections option to report the duration of connection stages (Melanie Plageman) § @@ -750,7 +751,7 @@ Author: Tom Lane -Add log_line_prefix escape "%L" to output the client IP address (Greg Sabino Mullane) +Add log_line_prefix escape %L to output the client IP address (Greg Sabino Mullane) § @@ -762,12 +763,12 @@ Author: Fujii Masao -Add server variable log_lock_failures to log lock acquisition failures (Yuki Seino) +Add server variable log_lock_failures to log lock acquisition failures (Yuki Seino) § -Specifically it reports SELECT ... NOWAIT lock failures. +Specifically it reports SELECT ... NOWAIT lock failures. @@ -778,12 +779,12 @@ Author: Michael Paquier -Modify pg_stat_all_tables and its variants to report the time spent in vacuum, analyze, and their automatic variants (Sami Imseih) +Modify pg_stat_all_tables and its variants to report the time spent in VACUUM, ANALYZE, and their automatic variants (Sami Imseih) § -The new columns 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. @@ -796,14 +797,14 @@ Author: Nathan Bossart -Add delay time reporting to VACUUM and ANALYZE (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; tracking must be enabled with the server variable track_cost_delay_timing. +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. @@ -816,7 +817,7 @@ Author: Masahiko Sawada -Add WAL, CPU, and average read statistics output to ANALYZE VERBOSE (Anthonin Bonnefoy) +Add WAL, CPU, and average read statistics output to ANALYZE VERBOSE (Anthonin Bonnefoy) § § @@ -829,7 +830,7 @@ Author: Michael Paquier -Add full WAL buffer count to VACUUM/ANALYZE (VERBOSE) and autovacuum log output (Bertrand Drouvot) +Add full WAL buffer count to VACUUM/ANALYZE (VERBOSE) and autovacuum log output (Bertrand Drouvot) § @@ -849,7 +850,7 @@ Add per-backend I/O statistics reporting (Bertrand Drouvot) -The statistics are accessed via pg_stat_get_backend_io(). Per-backend I/O statistics can be cleared via pg_stat_reset_backend_stats(). +The statistics are accessed via pg_stat_get_backend_io(). Per-backend I/O statistics can be cleared via pg_stat_reset_backend_stats(). @@ -860,12 +861,12 @@ Author: Michael Paquier -Add pg_stat_io columns to report I/O activity in bytes (Nazir Bilal Yavuz) +Add pg_stat_io columns to report I/O activity in bytes (Nazir Bilal Yavuz) § -The new columns are read_bytes, write_bytes, and extend_bytes. The op_bytes column, which always equaled BLCKSZ, has been removed. +The new columns are read_bytes, write_bytes, and extend_bytes. The op_bytes column, which always equaled BLCKSZ, has been removed. @@ -880,14 +881,14 @@ 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) § § § -This includes WAL receiver activity and a wait event for such writes. +This includes WAL receiver activity and a wait event for such writes. @@ -899,7 +900,7 @@ Author: Michael Paquier -Change server variable track_wal_io_timing to control tracking WAL timing in pg_stat_io instead of pg_stat_wal (Bertrand Drouvot) +Change server variable track_wal_io_timing to control tracking WAL timing in pg_stat_io instead of pg_stat_wal (Bertrand Drouvot) § @@ -913,13 +914,13 @@ Author: Michael Paquier -Remove read/sync columns from pg_stat_wal (Bertrand Drouvot) +Remove read/sync columns from pg_stat_wal (Bertrand Drouvot) § § -This removes columns wal_write, wal_sync, wal_write_time, and wal_sync_time. +This removes columns wal_write, wal_sync, wal_write_time, and wal_sync_time. @@ -930,12 +931,12 @@ Author: Michael Paquier -Add function pg_stat_get_backend_wal() to return per-backend WAL statistics (Bertrand Drouvot) +Add function pg_stat_get_backend_wal() to return per-backend WAL statistics (Bertrand Drouvot) § -Per-backend WAL statistics can be cleared via pg_stat_reset_backend_stats(). +Per-backend WAL statistics can be cleared via pg_stat_reset_backend_stats(). @@ -946,7 +947,7 @@ Author: Nathan Bossart -Add function pg_ls_summariesdir() to specifically list the contents of PGDATA/pg_wal/summaries (Yushi Ogiwara) +Add function pg_ls_summariesdir() to specifically list the contents of PGDATA/pg_wal/summaries (Yushi Ogiwara) § @@ -958,12 +959,12 @@ Author: Fujii Masao -Add column pg_stat_checkpointer.num_done to report the number of completed checkpoints (Anton A. Melnikov) +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. +Columns num_timed and num_requested count both completed and skipped checkpoints. @@ -974,12 +975,12 @@ Author: Fujii Masao -Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav) +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. +Also, modify the checkpoint server log message to report separate shared buffer and SLRU buffer values. @@ -990,12 +991,12 @@ Author: Michael Paquier -Add columns to pg_stat_database to report parallel workers activity (Benoit Lobréau) +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. +The new columns are parallel_workers_to_launch and parallel_workers_launched. @@ -1014,7 +1015,7 @@ Have query jumbling of arrays consider only the first and last array elements (D -Jumbling is used by pg_stat_statements. +Jumbling is used by pg_stat_statements. @@ -1041,7 +1042,7 @@ Author: David Rowley -Add column pg_backend_memory_contexts.type to report the type of memory context (David Rowley) +Add column pg_backend_memory_contexts.type to report the type of memory context (David Rowley) § @@ -1053,7 +1054,7 @@ Author: David Rowley -Add column pg_backend_memory_contexts.path to show memory context parents (Melih Mutlu) +Add column pg_backend_memory_contexts.path to show memory context parents (Melih Mutlu) § @@ -1076,7 +1077,7 @@ Author: Michael Paquier -Add function pg_get_acl() to retrieve database access control details (Joel Jacobson) +Add function pg_get_acl() to retrieve database access control details (Joel Jacobson) § § @@ -1089,7 +1090,7 @@ Author: Fujii Masao -Add function has_largeobject_privilege() to check large object privileges (Yugo Nagata) +Add function has_largeobject_privilege() to check large object privileges (Yugo Nagata) § @@ -1101,7 +1102,7 @@ Author: Fujii Masao -Allow ALTER DEFAULT PRIVILEGES to define large object default privileges (Takatsuka Haruka, Yugo Nagata, Laurenz Albe) +Allow ALTER DEFAULT PRIVILEGES to define large object default privileges (Takatsuka Haruka, Yugo Nagata, Laurenz Albe) § @@ -1113,7 +1114,7 @@ Author: Nathan Bossart -Add predefined role pg_signal_autovacuum_worker (Kirill Reshke) +Add predefined role pg_signal_autovacuum_worker (Kirill Reshke) § @@ -1143,8 +1144,8 @@ Add support for the OAuth authentication method (Jacob Champion, Daniel Gustafss -This adds an "oauth" authentication method to pg_hba.conf, libpq OAuth options, a server variable oauth_validator_libraries to load token validation libraries, and -a configure flag --with-libcurl to add the required compile-time libraries. +This adds an oauth authentication method to pg_hba.conf, libpq OAuth options, a server variable oauth_validator_libraries to load token validation libraries, and +a configure flag to add the required compile-time libraries. @@ -1155,7 +1156,7 @@ Author: Daniel Gustafsson -Add server variable ssl_tls13_ciphers to allow specification of multiple colon-separated TLSv1.3 cipher suites (Erica Zhang, Daniel Gustafsson) +Add server variable ssl_tls13_ciphers to allow specification of multiple colon-separated TLSv1.3 cipher suites (Erica Zhang, Daniel Gustafsson) § @@ -1167,7 +1168,7 @@ Author: Daniel Gustafsson -Change server variable ssl_groups's default to include elliptic curve X25519 (Daniel Gustafsson, Jacob Champion) +Change server variable ssl_groups's default to include elliptic curve X25519 (Daniel Gustafsson, Jacob Champion) § @@ -1179,7 +1180,7 @@ Author: Daniel Gustafsson -Rename server variable ssl_ecdh_curve to ssl_groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) +Rename server variable ssl_ecdh_curve to ssl_groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) § @@ -1194,7 +1195,7 @@ Author: Daniel Gustafsson -Add function pg_check_fipsmode() to report the server's FIPS mode (Daniel Gustafsson) +Add function pg_check_fipsmode() to report the server's FIPS mode (Daniel Gustafsson) § @@ -1225,12 +1226,12 @@ Author: Nathan Bossart -Add server variable autovacuum_worker_slots to specify the maximum number of background workers (Nathan Bossart) +Add server variable autovacuum_worker_slots to specify the maximum number of background workers (Nathan Bossart) § -With this variable set, autovacuum_max_workers can be adjusted at runtime up to this maximum without a server restart. +With this variable set, autovacuum_max_workers can be adjusted at runtime up to this maximum without a server restart. @@ -1246,7 +1247,7 @@ Allow specification of the fixed number of dead tuples that will trigger an auto -The server variable is autovacuum_vacuum_max_threshold. Percentages are still used for triggering. +The server variable is autovacuum_vacuum_max_threshold. Percentages are still used for triggering. @@ -1257,7 +1258,7 @@ Author: Andres Freund -Change server variable max_files_per_process to limit only files opened by a backend (Andres Freund) +Change server variable max_files_per_process to limit only files opened by a backend (Andres Freund) § @@ -1273,7 +1274,7 @@ Author: Nathan Bossart -Add server variable num_os_semaphores to report the required number of semaphores (Nathan Bossart) +Add server variable num_os_semaphores to report the required number of semaphores (Nathan Bossart) § @@ -1291,7 +1292,7 @@ Author: Peter Eisentraut -Add server variable extension_control_path to specify the location of extension control files (Peter Eisentraut, Matheus Alcantara) +Add server variable extension_control_path to specify the location of extension control files (Peter Eisentraut, Matheus Alcantara) § § @@ -1313,7 +1314,7 @@ Author: Amit Kapila -Allow inactive replication slots to be automatically invalided using server variable idle_replication_slot_timeout (Nisha Moond, Bharath Rupireddy) +Allow inactive replication slots to be automatically invalided using server variable idle_replication_slot_timeout (Nisha Moond, Bharath Rupireddy) § @@ -1325,12 +1326,12 @@ Author: Masahiko Sawada -Add server variable max_active_replication_origins to control the maximum active replication origins (Euler Taveira) +Add server variable max_active_replication_origins to control the maximum active replication origins (Euler Taveira) § -This was previously controlled by max_replication_slots, but this new setting allows a higher origin count in cases where fewer slots are required. +This was previously controlled by max_replication_slots, but this new setting allows a higher origin count in cases where fewer slots are required. @@ -1364,9 +1365,9 @@ Allow the values of generated columns to be logically replicated (Shubham Khanna -If the publication specifies a column list, all specified columns, generated and non-generated, are published. Without a specified column list, publication option publish_generated_columns +If the publication specifies a column list, all specified columns, generated and non-generated, are published. Without a specified column list, publication option publish_generated_columns controls whether generated columns are published. Previously generated columns were not replicated and the subscriber had to compute the values if possible; this is particularly -useful for non-Postgres subscribers which lack such a capability. +useful for non-PostgreSQL subscribers which lack such a capability. @@ -1377,7 +1378,7 @@ Author: Amit Kapila -Change the default CREATE SUBSCRIPTION streaming option from "off" to "parallel" (Vignesh C) +Change the default CREATE SUBSCRIPTION streaming option from off to parallel (Vignesh C) § @@ -1391,7 +1392,7 @@ Author: Amit Kapila -Allow ALTER SUBSCRIPTION to change the replication slot's two-phase commit behavior (Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou) +Allow ALTER SUBSCRIPTION to change the replication slot's two-phase commit behavior (Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou) § § @@ -1421,7 +1422,7 @@ Log conflicts while applying logical replication changes (Zhijie Hou, Nisha Moon -Also report in new columns of pg_stat_subscription_stats. +Also report in new columns of pg_stat_subscription_stats. @@ -1454,7 +1455,7 @@ Allow generated columns to be virtual, and make them the default (Peter Eisentra -Virtual generated columns generate their values when the columns are read, not written. The write behavior can still be specified via the STORED option. +Virtual generated columns generate their values when the columns are read, not written. The write behavior can still be specified via the STORED option. @@ -1465,13 +1466,13 @@ Author: Dean Rasheed -Add OLD/NEW support to RETURNING in DML queries (Dean Rasheed) +Add OLD/NEW support to RETURNING in DML queries (Dean Rasheed) § -Previously RETURNING only returned new values for INSERT and UPDATE, and old values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax -allows the RETURNING list of INSERT/UPDATE/DELETE/MERGE to explicitly return old and new values by using the special aliases "old" and "new". These aliases can be renamed to +Previously RETURNING only returned new values for INSERT and UPDATE, and old values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax +allows the RETURNING list of INSERT/UPDATE/DELETE/MERGE to explicitly return old and new values by using the special aliases old and new. These aliases can be renamed to avoid identifier conflicts. @@ -1488,7 +1489,7 @@ Allow foreign tables to be created like existing local tables (Zhang Mingli) -The syntax is CREATE FOREIGN TABLE ... LIKE. +The syntax is CREATE FOREIGN TABLE ... LIKE. @@ -1499,7 +1500,7 @@ Author: Peter Eisentraut -Allow LIKE with nondeterministic collations (Peter Eisentraut) +Allow LIKE with nondeterministic collations (Peter Eisentraut) § @@ -1527,7 +1528,7 @@ Author: Jeff Davis -Add builtin collation provider PG_UNICODE_FAST (Jeff Davis) +Add builtin collation provider PG_UNICODE_FAST (Jeff Davis) § @@ -1543,12 +1544,12 @@ Author: David Rowley -Allow VACUUM and ANALYZE to process partitioned tables without processing their children (Michael Harris) +Allow VACUUM and ANALYZE to process partitioned tables without processing their children (Michael Harris) § -This is enabled with the new ONLY option. This is useful since autovacuum does not process partitioned tables, just its children. +This is enabled with the new ONLY option. This is useful since autovacuum does not process partitioned tables, just its children. @@ -1570,7 +1571,7 @@ Add functions to modify per-relation and per-column optimizer statistics (Corey -The functions are pg_restore_relation_stats(), pg_restore_attribute_stats(), pg_clear_relation_stats(), and pg_clear_attribute_stats. +The functions are pg_restore_relation_stats(), pg_restore_attribute_stats(), pg_clear_relation_stats(), and pg_clear_attribute_stats(). @@ -1582,12 +1583,12 @@ Author: Thomas Munro -Add server variable file_copy_method to control the file copying method (Nazir Bilal Yavuz) +Add server variable file_copy_method to control the file copying method (Nazir Bilal Yavuz) § -This controls whether CREATE DATABASE ... STRATEGY=FILE_COPY and ALTER DATABASE ... SET TABLESPACE uses file copy or clone. +This controls whether CREATE DATABASE ... STRATEGY=FILE_COPY and ALTER DATABASE ... SET TABLESPACE uses file copy or clone. @@ -1605,12 +1606,12 @@ Author: Peter Eisentraut -Allow the specification of non-overlapping PRIMARY KEY and UNIQUE constraints (Paul A. Jungwirth) +Allow the specification of non-overlapping PRIMARY KEY and UNIQUE constraints (Paul A. Jungwirth) § -This is specified by WITHOUT OVERLAPS on the last column. +This is specified by WITHOUT OVERLAPS on the last column. @@ -1623,14 +1624,13 @@ Author: Peter Eisentraut -Allow CHECK and foreign key constraints to be specified as NOT ENFORCED (Amul Sul) +Allow CHECK and foreign key constraints to be specified as NOT ENFORCED (Amul Sul) § § -This also adds column pg_constraint.conenforced. - +This also adds column pg_constraint.conenforced. @@ -1980,7 +1981,7 @@ Author: Tom Lane -Add function array_sort() which sorts an array's first dimension (Junwang Zhao, Jian He) +Add function array_sort() which sorts an array's first dimension (Junwang Zhao, Jian He) § @@ -1992,7 +1993,7 @@ Author: Michael Paquier -Add function array_reverse() which reverses an array's first dimension (Aleksander Alekseev) +Add function array_reverse() which reverses an array's first dimension (Aleksander Alekseev) § @@ -2004,7 +2005,7 @@ Author: Nathan Bossart -Add function reverse() to reverse bytea bytes (Aleksander Alekseev) +Add function reverse() to reverse bytea bytes (Aleksander Alekseev) § @@ -2016,12 +2017,12 @@ Author: Dean Rasheed -Allow casting between integer types and bytea (Aleksander Alekseev) +Allow casting between integer types and bytea (Aleksander Alekseev) § -The integer values are stored as bytea two's complement values. +The integer values are stored as bytea two's complement values. @@ -2056,12 +2057,12 @@ Author: Tom Lane -Improve the XML error codes to more closely match the SQL standard (Tom Lane) +Improve the XML error codes to more closely match the SQL standard (Tom Lane) § -These errors are reported via SQLSTATE. +These errors are reported via SQLSTATE. @@ -2081,12 +2082,12 @@ Author: Jeff Davis -Add function CASEFOLD() to allow for more sophisticated case-insensitive matching (Jeff Davis) +Add function CASEFOLD() to allow for more sophisticated case-insensitive matching (Jeff Davis) § -Allows more accurate comparison, i.e., a character can have multiple upper or lower case equivalents, or upper or lower case conversion changes the number of characters. +This allows more accurate comparisons, i.e., a character can have multiple upper or lower case equivalents, or upper or lower case conversion changes the number of characters. @@ -2099,7 +2100,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) § § @@ -2112,7 +2113,7 @@ Author: Tom Lane -Add a WEEK option to EXTRACT() (Tom Lane) +Add a WEEK option to EXTRACT() (Tom Lane) § @@ -2124,7 +2125,7 @@ Author: Tom Lane -Improve the output EXTRACT(QUARTER ...) for negative values (Tom Lane) +Improve the output EXTRACT(QUARTER ...) for negative values (Tom Lane) § @@ -2136,12 +2137,12 @@ Author: Tom Lane -Add roman numeral support to to_number() (Hunaid Sohail) +Add roman numeral support to to_number() (Hunaid Sohail) § -This is accessed via the "RN" pattern. +This is accessed via the RN pattern. @@ -2152,12 +2153,12 @@ Author: Masahiko Sawada -Add UUID version 7 generation function uuidv7() (Andrey Borodin) +Add UUID version 7 generation function uuidv7() (Andrey Borodin) § -This UUID value is temporally sortable. Function alias 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. @@ -2168,7 +2169,7 @@ Author: Nathan Bossart -Add functions crc32() and crc32c() to compute CRC values (Aleksander Alekseev) +Add functions crc32() and crc32c() to compute CRC values (Aleksander Alekseev) § @@ -2180,7 +2181,7 @@ Author: Dean Rasheed -Add math functions gamma() and lgamma() (Dean Rasheed) +Add math functions gamma() and lgamma() (Dean Rasheed) § @@ -2192,12 +2193,12 @@ Author: Tom Lane -Allow "=>" syntax for named cursor arguments in plpgsql (Pavel Stehule) +Allow => syntax for named cursor arguments in plpgsql (Pavel Stehule) § -We previously only accepted ":=". +We previously only accepted :=. @@ -2208,7 +2209,7 @@ Author: Tom Lane -Allow regexp_match[es]/regexp_like/regexp_replace/regexp_count/regexp_instr/regexp_substr/regexp_split_to_table/regexp_split_to_array() to use named arguments (Jian He) +Allow regexp_match[es]()/regexp_like()/regexp_replace()/regexp_count()/regexp_instr()/regexp_substr()/regexp_split_to_table()/regexp_split_to_array() to use named arguments (Jian He) § @@ -2229,7 +2230,7 @@ Author: Robert Haas -Add function PQfullProtocolVersion() to report the full, including minor, protocol version number (Jacob Champion, Jelte Fennema-Nio) +Add function PQfullProtocolVersion() to report the full, including minor, protocol version number (Jacob Champion, Jelte Fennema-Nio) § @@ -2256,7 +2257,7 @@ Author: Michael Paquier -Add libpq function PQservice() to return the connection service name (Michael Banck) +Add libpq function PQservice() to return the connection service name (Michael Banck) § @@ -2270,7 +2271,7 @@ Author: Tomas Vondra -Report search_path changes to the client (Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra) +Report search_path changes to the client (Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra) § § @@ -2291,7 +2292,7 @@ Author: Álvaro Herrera -Add PQtrace() output for all message types, including authentication (Jelte Fennema-Nio) +Add PQtrace() output for all message types, including authentication (Jelte Fennema-Nio) § § § @@ -2307,7 +2308,7 @@ Author: Daniel Gustafsson -Add libpq connection parameter sslkeylogfile which dumps out SSL key material (Abhishek Chanda, Daniel Gustafsson) +Add libpq connection parameter sslkeylogfile which dumps out SSL key material (Abhishek Chanda, Daniel Gustafsson) § @@ -2323,12 +2324,12 @@ Author: Thomas Munro -Modify some libpq function signatures to use int64_t (Thomas Munro) +Modify some libpq function signatures to use int64_t (Thomas Munro) § -These previously used pg_int64, which is now deprecated. +These previously used pg_int64, which is now deprecated. @@ -2348,12 +2349,12 @@ Author: Michael Paquier -Allow psql to parse, bind, and close named prepared statements (Anthonin Bonnefoy, Michael Paquier) +Allow psql to parse, bind, and close named prepared statements (Anthonin Bonnefoy, Michael Paquier) § -This is accomplished with new commands \parse, \bind_named, and \close. +This is accomplished with new commands \parse, \bind_named, and \close. @@ -2368,14 +2369,14 @@ Author: Michael Paquier -Add psql backslash commands to allowing issuance of pipeline queries (Anthonin Bonnefoy) +Add psql backslash commands to allowing issuance of pipeline queries (Anthonin Bonnefoy) § § § -The new commands are \startpipeline, \syncpipeline, \sendpipeline, \endpipeline, \flushrequest, \flush, and \getresults. +The new commands are \startpipeline, \syncpipeline, \sendpipeline, \endpipeline, \flushrequest, \flush, and \getresults. @@ -2386,12 +2387,12 @@ Author: Michael Paquier -Allow adding pipeline status to the psql prompt and add related state variables (Anthonin Bonnefoy) +Allow adding pipeline status to the psql prompt and add related state variables (Anthonin Bonnefoy) § -The new prompt character is "%P" and the new psql variables are PIPELINE_SYNC_COUNT, PIPELINE_COMMAND_COUNT, and PIPELINE_RESULT_COUNT. +The new prompt character is %P and the new psql variables are PIPELINE_SYNC_COUNT, PIPELINE_COMMAND_COUNT, and PIPELINE_RESULT_COUNT. @@ -2402,7 +2403,7 @@ Author: Michael Paquier -Allow adding the connection service name to 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) § @@ -2414,12 +2415,12 @@ Author: Dean Rasheed -Add psql option to use expanded mode on all list commands (Dean Rasheed) +Add psql option to use expanded mode on all list commands (Dean Rasheed) § -Adding 'x' enables this. +Adding backslash suffix x enables this. @@ -2430,7 +2431,7 @@ Author: Álvaro Herrera -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) § @@ -2442,7 +2443,7 @@ Author: Dean Rasheed -Add function's leakproof indicator to psql's \df+, \do+, \dAo+, and \dC+ outputs (Yugo Nagata) +Add function's leakproof indicator to psql's \df+, \do+, \dAo+, and \dC+ outputs (Yugo Nagata) § @@ -2454,7 +2455,7 @@ Author: Michael Paquier -Add access method details for partitioned relations in \dP+ (Justin Pryzby) +Add access method details for partitioned relations in \dP+ (Justin Pryzby) § @@ -2466,7 +2467,7 @@ Author: Magnus Hagander -Add "default_version" to the psql \dx extension output (Magnus Hagander) +Add default_version to the psql \dx extension output (Magnus Hagander) § @@ -2478,7 +2479,7 @@ Author: Daniel Gustafsson -Add psql variable WATCH_INTERVAL to set the default \watch wait time (Daniel Gustafsson) +Add psql variable WATCH_INTERVAL to set the default \watch wait time (Daniel Gustafsson) § @@ -2501,13 +2502,13 @@ Author: Peter Eisentraut -Change initdb to default to enabling checksums (Greg Sabino Mullane) +Change initdb to default to enabling checksums (Greg Sabino Mullane) § § -The new initdb option --no-data-checksums disables checksums. +The new initdb option disables checksums. @@ -2518,12 +2519,12 @@ Author: Nathan Bossart -Add initdb option --no-sync-data-files to avoid syncing heap/index files (Nathan Bossart) +Add initdb option to avoid syncing heap/index files (Nathan Bossart) § -initdb --no-sync is still available to avoid syncing any files. +initdb option is still available to avoid syncing any files. @@ -2536,13 +2537,13 @@ Author: Nathan Bossart -Add vacuumdb option --missing-stats-only to compute only missing optimizer statistics (Corey Huinker, Nathan Bossart) +Add vacuumdb option to compute only missing optimizer statistics (Corey Huinker, Nathan Bossart) § § -This option can only be used by --analyze-only and --analyze-in-stages. +This option can only be used by and . @@ -2553,7 +2554,7 @@ Author: Robert Haas -Add pg_combinebackup option -k/--link to enable hard linking (Israel Barth Rubio, Robert Haas) +Add pg_combinebackup option / to enable hard linking (Israel Barth Rubio, Robert Haas) § @@ -2569,7 +2570,7 @@ Author: Robert Haas -Allow pg_verifybackup to verify tar-format backups (Amul Sul) +Allow pg_verifybackup to verify tar-format backups (Amul Sul) § @@ -2581,7 +2582,7 @@ Author: Masahiko Sawada -If pg_rewind's --source-server specifies a database name, use it in --write-recovery-conf output (Masahiko Sawada) +If pg_rewind's specifies a database name, use it in output (Masahiko Sawada) § @@ -2593,7 +2594,7 @@ Author: Masahiko Sawada -Add pg_resetwal option --char-signedness to change the default char signedness (Masahiko Sawada) +Add pg_resetwal option to change the default char signedness (Masahiko Sawada) § @@ -2616,12 +2617,12 @@ Author: Andrew Dunstan -Allow pg_dumpall to dump in the same output formats as pg_dump supports (Mahendra Singh Thalor, Andrew Dunstan) +Allow pg_dumpall to dump in the same output formats as pg_dump supports (Mahendra Singh Thalor, Andrew Dunstan) § -Also modify pg_restore to handle such dumps. Previously pg_dumpall only supported text format. +Also modify pg_restore to handle such dumps. Previously pg_dumpall only supported text format. @@ -2632,7 +2633,7 @@ Author: Jeff Davis -Add pg_dump options --with-schema, --with-data, and --with-statistics (Jeff Davis) +Add pg_dump options , , and (Jeff Davis) § @@ -2646,7 +2647,7 @@ Author: Nathan Bossart -Add pg_dump and pg_dumpall option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart) +Add pg_dump and pg_dumpall option to dump sequence data that would normally be excluded (Nathan Bossart) § § @@ -2659,7 +2660,7 @@ Author: Jeff Davis -Add pg_dump, pg_dumpall, and pg_restore options --statistics-only, --no-statistics, --no-data, and --no-schema (Corey Huinker, Jeff Davis) +Add pg_dump, pg_dumpall, and pg_restore options , , , and (Corey Huinker, Jeff Davis) § @@ -2671,7 +2672,7 @@ Author: Tom Lane -Add option --no-policies to disable row level security policy processing in pg_dump, pg_dumpall, pg_restore (Nikolay Samokhvalov) +Add option to disable row level security policy processing in pg_dump, pg_dumpall, pg_restore (Nikolay Samokhvalov) § @@ -2702,7 +2703,7 @@ Author: Jeff Davis -Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Nathan Bossart) +Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Nathan Bossart) § § § @@ -2710,7 +2711,7 @@ Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Na -Extended statistics are not preserved. Also add pg_upgrade option --no-statistics to disable statistics preservation. +Extended statistics are not preserved. Also add pg_upgrade option to disable statistics preservation. @@ -2741,7 +2742,7 @@ Author: Nathan Bossart -Allow pg_upgrade to process database checks in parallel (Nathan Bossart) +Allow pg_upgrade to process database checks in parallel (Nathan Bossart) § § § @@ -2756,7 +2757,7 @@ Allow pg_upgrade to process database checks in parallel (Nathan Bossart) -This is controlled by the existing --jobs option. +This is controlled by the existing option. @@ -2767,7 +2768,7 @@ Author: Nathan Bossart -Add pg_upgrade option --swap to swap directories rather than copy, clone, or link files (Nathan Bossart) +Add pg_upgrade option to swap directories rather than copy, clone, or link files (Nathan Bossart) § @@ -2785,13 +2786,13 @@ Author: Masahiko Sawada -Add pg_upgrade option --set-char-signedness to set the default char signedness of new cluster (Masahiko Sawada) +Add pg_upgrade option to set the default char signedness of new cluster (Masahiko Sawada) § § -This is to handle cases where a pre-Postgres 18 cluster's default CPU signedness does not match the new cluster. +This is to handle cases where a pre-PostgreSQL 18 cluster's default CPU signedness does not match the new cluster. @@ -2811,7 +2812,7 @@ Author: Amit Kapila -Add pg_createsubscriber option --all to create logical replicas for all databases (Shubham Khanna) +Add pg_createsubscriber option to create logical replicas for all databases (Shubham Khanna) § @@ -2823,7 +2824,7 @@ Author: Amit Kapila -Add pg_createsubscriber option --remove to remove publications (Shubham Khanna) +Add pg_createsubscriber option to remove publications (Shubham Khanna) § @@ -2835,7 +2836,7 @@ Author: Amit Kapila -Add pg_createsubscriber option --enable-two-phase to enable prepared transactions (Shubham Khanna) +Add pg_createsubscriber option to enable prepared transactions (Shubham Khanna) § @@ -2847,7 +2848,7 @@ Author: Masahiko Sawada -Add pg_recvlogical option --failover to specify failover slots (Hayato Kuroda) +Add pg_recvlogical option to specify failover slots (Hayato Kuroda) § @@ -2859,7 +2860,7 @@ Author: Fujii Masao -Allow pg_recvlogical --drop-slot to work without --dbname (Hayato Kuroda) +Allow pg_recvlogical to work without (Hayato Kuroda) § @@ -2890,7 +2891,7 @@ Separate the loading and running of injection points (Michael Paquier, Heikki Li -Injection points can now be created, but not run, via INJECTION_POINT_LOAD(), and such injection points can be run via INJECTION_POINT_CACHED(). +Injection points can now be created, but not run, via INJECTION_POINT_LOAD(), and such injection points can be run via INJECTION_POINT_CACHED(). @@ -2913,7 +2914,7 @@ Author: Heikki Linnakangas -Allow inline injection point test code with IS_INJECTION_POINT_ATTACHED() (Heikki Linnakangas) +Allow inline injection point test code with IS_INJECTION_POINT_ATTACHED() (Heikki Linnakangas) § @@ -2925,7 +2926,7 @@ Author: David Rowley -Improve the performance of processing long JSON strings using SIMD instructions (David Rowley) +Improve the performance of processing long JSON strings using SIMD instructions (David Rowley) § @@ -2937,7 +2938,7 @@ Author: John Naylor -Speed up CRC32C calculations using x86 AVX-512 instructions (Raghuveer Devulapalli, Paul Amonson) +Speed up CRC32C calculations using x86 AVX-512 instructions (Raghuveer Devulapalli, Paul Amonson) § @@ -2951,7 +2952,7 @@ Author: Nathan Bossart -Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi) +Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi) § § @@ -2989,15 +2990,15 @@ Author: Tomas Vondra -Add configure option --with-libnuma to enable NUMA awareness (Jakub Wartak, Bertrand Drouvot) +Add configure option to enable NUMA awareness (Jakub Wartak, Bertrand Drouvot) § § § -The function pg_numa_available() reports on NUMA awareness, and system views pg_shmem_allocations_numa and pg_buffercache_numa which report on shared memory distribution across -NUMA nodes. +The function pg_numa_available() reports on NUMA awareness, and system views pg_shmem_allocations_numa and pg_buffercache_numa which report on shared memory distribution across +NUMA nodes. @@ -3008,7 +3009,7 @@ Author: Nathan Bossart -Add TOAST table to pg_index to allow for very large index expression indexes (Nathan Bossart) +Add TOAST table to pg_index to allow for very large expression indexes (Nathan Bossart) § @@ -3020,7 +3021,8 @@ Author: David Rowley -Remove column pg_attribute.attcacheoff (David Rowley) +Remove column +pg_attribute.attcacheoff (David Rowley) § @@ -3032,7 +3034,7 @@ Author: Melanie Plageman -Add column pg_class.relallfrozen (Melanie Plageman) +Add column pg_class.relallfrozen (Melanie Plageman) § @@ -3046,7 +3048,7 @@ Author: Peter Eisentraut -Add amgettreeheight, amconsistentequality, and amconsistentordering to the index access method API (Mark Dilger) +Add amgettreeheight, amconsistentequality, and amconsistentordering to the index access method API (Mark Dilger) § § @@ -3059,7 +3061,7 @@ Author: Peter Eisentraut -Add GiST support function stratnum (Paul A. Jungwirth) +Add GiST support function stratnum() (Paul A. Jungwirth) § @@ -3071,7 +3073,7 @@ Author: Masahiko Sawada -Record the default CPU signedness of "char" in pg_controldata (Masahiko Sawada) +Record the default CPU signedness of char in pg_controldata (Masahiko Sawada) § @@ -3085,13 +3087,13 @@ Author: Peter Eisentraut -Add support for Python "Limited API" in PL/Python (Peter Eisentraut) +Add support for Python "Limited API" in PL/Python (Peter Eisentraut) § § -This helps prevent problems caused by Python 3.x version mismatches. +This helps prevent problems caused by Python 3.x version mismatches. @@ -3102,7 +3104,7 @@ Author: Jacob Champion -Change the minimum supported Python version to 3.6.8 (Jacob Champion) +Change the minimum supported Python version to 3.6.8 (Jacob Champion) § @@ -3116,7 +3118,7 @@ Author: Daniel Gustafsson -Remove support for OpenSSL versions older than 1.1.1 (Daniel Gustafsson) +Remove support for OpenSSL versions older than 1.1.1 (Daniel Gustafsson) § § @@ -3129,7 +3131,7 @@ Author: Peter Eisentraut -If LLVM is enabled, require version 14 or later (Thomas Munro) +If LLVM is enabled, require version 14 or later (Thomas Munro) § @@ -3141,12 +3143,12 @@ Author: Tom Lane -Add macro PG_MODULE_MAGIC_EXT to allow extensions to report their name and version (Andrei Lepikhov) +Add macro PG_MODULE_MAGIC_EXT to allow extensions to report their name and version (Andrei Lepikhov) § -This information can be access via the new function pg_get_loaded_modules(). +This information can be access via the new function pg_get_loaded_modules(). @@ -3157,12 +3159,12 @@ Author: Tom Lane -Document that SPI_connect/SPI_connect_ext() always returns success (SPI_OK_CONNECT) (Stepan Neretin) +Document that SPI_connect()/SPI_connect_ext() always returns success (SPI_OK_CONNECT) (Stepan Neretin) § -Errors are always reported via ereport(). +Errors are always reported via ereport(). @@ -3173,7 +3175,7 @@ Author: Peter Eisentraut -Remove the experimental designation of Meson builds on Windows (Aleksander Alekseev) +Remove the experimental designation of Meson builds on Windows (Aleksander Alekseev) § @@ -3185,7 +3187,7 @@ Author: Peter Eisentraut -Add documentation section about API and ABI compatibility (David Wheeler, Peter Eisentraut) +Add documentation section about API and ABI compatibility (David Wheeler, Peter Eisentraut) § @@ -3199,13 +3201,13 @@ Author: Thomas Munro -Remove configure options --disable-spinlocks and --disable-atomics (Thomas Munro) +Remove configure options and (Thomas Munro) § § -Thirty-two bit atomic operations are now required. +Thirty-two-bit atomic operations are now required. @@ -3216,7 +3218,7 @@ Author: Tom Lane -Remove support for the HPPA/PA-RISC architecture (Tom Lane) +Remove support for the HPPA/PA-RISC architecture (Tom Lane) § @@ -3237,7 +3239,7 @@ Author: Masahiko Sawada -Add extension pg_logicalinspect to inspect logical snapshots (Bertrand Drouvot) +Add extension pg_logicalinspect to inspect logical snapshots (Bertrand Drouvot) § @@ -3249,7 +3251,7 @@ Author: Robert Haas -Add extension pg_overexplain which adds debug details to EXPLAIN output (Robert Haas) +Add extension pg_overexplain which adds debug details to EXPLAIN output (Robert Haas) § @@ -3267,7 +3269,7 @@ Author: Fujii Masao -Add output columns to postgres_fdw_get_connections() (Hayato Kuroda, Sagar Dilip Shedge) +Add output columns to postgres_fdw_get_connections() (Hayato Kuroda, Sagar Dilip Shedge) § § § @@ -3275,8 +3277,8 @@ 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, "closed" indicates if it is closed, "user_name" indicates the -user name, and "remote_backend_pid" indicates the remote backend process identifier. +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. @@ -3287,13 +3289,14 @@ Author: Peter Eisentraut -Allow SCRAM authentication from the client to be passed to postgres_fdw servers (Matheus Alcantara, Peter Eisentraut) +Allow SCRAM authentication from the client to be passed to postgres_fdw servers (Matheus Alcantara, Peter Eisentraut) § -This avoids storing postgres_fdw authentication information in the database, and is enabled with the postgres_fdw "use_scram_passthrough" connection option. libpq uses new connection -parameters scram_client_key and scram_server_key. +This avoids storing postgres_fdw authentication information in the database, and is enabled with the +postgres_fdw use_scram_passthrough connection option. libpq uses new connection +parameters scram_client_key and scram_server_key. @@ -3304,7 +3307,7 @@ Author: Peter Eisentraut -Allow SCRAM authentication from the client to be passed to dblink servers (Matheus Alcantara) +Allow SCRAM authentication from the client to be passed to dblink servers (Matheus Alcantara) § @@ -3316,12 +3319,12 @@ Author: Fujii Masao -Add on_error and log_verbosity options to file_fdw (Atsushi Torikoshi) +Add on_error and log_verbosity options to file_fdw (Atsushi Torikoshi) § -These control how file_fdw handles and reports invalid file rows. +These control how file_fdw handles and reports invalid file rows. @@ -3332,12 +3335,12 @@ Author: Fujii Masao -Add "reject_limit" to control the number of invalid rows file_fdw can ignore (Atsushi Torikoshi) +Add reject_limit to control the number of invalid rows file_fdw can ignore (Atsushi Torikoshi) § -This is active when ON_ERROR = 'ignore'. +This is active when ON_ERROR = 'ignore'. @@ -3348,7 +3351,7 @@ Author: Nathan Bossart -Add configurable variable min_password_length to passwordcheck (Emanuele Musella, Maurizio Boriani) +Add configurable variable min_password_length to passwordcheck (Emanuele Musella, Maurizio Boriani) § @@ -3364,7 +3367,7 @@ Author: Tatsuo Ishii -Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata) +Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata) § @@ -3376,12 +3379,12 @@ Author: Tom Lane -Add isn server variable "weak" to control invalid check digit acceptance (Viktor Holmberg) +Add isn server variable weak to control invalid check digit acceptance (Viktor Holmberg) § -This was previously only controlled by function isn_weak(). +This was previously only controlled by function isn_weak(). @@ -3392,7 +3395,7 @@ Author: Heikki Linnakangas -Allow values to be sorted to speed btree_gist index builds (Bernd Helmle, Andrey Borodin) +Allow values to be sorted to speed btree_gist index builds (Bernd Helmle, Andrey Borodin) § @@ -3404,7 +3407,7 @@ Author: Tomas Vondra -Add amcheck function gin_index_check() to verify GIN indexes (Grigory Kryachko, Heikki Linnakangas, Andrey Borodin) +Add amcheck function gin_index_check() to verify GIN indexes (Grigory Kryachko, Heikki Linnakangas, Andrey Borodin) § @@ -3416,12 +3419,12 @@ Author: Andres Freund -Add functions pg_buffercache_evict_relation() and pg_buffercache_evict_all() to evict unpinned shared buffers (Nazir Bilal Yavuz) +Add functions pg_buffercache_evict_relation() and pg_buffercache_evict_all() to evict unpinned shared buffers (Nazir Bilal Yavuz) § -The existing function pg_buffercache_evict() now returns the buffer flush status. +The existing function pg_buffercache_evict() now returns the buffer flush status. @@ -3436,7 +3439,7 @@ Author: Robert Haas -Allow extensions to install custom EXPLAIN options (Robert Haas, Sami Imseih) +Allow extensions to install custom EXPLAIN options (Robert Haas, Sami Imseih) § § § @@ -3452,7 +3455,7 @@ Author: Michael Paquier -Allow extensions to use the server's cumulative statistics API (Michael Paquier) +Allow extensions to use the server's cumulative statistics API (Michael Paquier) § § @@ -3472,7 +3475,7 @@ Author: Michael Paquier -Allow the queries of CREATE TABLE AS and DECLARE to be tracked by pg_stat_statements (Anthonin Bonnefoy) +Allow the queries of CREATE TABLE AS and DECLARE to be tracked by pg_stat_statements (Anthonin Bonnefoy) § @@ -3488,12 +3491,12 @@ Author: Michael Paquier -Allow the parameterization of SET values in pg_stat_statements (Greg Sabino Mullane, Michael Paquier) +Allow the parameterization of SET values in pg_stat_statements (Greg Sabino Mullane, Michael Paquier) § -This reduces the bloat caused by SET statements with differing constants. +This reduces the bloat caused by SET statements with differing constants. @@ -3504,12 +3507,12 @@ Author: Michael Paquier -Add pg_stat_statements columns to report parallel activity (Guillaume Lelarge) +Add pg_stat_statements columns to report parallel activity (Guillaume Lelarge) § -The new columns are parallel_workers_to_launch and parallel_workers_launched. +The new columns are parallel_workers_to_launch and parallel_workers_launched. @@ -3520,7 +3523,7 @@ Author: Michael Paquier -Add pg_stat_statements.wal_buffers_full to report full WAL buffers (Bertrand Drouvot) +Add pg_stat_statements.wal_buffers_full to report full WAL buffers (Bertrand Drouvot) § @@ -3541,7 +3544,7 @@ Author: Álvaro Herrera -Add pgcrypto functions sha256crypt() and sha512crypt() (Bernd Helmle) +Add pgcrypto functions sha256crypt() and sha512crypt() (Bernd Helmle) § @@ -3553,7 +3556,7 @@ Author: Daniel Gustafsson -Add CFB mode to pgcrypto encryption and decryption (Umar Hayat) +Add CFB mode to pgcrypto encryption and decryption (Umar Hayat) § @@ -3565,12 +3568,12 @@ Author: Daniel Gustafsson -Add pgcrypto server variable builtin_crypto_enabled to allow disabling builtin non-FIPS mode cryptographic functions (Daniel Gustafsson, Joe Conway) +Add pgcrypto server variable builtin_crypto_enabled to allow disabling builtin non-FIPS mode cryptographic functions (Daniel Gustafsson, Joe Conway) § -This is useful for guaranteeing FIPS mode behavior. +This is useful for guaranteeing FIPS mode behavior. -- 2.39.5