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_lookahead_for_text_index
Text index files that are read out of file order (dictionary, postings, positions) are, by default, read through the userspace page cache with a lookahead of one block, so that the remote connection can be reused after each read. Enable this setting to make those files usepage_cache_lookahead_blocks like other files instead.