Yes, in fact, it's specifically designed for data that doesn't fit in RAM. Their storage engine optimizes data locality for fast retrieval from non-flash storag

Yes, in fact, it's specifically designed for data that doesn't fit in RAM. Their storage engine optimizes data locality for fast retrieval from non-flash storage. See: https://clickhouse.yandex/presentations/data_at_scale/ https://clickhouse.yandex/presentations/data_at_scale/ Their docs also talk about it a lot.