v.23.5Performance Improvement
Compress Marks and Primary Key Enabled by Default in Version 22.9
Compress marks and primary key by default. It significantly reduces the cold query time. Upgrade notes: the support for compressed marks and primary key has been added in version 22.9. If you turned on compressed marks or primary key or installed version 23.5 or newer, which has compressed marks or primary key on by default, you will not be able to downgrade to version 22.8 or earlier. You can also explicitly disable compressed marks or primary keys by specifying thecompress_marksandcompress_primary_keysettings in the<merge_tree>section of the server configuration file. #42587 (Alexey Milovidov).