v.25.5Improvement

Made page cache settings adjustable

Made page cache settings adjustable on a per-query level. This is needed for faster experimentation and for the possibility of fine-tuning for high-throughput and low-latency queries. #79337 (Alexey Milovidov).
Made page cache settings adjustable on a per-query level in ClickHouse.

Why it matters

This feature allows users to fine-tune page cache parameters individually for each query, enabling faster experimentation and optimization tailored to high-throughput or low-latency requirements, improving query performance and resource management.

How to use it

Users can adjust page cache settings by specifying relevant parameters within their queries, enabling customized cache behavior on a per-query basis. This enables selective tuning without global configuration changes.