The experimental query result cache in ClickHouse now supports more modular configuration settings.
Why it matters
This feature enhances the flexibility and control over the query result cache by allowing users to configure cache settings in a more modular way. It improves cache management and tuning, enabling better performance optimization and resource utilization for query caching.How to use it
Users can adjust the query result cache behavior by modifying the new modular configuration parameters introduced in the system settings. These settings can be applied in the configuration files or dynamically via system queries to control caching scope, eviction, and other cache-related options.