inner queries of CREATE TABLE AS and DE
-->

<listitem>
<para>
Allow the queries of CREATE TABLE AS and DECLARE to be tracked by pg_stat_statements (Anthonin Bonnefoy)
<ulink url="&commit_baseurl;6b652e6ce">&sect;</ulink>
</para>

<para>
They are also now assigned query ids.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-09-30 [dc6851596] Show values of SET statements as constants in pg_stat_st
-->

<listitem>
<para>
Allow the parameterization of SET values in pg_stat_statements (Greg Sabino Mullane, Michael Paquier)
<ulink url="&commit_baseurl;dc6851596">&sect;</ulink>
</para>

<para>
This reduces the bloat caused by SET statements with differing constants.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-10-09 [cf54a2c00] pg_stat_statements: Add columns to track parallel worker
-->

<listitem>
<para>
Add pg_stat_statements columns to report parallel activity (Guillaume Lelarge)
<ulink url="&commit_baseurl;cf54a2c00">&sect;</ulink>
</para>

<para>
The new columns are parallel_workers_to_launch and parallel_workers_launched.
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-02-17 [ce5bcc4a9] pg_stat_statements: Add wal_buffers_full
-->

<listitem>
<para>
Add pg_stat_statements.wal_buffers_full to report full WAL buffers (Bertrand Drouvot)
<ulink url="&commit_baseurl;ce5bcc4a9">&sect;</ulink>
</para>
</listitem>

     </itemizedlist>

    </sect4>

    <sect4 id="release-18-pgcrypto">
     <title><link linkend="pgcrypto"><application>pgcrypto</application></link></title>

     <itemizedlist>

<!--
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
2025-04-05 [749a9e20c] Add modern SHA-2 based password hashes to pgcrypto.
-->

<listitem>
<para>
Add pgcrypto functions sha256crypt() and sha512crypt() (Bernd Helmle)
<ulink url="&commit_baseurl;749a9e20c">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-02-14 [9ad1b3d01] pgcrypto: Add support for CFB mode in AES encryption
-->

<listitem>
<para>
Add CFB mode to pgcrypto encryption and decryption (Umar Hayat)
<ulink url="&commit_baseurl;9ad1b3d01">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2025-01-24 [035f99cbe] pgcrypto: Make it possible to disable built-in crypto
-->

<listitem>
<para>
Add pgcrypto server variable builtin_crypto_enabled to allow disabling builtin non-FIPS mode cryptographic functions (Daniel Gustafsson, Joe Conway)
<ulink url="&commit_baseurl;035f99cbe">&sect;</ulink>
</para>

<para>
This is useful for guaranteeing FIPS mode behavior.
</para>
</listitem>

     </itemizedlist>
    </sect4>

   </sect3>

  </sect2>

  <sect2 id="release-18-acknowledgements">
   <title>Acknowledgments</title>

   <para>
    The following individuals (in alphabetical order) have contributed
    to this release as patch authors, committers, reviewers, testers,
    or reporters of issues.
   </para>

   <simplelist>
    <member>(to be completed)</member>
   </simplelist>
  </sect2>

 </sect1>