Intel Finds Great Performance With PostgreSQL’s AVX-512 Support

PostgreSQL Enhances Performance with AVX-512 Support

In a significant advancement for the PostgreSQL community, the integration of AVX-512 support for CRC32 computations was introduced earlier this year. The enhancements, which were initially reported in April, showcased impressive performance gains ranging from 50% to three times faster execution on x86_64 CPUs equipped to utilize AVX-512 instructions. This feature is part of PostgreSQL 18.0, released in September, and has garnered praise from industry leaders, including Intel, who contributed to its development alongside AWS and other collaborators.

Intel recently shared insights in a blog post, highlighting the benefits of AVX-512 acceleration for CRC32C checksums within PostgreSQL. The company emphasized that this enhancement represents a “clear and substantial performance improvement for a wide range of realistic buffer sizes (from very small to moderately large). This patch is a state-of-the-art example of utilizing modern SIMD instructions to accelerate critical database primitives, with a focus on portability, correctness, and runtime efficiency.

The results from Intel’s testing on Xeon processors underscore the positive impact of AVX-512 on PostgreSQL’s performance. This achievement further solidifies the effectiveness of AVX-512 in real-world applications, echoing previous successes such as AVX-512 acceleration for JSON parsing and other software optimizations over the years.

Moreover, the AVX-512 support extends beyond Intel’s offerings, functioning seamlessly on AMD’s Zen 4 and newer processors, including EPYC servers and Ryzen client processors. This compatibility is made possible by the unified ISA across product lines, ensuring broad accessibility for users.

For those interested in exploring Intel’s comprehensive data and commentary regarding the AVX-512 accelerated checksums in PostgreSQL, the full post can be accessed at community.intel.com.

Tech Optimizer
Intel Finds Great Performance With PostgreSQL's AVX-512 Support