These settings are available in system.settings and are autogenerated from source.
use_page_cache_for_disks_without_file_cache
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.3 | 0 | Added userspace page cache |
Use userspace page cache for remote disks that don’t have filesystem cache enabled.
use_page_cache_for_local_disks
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 0 | New setting to use userspace 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
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 0 | New setting to use userspace page cache for object storage table functions |
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
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.3 | 0 | New setting |
Use userspace page cache when distributed cache is used.