v.23.8Improvement
Expert Configuration for Cache Size and Policy in ClickHouse
As expert-level settings, it is now possible to (1) configure the size_ratio (i.e. the relative size of the protected queue) of the [index] mark/uncompressed caches, (2) configure the cache policy of the index mark and index uncompressed caches. #53657 (Robert Schulze).
Why it matters
This feature allows fine-tuning of the cache behavior for index marks and their uncompressed data, enabling better control over cache performance and resource management. Users can optimize cache efficiency based on their workload characteristics.How to use it
Users can adjust thesize_ratio and cache policy settings for the index mark and index uncompressed caches by modifying the appropriate expert-level configuration parameters in the ClickHouse server configuration files or via runtime settings.