v.23.5Experimental Feature

DEFLATE_QPL Codec Lowers Minimum SIMD Version to SSE 4.2 and Updates ClickHouse CMakefile for QPL Alignment

DEFLATE_QPL codec lower the minimum simd version to SSE 4.2. doc change in qpl - Intel® QPL relies on a run-time kernels dispatcher and cpuid check to choose the best available implementation(sse/avx2/avx512) - restructured cmakefile for qpl build in clickhouse to align with latest upstream qpl. #49811 (jasperzhu).
DEFLATE_QPL codec now supports a lower minimum SIMD version, starting with SSE 4.2, improving compatibility and performance on more CPUs.

Why it matters

The change enables ClickHouse to utilize Intel® QPL's DEFLATE codec optimally by leveraging a run-time kernel dispatcher that selects the best available SIMD implementation (SSE, AVX2, AVX512) based on the CPU's capabilities. This improves compression efficiency and broadens hardware compatibility, ensuring better performance on systems with SSE 4.2 or higher.

How to use it

The DEFLATE_QPL codec is integrated into ClickHouse and benefits from the updated SIMD support automatically. Users do not need to make configuration changes; the codec will internally detect and use the best available SIMD instruction set at runtime. The CMake build system has been updated to align with the latest Intel QPL build process.