v.24.4Improvement

Query Cache Excludes System Table Results

Official CH changelog text
The query cache now no longer caches results of queries against system tables (system., information_schema., INFORMATION_SCHEMA.*). #62376 (Robert Schulze).
The query cache in ClickHouse no longer caches results of queries against system tables such as system., information_schema., and INFORMATION_SCHEMA.*.

Why it matters

This feature prevents caching of system table queries to ensure that users always receive the most up-to-date metadata and system information, which can frequently change and should not be served from stale cache.

How to use it

No explicit action is required from users. The query cache automatically excludes queries on system tables from caching starting from this version.

Related resources

PreviousNext