ClickBench 10M: Hotdata vs Neon

We ran the ClickBench benchmark across 43 queries and 10 million rows (1.5 GB), comparing Hotdata to Neon.

I know it may not seem like a fair comparison to benchmark a transactional database against a columnar database. However, we've found that developers are increasingly using PostgreSQL as the primary data layer for agents because of its flexibility and ecosystem. While Postgres is great as the primary application database, when the workload shifts toward high-concurrency, low-latency search and analytical queries, a purpose-built engine like Hotdata is a better fit. This benchmark is intended to evaluate that increasingly common deployment pattern rather than compare the databases in their traditional use cases.

• Methodology: Best of 3 server-side execution times
• Hotdata: execution_time_ms from JSON API response
• Neon: EXPLAIN (ANALYZE, TIMING) Execution Time via direct psql