Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

inactive_parts_* MergeTree table settings

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

inactive_parts_to_delay_insert

Type
UInt64
Default
0

If the number of inactive parts in a single partition in the table exceeds the inactive_parts_to_delay_insert value, an INSERT is artificially slowed down.

Possible values:

  • Any positive integer.

inactive_parts_to_throw_insert

Type
UInt64
Default
0

If the number of inactive parts in a single partition more than the inactive_parts_to_throw_insert value, INSERT is interrupted with the following error:

“Too many inactive parts (N). Parts cleaning are processing significantly slower than inserts” exception.”

Possible values:

  • Any positive integer.
Navigation