PostHog re-rebuilds its data warehouse five months after switching from ClickHouse to DuckDB

teodorio · x · 2026-11-03

PostHog published an engineering postmortem, "Why we're re-rebuilding our data warehouse": five months ago the team moved off a shared ClickHouse cluster — which couldn't handle hours-long modeling queries and lacked cost-based query optimization — to DuckDB. Now they're rebuilding the warehouse again, and the article explains why. The reposter's reaction: "I'm sorry, they were using what?"

Original post →

More from Infra

Infra channel →