v.24.3Improvement

Use temporary_files_codec setting for all temporary data creation

Official CH changelog text
Use temporary_files_codec setting in all places where we create temporary data, for example external memory sorting and external memory GROUP BY. Before it worked only in partial_merge JOIN algorithm. #61456 (Maksim Kita).
Expanded the use of the temporary_files_codec setting to control compression of temporary data in all relevant operations, including external memory sorting and external memory GROUP BY, beyond its prior limitation to the partial_merge JOIN algorithm.

Why it matters

This feature allows users to customize the compression codec used for temporary files generated during heavy query operations such as external sorting and grouping. By enabling control over compression in more scenarios, users can optimize disk usage and performance during query execution.

How to use it

Set the temporary_files_codec setting to the desired compression codec in your query or server configuration. It will then apply to all temporary files created during operations like external memory sorting, external memory GROUP BY, and partial_merge JOIN algorithms automatically.

Related resources

PreviousNext