Recently I dived deep into ClickHouse. ClickHouse is column-store database by Yandex with great performance for analytical queries. For example check benchmark and post of Mark Litwintschik. This is the translation of answer given by Alexey Milovidov (creator of ClickHouse) about composite primary key. Questions: How many columns primary key could have? And what is layout of data on storage drive?