Dev Tools · 1h ago
Mac Mini vs. 100M Rows: ClickHouse Crushes Postgres in Database Showdown
A developer benchmarked Postgres and ClickHouse on a Mac Mini M4 Pro with 100 million rows of LLM trace data. ClickHouse completed analytical queries in seconds, while Postgres took minutes or crashed. The test mirrors real-world database migrations like Langfuse's move to ClickHouse.
Meridian48 take
The benchmark is a useful reality check for startups debating database choices, but real-world performance depends on hardware, indexing, and query patterns beyond this single test.
database-benchmarkclickhouse-vs-postgres