diff options
Diffstat (limited to 'doc/src/sgml/release-18.sgml')
| -rw-r--r-- | doc/src/sgml/release-18.sgml | 97 |
1 files changed, 73 insertions, 24 deletions
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 619592bd882..19e770c65b5 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -194,6 +194,27 @@ These were previously zero-based. </para> </listitem> +<!-- +Author: Peter Eisentraut <peter@eisentraut.org> +2024-10-16 [04bec894a04] initdb: Change default to using data checksums. +--> + +<listitem> +<para> +initdb defaults to enabling data checksums +<ulink url="&commit_baseurl;04bec894a04">§</ulink> +</para> + +<para> +The previous default behavior (checksums disabled) can be obtained using the +new option --no-data-checksums. Note that pg_upgrade will reject upgrading +between clusters with different checksum settings, so if the old cluster does +not have checksums enabled (the previous default), then the new cluster will +need to be initialized with --no-data-checksums in order to allow pg_upgrade +to succeed. +</para> +</listitem> + </itemizedlist> </sect2> @@ -569,6 +590,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. @@ -682,15 +704,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> @@ -699,6 +718,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. --> @@ -717,7 +748,7 @@ Author: Fujii Masao <fujii@postgresql.org> <listitem> <para> -Add server variable log_lock_failure to log lock acquisition failures (Yuki Seino) +Add server variable log_lock_failures to log lock acquisition failures (Yuki Seino) <ulink url="&commit_baseurl;6d376c3b0">§</ulink> </para> @@ -763,6 +794,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> @@ -1741,32 +1799,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> @@ -2905,13 +2945,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> |