TLDR Data · DEEP DIVES

WHY WE'RE MOVING OUR WAREHOUSE PRODUCT OFF DUCKDB

posthog.com5 min read

Summary from the TLDR Data newsletter

Five months after rebuilding its warehouse product on DuckDB, PostHog is moving off it. Each instance had to be sized before the query arrived, and its DuckLake, holding about 1 trillion rows, could take over three minutes for a single-table write. PostHog is now rebuilding on Trino with its own table format, HogLake.