PostgreSQL has released version 18.0, its annual major update to the widely used SQL database server. The new release introduces substantial performance enhancements along with a series of functional innovations.
Among the most significant changes is support for NUMA architecture, enabling more efficient workload distribution across multi-core systems. The update also brings AVX-512 acceleration for CRC32C computations, delivering faster integrity checks for stored data.
A major leap forward comes with the addition of asynchronous I/O and IO_uring support on Linux, reducing latency under heavy disk workloads.
On the optimization side, a new self-join elimination mechanism reduces redundant computations, while JSON handling now benefits from SIMD-accelerated escaping, significantly boosting text-processing performance.
Other notable features include virtual generated columns and temporal constraints, expanding developers’ toolsets for data modeling.
Improvements also extend to text processing, replication mechanisms, and the vacuum strategy. Notably, during initialization via initdb, page checksums are now enabled by default, enhancing data reliability.
The PostgreSQL community highlights that version 18.0 delivers dozens of optimizations and refinements, all aimed at elevating overall performance and dependability.
Support Our Threat Intelligence
If you find our CVE report and cybersecurity news helpful, consider supporting our work.
Buy Me a Coffee
PayPal
