PostHog Switches Data Warehouse to DuckDB, Leaving ClickHouse Behind

PostHog announced a rebuild of its data warehouse architecture. The company chose DuckDB as the core storage engine. Engineers cited simplicity and native SQL support as key factors. DuckDB's in‑process design aligns with PostHog's product model. The move replaces a previous ClickHouse implementation. Performance benchmarks showed comparable query speeds. The transition aims to reduce operational overhead. Future updates will focus on extending analytics features.