Set up docs MCPThese settings are available in system.settings and are autogenerated from the ClickHouse snapshot.
use_page_cache_for_disks_without_file_cache
Use userspace page cache for remote disks that don’t have filesystem cache enabled.
use_page_cache_for_local_disks
Use userspace page cache when reading from local disks. Used for testing, unlikely to improve performance in practice. Requires local_filesystem_read_method = ‘pread’ or ‘read’. Doesn’t disable the OS page cache; min_bytes_to_use_direct_io can be used for that. Only affects regular tables, not file() table function or File() table engine.
use_page_cache_for_object_storage
Use userspace page cache when reading from object storage table functions (s3, azure, hdfs) and table engines (S3, Azure, HDFS).
use_page_cache_with_distributed_cache
Use userspace page cache when distributed cache is used.