v.20.4Improvement

Add system_tables_lazy_load config option for server startup behavior

Official CH changelog text
Add config option system_tables_lazy_load. If it's set to false, then system tables with logs are loaded at the server startup. Alexander Burmak, Svyatoslav Tkhon Il Pak, #9642 #10359 (alexey-milovidov)
Introduces a new configuration option system_tables_lazy_load that controls whether system tables with logs are loaded lazily or eagerly at server startup.

Why it matters

This feature allows users to disable lazy loading of system tables containing logs, enabling these tables to be fully loaded during server startup. This can improve performance predictability and reduce latency when querying system tables immediately after server launch.

How to use it

Set the system_tables_lazy_load configuration option to false in the server configuration file to load system tables with logs at startup instead of lazy loading them on demand.

Related resources

PreviousNext