PostgreSQL 17 is out today as the newest annual feature release to this widely-used SQL database server. Notable with PostgreSQL 17 is having an AVX-512 optimized bit_count function along with several other heavy hitting performance optimizations.

PostgreSQL 17 brings an AVX-512 optimized bit_count() function. The AVX-512 work has seen a [1]reported 48% performance improvement by Intel . PostgreSQL 17 also brings [2]SIMD-optimized JSON escaping for up to 4x the query performance.

PostgreSQL 17 also has a new internal memory structure for vacuum that consumes up to 20x less memory! Plus improvements to the I/O layer can yield up to 2x better write throughput for high concurrency workloads thanks to write-ahead log (WAL) processing enhancements. Plus there are other performance improvements too.

Some other PostgreSQL 17 additions include JSON_TABLE support, new MERGE features, a new collation provider, incremental backups support with pg_basebackup, and other feature additions and improvements.

Downloads and more details on the PostgreSQL 17 feature release via [3]PostgreSQL.org . I'll be running some new [4]PostgreSQL benchmarks soon against PostgreSQL 17.0.



[1] https://www.phoronix.com/news/Intel-Bit-Count-AVX-512-Postgre

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

[3] https://www.postgresql.org/about/news/postgresql-17-released-2936/

[4] https://openbenchmarking.org/test/pts/pgbench