Topic

#clickhouse

2 posts ·view all posts

ClickHouse🟡Intermediate

Sep 1, 2026·8 min read

ClickHouse vs Snowflake: Serving Latency, Concurrency, and Two Very Different Bills

Where a real-time OLAP engine beats a cloud warehouse and where it quietly loses: query latency at high concurrency, ingest patterns, joins at scale, and the governance features you give up.

• clickhouse
• snowflake
• olap

ClickHouse🟢Beginner

Aug 30, 2026·5 min read

ClickHouse MergeTree: ORDER BY Is the Index, Tiny Inserts Are the Outage

ORDER BY is the only index that matters, one-row inserts explode parts, mutations rewrite data, and ClickHouse is not a warehouse stand-in. Batch the writes.

• clickhouse
• olap