cache_populated_by_fetch_* MergeTree table settings

These settings are available in system.merge_tree_settings and are autogenerated from the ClickHouse snapshot.

cache_populated_by_fetch

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

• ignore_cold_parts_seconds
• prefer_warmed_unmerged_parts_seconds
• cache_warmer_threads

cache_populated_by_fetch_filename_regexp

If not empty, only files that match this regex will be prewarmed into the cache after fetch (if cache_populated_by_fetch is enabled).