Case Study: Beehiiv boosts real-time analytics and scalability with ClickHouse Cloud

The story of beehiiv’s journey from Postgres to ClickHouse

beehiiv is a newsletter platform that helps creators, publishers, and businesses grow and monetize email audiences. As its email volume surged into the billions of events, the company’s Postgres-based data system struggled with scalability and real-time analytics, creating performance issues and requiring too much engineering effort.

To solve this, beehiiv moved its data infrastructure to ClickHouse Cloud, using Kafka, ReplacingMergeTree tables, dictionaries, materialized views, and window functions to power a scalable event-driven analytics stack. The result was dramatically faster insights, with median query times of 22 ms and average query times of 85 ms, plus the ability to store over 33 billion raw events in six months and deliver user-facing analytics within seconds.

Beehiiv

Eric Abis

Head of Data Infrastructure and Engineering