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

​
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.