PostgreSQL 16 Enhances Performance with SIMD Support for x86 & ARM

PostgreSQL 16 has been released has been released with several new features and performance improvements. The update includes enhancements in query parallelism, bulk data loading, and logical replication. One of the notable additions is SIMD support for both x86 and ARM architectures, which improves ASCII and JSON string processing, array operations, and sub-transaction searches. The release also introduces more SQL/JSON syntax, pg_stat_io for key I/O metrics, and various security and access control enhancements. Bulk loading using COPY can see up to a 300% performance improvement in some cases.

Source: Phoronix .