v.20.8Improvement

Add min_index_granularity_bytes Setting to Prevent Low index_granularity_bytes Configuration

Add setting min_index_granularity_bytes that protects against accidentally creating a table with very low index_granularity_bytes setting. #14139 (Bharat Nallan).
Add setting min_index_granularity_bytes to prevent creation of tables with excessively low index_granularity_bytes values.

Why it matters

This feature addresses the risk of accidentally setting very low index_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 the min_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.