“PostgreSQL 17 brings an AVX-512 optimized bit_count() function. The AVX-512 work has seen a reported 48% performance improvement by Intel.
PostgreSQL 17 also brings 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.”
/root 