v.21.11Improvements

Introduce compiled_expression_cache_elements_size setting

Introduce compiled_expression_cache_elements_size setting. If you will ever want to use this setting, you will already know what it does. #30667 (Maksim Kita).
Introduces the compiled_expression_cache_elements_size setting to control the size of the compiled expression cache in ClickHouse.

Why it matters

This setting provides users with the ability to manage the number of elements stored in the compiled expression cache. It is intended for advanced users who need to fine-tune query performance and resource usage related to expression compilation caching.

How to use it

Users can enable and configure this feature by setting the compiled_expression_cache_elements_size parameter in the ClickHouse server configuration or via a session-level setting. Adjusting this value controls the cache size for compiled expressions.