Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

use_page_* session settings

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
VersionDefault valueComment
24.30Added 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
VersionDefault valueComment
26.20New 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
VersionDefault valueComment
26.20New 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
VersionDefault valueComment
25.30New setting

Use userspace page cache when distributed cache is used.

Navigation