v.19.16New Feature

Add a New Database Engine Lazy That Is Optimized for Storing a Large Number of Small -log Tables

Add a new database engine Lazy that is optimized for storing a large number of small -Log tables. #7171 (Nikita Vasilev)
Lazy is a new database engine in ClickHouse optimized for storing a large number of small -Log tables efficiently.

Why it matters

This feature addresses the challenge of managing many small -Log tables, which can be inefficient in terms of storage and performance. The Lazy engine improves resource utilization and query performance when working with numerous small log tables.

How to use it

To use the Lazy engine, create a table specifying ENGINE = Lazy(). This engine is designed specifically for tables ending with -Log to optimize their storage and access patterns.