Tag: ClickHouse

All the articles with the tag "ClickHouse".

• Designing Event Schemas for Product Analytics in ClickHouse

  6 Oct, 2026

  Fixed columns vs Map vs JSON, ORDER BY for funnels, dedup, TTL and materialized views: a practical event schema for product analytics in ClickHouse.

• Why ClickHouse Is Fast: Understanding MergeTree Internals

  6 Oct, 2026

  Parts, granules, sparse primary indexes, marks and background merges: a hands-on look at how MergeTree lets ClickHouse skip most of your data.

• How PostHog Uses ClickHouse for High-Performance Product Analytics

  26 Jan, 2026

  Modern product analytics platforms must process billions of events while still delivering low-latency queries for dashboards, funnels, and retention analysis. PostHog addresses this requirement by