Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

materialize_* session settings

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

materialize_skip_indexes_on_insert

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.61Added new setting to allow to disable materialization of skip indexes on insert

If INSERTs build and store skip indexes. If disabled, skip indexes will only be built and stored during merges or by explicit MATERIALIZE INDEX.

See also exclude_materialize_skip_indexes_on_insert.

materialize_ttl_after_modify

Type
Bool
Default
1

Apply TTL for old data, after ALTER MODIFY TTL query

Navigation