3 ms·
You can run it on a cluster or a single server. It's pretty easy to setup either way. No updates. Fast inserts. You can only join two tables at a time, but th
by sin7 8y ago
You can run it on a cluster or a single server. It's pretty easy to setup either way.
No updates. Fast inserts.
You can only join two tables at a time, but the joins can be chained to deal with this limitation.
I tried Monet. It wasn't very stable for me. I didn't stick with it long enough to judge it. ClickHouse has backing of Yandex. I think that makes a huge difference.
I have used Clickhouse for the past year. Thrown 3000 column by 120 million row tables on it. It worked where PostgreSQL came to a halt. Different use cases really.
I fits my use case perfectly. Large amounts of data with no updates and tons of aggregations. It's lighting fast.
- manigandham 8y agoIt does support updates and deletes now, but still limited.