Home Explore Blog CI



postgresql

28th chunk of `doc/src/sgml/release-18.sgml`
fa663c3e0ad937191c596d2bfded45e04c441a43754cb0170000000100000fb4
 Khanna)
<ulink url="&commit_baseurl;fb2ea12f4">&sect;</ulink>
</para>
</listitem>

<!--
Author: Amit Kapila <akapila@postgresql.org>
2025-03-20 [e5aeed4b8] pg_createsubscriber: Add -R publications option.
-->

<listitem>
<para>
Add pg_createsubscriber option --remove to remove publications (Shubham Khanna)
<ulink url="&commit_baseurl;e5aeed4b8">&sect;</ulink>
</para>
</listitem>

<!--
Author: Amit Kapila <akapila@postgresql.org>
2025-02-26 [e117cfb2f] Add two-phase option in pg_createsubscriber.
-->

<listitem>
<para>
Add pg_createsubscriber option --enable-two-phase to enable prepared transactions (Shubham Khanna)
<ulink url="&commit_baseurl;e117cfb2f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2025-04-04 [cf2655a90] pg_recvlogical: Add - -failover option.
-->

<listitem>
<para>
Add pg_recvlogical option --failover to specify failover slots (Hayato Kuroda)
<ulink url="&commit_baseurl;cf2655a90">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2025-03-25 [c68100aa4] Allow pg_recvlogical - -drop-slot to work without - -dbnam
-->

<listitem>
<para>
Allow pg_recvlogical --drop-slot to work without --dbname (Hayato Kuroda)
<ulink url="&commit_baseurl;c68100aa4">&sect;</ulink>
</para>
</listitem>

     </itemizedlist>

    </sect4>

   </sect3>

   <sect3 id="release-18-source-code">
    <title>Source Code</title>

    <itemizedlist>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-07-05 [4b211003e] Support loading of injection points
Author: Michael Paquier <michael@paquier.xyz>
2024-07-18 [a0a5869a8] Add INJECTION_POINT_CACHED() to run injection points dir
-->

<listitem>
<para>
Separate the loading and running of injection points (Michael Paquier, Heikki Linnakangas)
<ulink url="&commit_baseurl;4b211003e">&sect;</ulink>
<ulink url="&commit_baseurl;a0a5869a8">&sect;</ulink>
</para>

<para>
Injection points can now be created, but not run, via INJECTION_POINT_LOAD(), and such injection points can be run via INJECTION_POINT_CACHED().
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-05-10 [371f2db8b] Add support for runtime arguments in injection points
-->

<listitem>
<para>
Support runtime arguments in injection points (Michael Paquier)
<ulink url="&commit_baseurl;371f2db8b">&sect;</ulink>
</para>
</listitem>

<!--
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
2024-07-26 [20e0e7da9] Add test for early backend startup errors
-->

<listitem>
<para>
Allow inline injection point test code with IS_INJECTION_POINT_ATTACHED() (Heikki Linnakangas)
<ulink url="&commit_baseurl;20e0e7da9">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-08-05 [ca6fde922] Optimize JSON escaping using SIMD
-->

<listitem>
<para>
Improve the performance of processing long JSON strings using SIMD instructions (David Rowley)
<ulink url="&commit_baseurl;ca6fde922">&sect;</ulink>
</para>
</listitem>

<!--
Author: John Naylor <john.naylor@postgresql.org>
2025-04-06 [3c6e8c123] Compute CRC32C using AVX-512 instructions where availabl
-->

<listitem>
<para>
Speed up CRC32C calculations using x86 AVX-512 instructions (Raghuveer Devulapalli, Paul Amonson)
<ulink url="&commit_baseurl;3c6e8c123">&sect;</ulink>
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-28 [6be53c276] Optimize popcount functions with ARM Neon intrinsics.
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-28 [519338ace] Optimize popcount functions with ARM SVE intrinsics.
-->

<listitem>
<para>
Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi)
<ulink url="&commit_baseurl;6be53c276">&sect;</ulink>
<ulink url="&commit_baseurl;519338ace">&sect;</ulink>
</para>
</listitem>

<!--
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>

Title: Enhanced Logical Replication and Source Code Improvements in PostgreSQL 18
Summary
This section details improvements to logical replication, including allowing pg_recvlogical's --drop-slot option to function without --dbname. It also covers source code enhancements such as separating the loading and running of injection points, supporting runtime arguments in injection points, improving JSON string processing performance using SIMD, accelerating CRC32C calculations with AVX-512 instructions, and adding ARM Neon and SVE CPU intrinsics for popcount.