v.25.10New Feature
Add session setting to exclude list of skip indexes from materialization on inserts
Added session setting to exclude list of skip indexes from materialization on inserts (exclude_materialize_skip_indexes_on_insert). Added merge tree table setting to exclude list of skip indexes from materialization during merge (exclude_materialize_skip_indexes_on_merge). #87252 (George Larionov).
Why it matters
This feature allows users to control which skip indexes are materialized, preventing unnecessary index updates on data insertion and merges. This can improve performance and reduce overhead when certain skip indexes are not needed to be updated during these operations.How to use it
Users can enable this feature by setting theexclude_materialize_skip_indexes_on_insert session setting to specify which skip indexes to exclude from materialization on inserts. Similarly, the exclude_materialize_skip_indexes_on_merge table setting can be configured on MergeTree tables to exclude certain skip indexes from materialization during merges.