v.23.5New Feature
Query Cache Now Supports Production Workloads and Totals Modifier
The query cache can now be used for production workloads. #47977 (Robert Schulze). The query cache can now support queries with totals and extremes modifier. #48853 (Robert Schulze). Make allow_experimental_query_cache setting as obsolete for backward-compatibility. It was removed in https://github.com/ClickHouse/ClickHouse/pull/47977. #49934 (Timur Solodovnikov).Why it matters
The query cache feature resolves the need to efficiently reuse results of repeated queries in production environments, improving performance and reducing query execution time. Supporting queries with theTOTALS and EXTREMES modifiers expands the cache applicability to a wider range of query patterns, enhancing usability and effectiveness.How to use it
The query cache is enabled by default for production use. The previous experimental setting<code>allow_experimental_query_cache</code> has been made obsolete and removed. Users can rely on the stable query cache behavior without additional configuration. To leverage the query cache, simply run queries as usual; caching applies transparently including to those with TOTALS and EXTREMES modifiers.