PostgreSQL 18.0 is out today as the annual major feature release for this widely-used SQL database server. PostgreSQL 18 is a big one with many exciting performance optimizations and other new features.

There is a heck of a lot to get excited about for PostgreSQL 18 if you are a database nerd and/or performance junkie. PostgreSQL 18 brings [1]initial support for NUMA awareness , [2]AVX-512 usage for CRC32C computations , [3]asynchronous I/O support , [4]initial support for IO_uring on Linux, [5]self-join elimination optimization , [6]SIMD-optimized JSON escaping , and a range of other performance improvements and different optimizations.

PostgreSQL 18 also brings virtual generated columns, temporal constraints, and other new developer additions. There is also improved text processing, replication enhancements, better vacuum strategy, and initdb now enabling page checksums by default.

Downloads and more details on all of the really great changes with today's PostgreSQL 18.0 release can be found via [7]PostgreSQL.org .



[1] https://www.phoronix.com/news/PostgreSQL-Lands-NUMA-Awareness

[2] https://www.phoronix.com/news/PostgreSQL-CRC32C-AVX512

[3] https://www.phoronix.com/news/PostgreSQL-AIO-Batch-Mode

[4] https://www.phoronix.com/news/PostgreSQL-Lands-IO_uring

[5] https://www.phoronix.com/news/PostgreSQL-Self-Join-Eliminate

[6] https://www.phoronix.com/news/PostgreSQL-Opt-JSON-Esc-SIMD

[7] https://www.postgresql.org/about/news/postgresql-18-released-3142/