Home • Explore • Blog • CI
☰



postgresql
29th chunk of `doc/src/sgml/release-18.sgml`
f9f56380c55adc90a2b85dc747b20588e63bddea6b77bddb0000000100000fa4
 <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>
2024-08-15 [c4e44224c] Extend mul_var_short() to 5 and 6-digit inputs.
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2024-08-15 [8dc28d7eb] Optimise numeric multiplication using base-NBASE^2 arith
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2024-10-04 [9428c001f] Speed up numeric division by always using the "fast" alg
-->

<listitem>
<para>
Improve the speed of numeric multiplication and division (Joel Jacobson, Dean Rasheed)
<ulink url="&commit_baseurl;ca481d3c9">&sect;</ulink>
<ulink url="&commit_baseurl;c4e44224c">&sect;</ulink>
<ulink url="&commit_baseurl;8dc28d7eb">&sect;</ulink>
<ulink url="&commit_baseurl;9428c001f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tomas Vondra <tomas.vondra@postgresql.org>
2025-04-07 [65c298f61] Add support for basic NUMA awareness
Author: Tomas Vondra <tomas.vondra@postgresql.org>
2025-04-07 [8cc139bec] Introduce pg_shmem_allocations_numa view
Author: Tomas Vondra <tomas.vondra@postgresql.org>
2025-04-07 [ba2a3c230] Add pg_buffercache_numa view with NUMA node info
-->

<listitem>
<para>
Add configure option --with-libnuma to enable NUMA awareness (Jakub Wartak, Bertrand Drouvot)
<ulink url="&commit_baseurl;65c298f61">&sect;</ulink>
<ulink url="&commit_baseurl;8cc139bec">&sect;</ulink>
<ulink url="&commit_baseurl;ba2a3c230">&sect;</ulink>
</para>

<para>
The function pg_numa_available() reports on NUMA awareness, and system views pg_shmem_allocations_numa and pg_buffercache_numa which report on shared memory distribution across
NUMA nodes.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-18 [b52c4fc3c] Add TOAST table to pg_index.
-->

<listitem>
<para>
Add TOAST table to pg_index to allow for very large index expression indexes (Nathan Bossart)
<ulink url="&commit_baseurl;b52c4fc3c">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-12-20 [02a8d0c45] Remove pg_attribute.attcacheoff column
-->

<listitem>
<para>
Remove column pg_attribute.attcacheoff (David Rowley)
<ulink url="&commit_baseurl;02a8d0c45">&sect;</ulink>
</para>
</listitem>

<!--
Author: Melanie Plageman <melanieplageman@gmail.com>
2025-03-03 [99f8f3fbb] Add relallfrozen to pg_class
-->

<listitem>
<para>
Add column pg_class.relallfrozen (Melanie Plageman)
<ulink url="&commit_baseurl;99f8f3fbb">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-09-10 [56fead44d] Add amgettreeheight index AM API routine
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-07 [af4002b38] Rename amcancrosscompare
-->

<listitem>
<para>
Add amgettreeheight, amconsistentequality, and amconsistentordering to the index access method API (Mark Dilger)
<ulink url="&commit_baseurl;56fead44d">&sect;</ulink>
<ulink url="&commit_baseurl;af4002b38">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-09-17 [7406ab623] Add stratnum GiST support function
-->

<listitem>
<para>
Add GiST support function
Title: PostgreSQL 18: Performance Optimizations and New Features
Summary
This section covers performance improvements in PostgreSQL 18, including faster CRC32C calculations using x86 AVX-512, ARM Neon and SVE intrinsics for popcount, and enhanced numeric multiplication and division speeds. It also introduces NUMA awareness with the configure option --with-libnuma, and system views for shared memory distribution across NUMA nodes. Additionally, a TOAST table is added to pg_index, pg_attribute.attcacheoff is removed, pg_class.relallfrozen is introduced, and new functions are added to the index access method API.