Skip to content
ClickHouse Docs
49.6kGet Started

materialize_statistics_on_insert_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

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

materialize_statistics_on_insert

TypeBoolDefault1

If statistics are build and materialized for newly inserted parts. Even if disabled, statistics are still be build and stored during merges or by explicit MATERIALIZE STATISTICS. Only tables whose current size plus the size of the block being written, does not exceed materialize_statistics_on_insert_max_table_size are affected.

materialize_statistics_on_insert_max_table_size

TypeUInt64Default26843545600

Only build and store column statistics for newly inserted parts (see materialize_statistics_on_insert) for tables whose current size plus the block being written, does not exceed this value. 0 means no size limit.

Navigation