Customization of Compression Level for ZSTD Algorithm

Why it matters

This feature was created to give users control over the compression ratio and speed trade-off provided by ZSTD compression. By adjusting the compression level, users can optimize storage size or compression/decompression speed based on their specific workload and resource constraints, enhancing performance and resource management.

How to use it

When defining table compression settings or using functions that accept compression parameters, specify the desired compression level for ZSTD. For example, use the syntax zstd(level) where level is an integer typically between 1 (fastest, least compression) and 22 (slowest, maximum compression). Adjust this parameter to balance between compression speed and ratio according to your needs.