v.18.12Improvement

Increased Query Performance and Reduced Memory for Large Table Count in system.tables and system.columns

Official CH changelog text
Increased performance and reduced memory consumption for queries to system.tables and system.columns when there is a very large number of tables on a single server. #2953
Improved performance and reduced memory usage for querying system.tables and system.columns on servers with a very large number of tables.

Why it matters

This feature addresses the inefficiency and high memory consumption experienced when executing queries against system.tables and system.columns on servers hosting many tables. It optimizes these system queries to enhance overall responsiveness and resource utilization.

How to use it

The improvements are applied automatically in the updated ClickHouse version. Users can benefit from faster queries on system.tables and system.columns without any configuration or changes to their queries.

Related resources

PreviousNext