clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Down with `SETTINGS index_granularity = 8192`!

Open rschu1ze opened this issue 10 months ago • 2 comments

Whether it is

..., people continue to append SETTINGS index_granularity = 8192 to CREATE TABLE statements in technical articles, examples etc. Don't know why this is (perhaps the setting was mandatory in the past) but it is definitely not necessary: 8192 rows is the default already. I actually consider explicitly specifying the index granularity a bad practice as one could think 8192 has a special significance for the current SQL.

It would be nice to check our docs and also clickhouse.com/blog for similar mentions of SETTINGS index_granularity = 8192 and remove it.

rschu1ze avatar Jan 15 '25 11:01 rschu1ze