v.25.8Experimental Feature

Previously, the text index data would be

Official CH changelog text
Previously, the text index data would be separated into multiple segments (each segment size by default was 256 MiB). This might reduce the memory consumption while building the text index, however this increases the space requirement on the disk and increase the query response time. #84590 (Elmi Ahmadov).
ClickHouse now consolidates text index data into fewer segments instead of multiple 256 MiB segments by default.

Why it matters

Previously, splitting text index data into many small segments reduced memory consumption during index building but increased disk space usage and query response time. This change aims to optimize storage efficiency and improve query performance by reducing the number of segments.

How to use it

Users benefit from this improvement automatically as the default segment size handling has been changed. There is no need for manual intervention unless custom segment sizes are configured.

Related resources

PreviousNext