v.25.10New Feature

Add a new table

Add a new table setting min_level_for_wide_part that allows specifying the minimum level for a part to be created as a wide part. #88179 (Christoph Wurm).
Introduces a new table setting min_level_for_wide_part to specify the minimum merge level from which parts are created as wide parts in ClickHouse.

Why it matters

This feature allows users to control the creation of wide parts based on the merge level, optimizing storage and query performance by delaying wide part creation until a specified level is reached.

How to use it

Set the min_level_for_wide_part setting in the table definition or via ALTER TABLE ... MODIFY SETTING to define the minimum level at which parts become wide parts. For example:

ALTER TABLE table_name MODIFY SETTING min_level_for_wide_part = 3;