Company moves data warehouse off DuckDB
The gist
PostHog moved its data warehouse off DuckDB and DuckLake onto a custom Trino setup and HogLake.
The rapid engine churn has drawn skepticism about upfront planning.
How it unfolded
- Nov 2, 2026PostHog published 'Why we're moving our warehouse off DuckDB,' saying it spent three months re-architecting onto a custom Trino setup and a new open table format called HogLake.
- Nov 2, 2026PostHog said it had rebuilt its warehouse on DuckDB instead of ClickHouse five months earlier, because a shared ClickHouse cluster couldn't handle hours-long modeling queries and lacked a cost-based query optimizer.
- Nov 2, 2026At the time PostHog moved off it, DuckLake held about 2 PB, roughly 1 trillion rows and 15.3 million snapshots.