Why we're moving our warehouse off DuckDB

PostHog is migrating its data warehouse from DuckDB to Trino after five months because DuckDB, while excellent for single-machine analytics, couldn't efficiently scale to handle their customers' increasingly complex and large workloads in the cloud. The company found that DuckDB's lack of distributed architecture, combined with challenges in resource prediction, slow S3 data fetching, and limitations in the DuckLake extension's catalog design, made it impractical for delivering predictable performance at scale.