v.20.8Improvement
Add min_index_granularity_bytes Setting to Prevent Low index_granularity_bytes Configuration
Add settingmin_index_granularity_bytesthat protects against accidentally creating a table with very lowindex_granularity_bytessetting. #14139 (Bharat Nallan).
Why it matters
This feature addresses the risk of accidentally setting very lowindex_granularity_bytes on tables, which can degrade performance or increase resource consumption. The setting enforces a minimum threshold to maintain efficient indexing and query execution.How to use it
Users can enable this protection by setting themin_index_granularity_bytes configuration parameter to the desired minimum value. This will cause table creation or alteration to fail if index_granularity_bytes is set below this threshold.