Home • Explore • Blog • CI
☰



postgresql
11th chunk of `doc/src/sgml/release-18.sgml`
1156b8855e8ae17ec879e3096d7cd5797b264f8e61cd8cd20000000100000fa7

Jumbling is used by pg_stat_statements.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-03-26 [787514b30] Use relation name instead of OID in query jumbling for R
-->

<listitem>
<para>
Adjust query jumbling to group together queries using the same relation name (Michael Paquier, Sami Imseih)
<ulink url="&commit_baseurl;787514b30">&sect;</ulink>
</para>

<para>
This is true even if the tables in different schemas have different column names.
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-01 [12227a1d5] Add context type field to pg_backend_memory_contexts
-->

<listitem>
<para>
Add column pg_backend_memory_contexts.type to report the type of memory context (David Rowley)
<ulink url="&commit_baseurl;12227a1d5">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-25 [32d3ed816] Add path column to pg_backend_memory_contexts view
-->

<listitem>
<para>
Add column pg_backend_memory_contexts.path to show memory context parents (Melih Mutlu)
<ulink url="&commit_baseurl;32d3ed816">&sect;</ulink>
</para>
</listitem>

     </itemizedlist>

    </sect4>

    <sect4 id="release-18-privileges">
     <title>Privileges</title>

     <itemizedlist>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-07-04 [4564f1ceb] Add pg_get_acl() to get the ACL for a database object
Author: Michael Paquier <michael@paquier.xyz>
2024-07-10 [d898665bf] Extend pg_get_acl() to handle sub-object IDs
-->

<listitem>
<para>
Add function pg_get_acl() to retrieve database access control details (Joel Jacobson)
<ulink url="&commit_baseurl;4564f1ceb">&sect;</ulink>
<ulink url="&commit_baseurl;d898665bf">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-09-12 [4eada203a] Add has_largeobject_privilege function.
-->

<listitem>
<para>
Add function has_largeobject_privilege() to check large object privileges (Yugo Nagata)
<ulink url="&commit_baseurl;4eada203a">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2025-04-04 [0d6c47766] Extend ALTER DEFAULT PRIVILEGES to define default privil
-->

<listitem>
<para>
Allow ALTER DEFAULT PRIVILEGES to define large object default privileges (Takatsuka Haruka, Yugo Nagata, Laurenz Albe)
<ulink url="&commit_baseurl;0d6c47766">&sect;</ulink>
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2024-07-09 [ccd38024b] Introduce pg_signal_autovacuum_worker.
-->

<listitem>
<para>
Add predefined role pg_signal_autovacuum_worker (Kirill Reshke)
<ulink url="&commit_baseurl;ccd38024b">&sect;</ulink>
</para>

<para>
This allows sending signals to autovacuum workers.
</para>
</listitem>

     </itemizedlist>

    </sect4>

    <sect4 id="release-18-server-config">
     <title>Server Configuration</title>

     <itemizedlist>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-02-20 [b3f0be788] Add support for OAUTHBEARER SASL mechanism
-->

<listitem>
<para>
Add support for the OAuth authentication method (Jacob Champion, Daniel Gustafsson, Thomas Munro)
<ulink url="&commit_baseurl;b3f0be788">&sect;</ulink>
</para>

<para>
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.
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2024-10-24 [45188c2ea] Support configuring TLSv1.3 cipher suites
-->

<listitem>
<para>
Add server variable ssl_tls13_ciphers to allow specification of multiple colon-separated TLSv1.3 cipher suites (Erica Zhang, Daniel Gustafsson)
<ulink url="&commit_baseurl;45188c2ea">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-03-18 [daa02c6bd] Add X25519 to the default set of curves
-->

<listitem>
<para>
Change server variable ssl_groups's default to include
Title: PostgreSQL 18: Enhanced Statistics, Privileges, and Server Configuration
Summary
PostgreSQL 18 continues to enhance statistics by adjusting query jumbling for pg_stat_statements and adding type/path columns to pg_backend_memory_contexts. It introduces a pg_get_acl() function for retrieving database access control details, has_largeobject_privilege() for checking large object privileges, and extends ALTER DEFAULT PRIVILEGES to include large objects. A pg_signal_autovacuum_worker role is added for sending signals to autovacuum workers. Server configuration adds support for OAuth authentication, a server variable ssl_tls13_ciphers for specifying TLSv1.3 cipher suites, and updates the ssl_groups default to include X25519.