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

​
cache_populated_by_fetch

This setting applies only to ClickHouse Cloud.
When cache_populated_by_fetch is disabled (the default setting), new data parts are loaded into the filesystem cache only when a query is run that requires those parts. If enabled, cache_populated_by_fetch will instead cause all nodes to load new data parts from storage into their filesystem cache without requiring a query to trigger such an action. See Also

​
cache_populated_by_fetch_filename_regexp

This setting applies only to ClickHouse Cloud.
If not empty, only files that match this regex will be prewarmed into the cache after fetch (if cache_populated_by_fetch is enabled).
Last modified on July 23, 2026