Home • Explore • Blog • CI
☰



postgresql
33th chunk of `doc/src/sgml/release-18.sgml`
9d18a79f440ad23a4569513bb5f7891656469571c11e6b640000000100000cd7

<ulink url="&commit_baseurl;f7e1b3828">&sect;</ulink>
</para>

<para>
This controls the minimum password length.
</para>
</listitem>

<!--
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-10-11 [cae0f3c40] pgbench: Improve result outputs related to failed transa
-->

<listitem>
<para>
Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata)
<ulink url="&commit_baseurl;cae0f3c40">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-16 [448904423] contrib/isn: Make weak mode a GUC setting, and fix relat
-->

<listitem>
<para>
Add isn server variable "weak" to control invalid check digit acceptance (Viktor Holmberg)
<ulink url="&commit_baseurl;448904423">&sect;</ulink>
</para>

<para>
This was previously only controlled by function isn_weak().
</para>
</listitem>

<!--
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
2025-04-03 [e4309f73f] Add support for sorted gist index builds to btree_gist
-->

<listitem>
<para>
Allow values to be sorted to speed btree_gist index builds (Bernd Helmle, Andrey Borodin)
<ulink url="&commit_baseurl;e4309f73f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tomas Vondra <tomas.vondra@postgresql.org>
2025-03-29 [14ffaece0] amcheck: Add gin_index_check() to verify GIN index
-->

<listitem>
<para>
Add amcheck function gin_index_check() to verify GIN indexes (Grigory Kryachko, Heikki Linnakangas, Andrey Borodin)
<ulink url="&commit_baseurl;14ffaece0">&sect;</ulink>
</para>
</listitem>

<!--
Author: Andres Freund <andres@anarazel.de>
2025-04-08 [dcf7e1697] Add pg_buffercache_evict_{relation,all} functions
-->

<listitem>
<para>
Add functions pg_buffercache_evict_relation() and pg_buffercache_evict_all() to evict unpinned shared buffers (Nazir Bilal Yavuz)
<ulink url="&commit_baseurl;dcf7e1697">&sect;</ulink>
</para>

<para>
The existing function pg_buffercache_evict() now returns the buffer flush status.
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2025-03-18 [c65bc2e1d] Make it possible for loadable modules to add EXPLAIN opt
Author: Robert Haas <rhaas@postgresql.org>
2025-03-18 [4fd02bf7c] Add some new hooks so extensions can add details to EXPL
Author: Robert Haas <rhaas@postgresql.org>
2025-03-20 [50ba65e73] Add an additional hook for EXPLAIN option validation.
-->

<listitem>
<para>
Allow extensions to install custom EXPLAIN options (Robert Haas, Sami Imseih)
<ulink url="&commit_baseurl;c65bc2e1d">&sect;</ulink>
<ulink url="&commit_baseurl;4fd02bf7c">&sect;</ulink>
<ulink url="&commit_baseurl;50ba65e73">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-08-04 [7949d9594] Introduce pluggable APIs for Cumulative Statistics
Author: Michael Paquier <michael@paquier.xyz>
2024-08-05 [2eff9e678] Add helper routines to retrieve data for custom fixed-nu
-->

<listitem>
<para>
Allow extensions to use the server's cumulative statistics API (Michael Paquier)
<ulink url="&commit_baseurl;7949d9594">&sect;</ulink>
<ulink url="&commit_baseurl;2eff9e678">&sect;</ulink>
</para>
</listitem>

    </itemizedlist>

    <sect4 id="release-18-pgstatstatements">
     <title><link linkend="pgstatstatements"><application>pg_stat_statements</application></link></title>
Title: PostgreSQL 18: Indexing, Buffercache, EXPLAIN, and Statistics API Enhancements
Summary
This section details several improvements, including adding an 'isn' server variable for controlling invalid check digit acceptance, allowing values to be sorted to speed btree_gist index builds, introducing a gin_index_check() function to verify GIN indexes, adding functions to evict unpinned shared buffers from the buffer cache, and enabling extensions to install custom EXPLAIN options and use the server's cumulative statistics API.