1
Moving our warehouse off DuckDB
We moved our warehouse product off DuckDB and DuckLake onto our own flavor of Trino and a new open table format, HogLake. Here's what broke at scale and why.
PostHog automatically diagnoses problems, fixes bugs, and generates pull requests – all without you having to prompt it.
Visit posthog.com → RSS feedOn Hacker News Feb 2020 – Nov 2026
Tech Industry & Business 5Tools & Productivity 4Startups 3Infrastructure & DevOps 2Databases & Data 2Career & Management 2
We moved our warehouse product off DuckDB and DuckLake onto our own flavor of Trino and a new open table format, HogLake. Here's what broke at scale and why.
After the success of using agents to improve query performance through autoresearch , I wanted to try something more ambitious. I rewrote PostHog's…