Why we're moving our warehouse off DuckDB
- Five months ago, we rebuilt our warehouse on DuckDB instead of ClickHouse.
- We did it because a shared ClickHouse cluster couldn't handle hours-long modeling queries, and it lacked a cost-based query optimizer.
- DuckDB gave every customer their own instance, and tools like dbt could connect over Postgres.
Unverified
- Five months ago, we rebuilt our warehouse on DuckDB instead of ClickHouse.
- We did it because a shared ClickHouse cluster couldn't handle hours-long modeling queries, and it lacked a cost-based query optimizer.
- DuckDB gave every customer their own instance, and tools like dbt could connect over Postgres.
Sources: Posthog