Home • Explore • Blog • CI
☰



postgresql
24th chunk of `doc/src/sgml/release-18.sgml`
c3cd6c64f192dabbb1cc3045dccd16eb3c1e57f238e358160000000100000fa6

</para>
</listitem>

<!--
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2025-01-14 [00f4c2959] psql: Add option to use expanded mode to all list comman
-->

<listitem>
<para>
Add psql option to use expanded mode on all list commands (Dean Rasheed)
<ulink url="&commit_baseurl;00f4c2959">&sect;</ulink>
</para>

<para>
Adding 'x' enables this.
</para>
</listitem>

<!--
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
2025-02-22 [bba2fbc62] Change \conninfo to use tabular format
-->

<listitem>
<para>
Change psql's \conninfo to use tabular format and include more information (Álvaro Herrera, Maiquel Grassi, Hunaid Sohail)
<ulink url="&commit_baseurl;bba2fbc62">&sect;</ulink>
</para>
</listitem>

<!--
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2025-01-14 [2355e5111] psql: Add leakproof indicator to \df+, \do+, \dAo+, and
-->

<listitem>
<para>
Add function's leakproof indicator to psql's \df+, \do+, \dAo+, and \dC+ outputs (Yugo Nagata)
<ulink url="&commit_baseurl;2355e5111">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-07-02 [978f38c77] Add information about access method for partitioned rela
-->

<listitem>
<para>
Add access method details for partitioned relations in \dP+ (Justin Pryzby)
<ulink url="&commit_baseurl;978f38c77">&sect;</ulink>
</para>
</listitem>

<!--
Author: Magnus Hagander <magnus@hagander.net>
2025-03-24 [d696406a9] psql: show default extension version in \dx output
-->

<listitem>
<para>
Add "default_version" to the psql \dx extension output (Magnus Hagander)
<ulink url="&commit_baseurl;d696406a9">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-03-25 [1a759c832] psql: Make default \watch interval configurable
-->

<listitem>
<para>
Add psql variable WATCH_INTERVAL to set the default \watch wait time (Daniel Gustafsson)
<ulink url="&commit_baseurl;1a759c832">&sect;</ulink>
</para>
</listitem>

      </itemizedlist>

    </sect3>

    <sect3 id="release-18-server-apps">
     <title>Server Applications</title>

     <itemizedlist>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-10-01 [983a588e0] initdb: Add new option "- -no-data-checksums"
Author: Peter Eisentraut <peter@eisentraut.org>
2024-10-16 [04bec894a] initdb: Change default to using data checksums.
-->

<listitem>
<para>
Change initdb to default to enabling checksums (Greg Sabino Mullane)
<ulink url="&commit_baseurl;983a588e0">&sect;</ulink>
<ulink url="&commit_baseurl;04bec894a">&sect;</ulink>
</para>

<para>
The new initdb option --no-data-checksums disables checksums.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-25 [cf131fa94] initdb: Add - -no-sync-data-files.
-->

<listitem>
<para>
Add initdb option --no-sync-data-files to avoid syncing heap/index files (Nathan Bossart)
<ulink url="&commit_baseurl;cf131fa94">&sect;</ulink>
</para>

<para>
initdb --no-sync is still available to avoid syncing any files.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-18 [edba754f0] vacuumdb: Add option for analyzing only relations missin
Author: Nathan Bossart <nathan@postgresql.org>
2025-04-30 [987910502] vacuumdb: Don't skip empty relations in - -missing-stats-
-->

<listitem>
<para>
Add vacuumdb option --missing-stats-only to compute only missing optimizer statistics (Corey Huinker, Nathan Bossart)
<ulink url="&commit_baseurl;edba754f0">&sect;</ulink>
<ulink url="&commit_baseurl;987910502">&sect;</ulink>
</para>

<para>
This option can only be used by --analyze-only and --analyze-in-stages.
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2025-03-17 [99aeb8470] pg_combinebackup: Add -k, - -link option.
-->

<listitem>
<para>
Add pg_combinebackup option -k/--link to enable hard linking (Israel Barth Rubio, Robert Haas)
<ulink url="&commit_baseurl;99aeb8470">&sect;</ulink>
</para>

<para>
Only some files can be hard linked.  This should not be used if the backups will
Title: PostgreSQL 18: psql Enhancements and Server Application Updates
Summary
This section outlines enhancements to psql and updates to server applications in PostgreSQL 18. psql improvements include adding an option to use expanded mode on list commands ('x'), changing \conninfo to tabular format, showing a function's leakproof indicator in \df+, \do+, \dAo+, and \dC+ outputs, and providing access method details for partitioned relations in \dP+. The default extension version is now shown in \dx output, and the \watch interval is configurable via the WATCH_INTERVAL variable. Server application changes include initdb defaulting to enabling checksums with a --no-data-checksums option to disable them, adding --no-sync-data-files to initdb to avoid syncing heap/index files, providing a vacuumdb option --missing-stats-only to compute only missing optimizer statistics, and introducing a pg_combinebackup option -k/--link to enable hard linking.