Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
read_from_distributed_cache_if_exists_otherwise_bypass_cache

Only has an effect in ClickHouse Cloud. Same as read_from_filesystem_cache_if_exists_otherwise_bypass_cache, but for distributed cache.

​
read_from_filesystem_cache_if_exists_otherwise_bypass_cache

Allow to use the filesystem cache in passive mode - benefit from the existing cache entries, but don’t put more entries into the cache. If you set this setting for heavy ad-hoc queries and leave it disabled for short real-time queries, this will allows to avoid cache threshing by too heavy queries and to improve the overall system efficiency.

​
read_from_page_cache_if_exists_otherwise_bypass_cache

Use userspace page cache in passive mode, similar to read_from_filesystem_cache_if_exists_otherwise_bypass_cache.
Last modified on July 24, 2026