Oracle and MS SQL Got NUMA, AVX-512, and IO_uring
A new release has strengthened data protection and expanded tools for developers.
A new release has strengthened data protection and expanded tools for developers.
PostgreSQL has released version 18.0 — the annual major update of the popular SQL database server. This new release contains significant performance improvements and a number of functional innovations.
One of the key changes is support for NUMA architecture, which allows for more efficient load distribution on multi-core systems. The use of AVX-512 for CRC32C computations has also been implemented, speeding up data integrity checks.
A substantial step forward is the addition of asynchronous I/O and support for IO_uring in Linux, which reduces latency during intensive disk subsystem operations.
The optimization system now includes a self-join elimination mechanism, allowing the database to reduce redundant computations. For JSON processing, SIMD-accelerated escaping has been added, increasing the speed of text operations.
New features also include virtual generated columns and temporal constraints, expanding the toolkit for developers.
The text processing system has been improved, replication mechanisms have been refined, and the vacuum strategy has been enhanced. Now, during initialization with initdb, page checksums are enabled by default, increasing data storage reliability.
The PostgreSQL community notes that version 18.0 contains dozens of optimizations and changes aimed at improving overall performance.
