Skip to content
ClickHouse Docs

index_granularity_* MergeTree table settings

Autogenerated from ClickHouse system tables

These settings are available in system.merge_tree_settings and are autogenerated from the ClickHouse snapshot.

index_granularity

Maximum number of data rows between the marks of an index. I.e how many rows correspond to one primary key value.

index_granularity_bytes

Maximum size of data granules in bytes.

To restrict the granule size only by number of rows, set to 0 (not recommended).