Hotdata vs ClickHouse

9× faster than ClickHouse

On the same hardware, with your ClickHouse SQL as written.

At a glance

TopicHotdataClickHouse
What it isA Rust query engine built for low latency at high concurrency.A column-oriented analytics database.
Where data livesQueries your sources in place, or Parquet in an instant database.Loaded into ClickHouse tables.
DeploymentIn your VPC, run by us. Or fully managed.Self-hosted or ClickHouse Cloud.
PricingCompute runs only while queries run.Compute by the hour, plus storage.
Concurrency9× faster than ClickHouse with 10 concurrent clients.Scales up with bigger services.
Combining sourcesJoin Postgres, warehouses, lakes, and files in one query.Built around its own tables.
SearchVector, full-text, and geospatial in one SQL query.Vector and full-text indexes.
SQLPostgres-familiar HotSQL. PostgreSQL, DuckDB, Snowflake, and ClickHouse SQL run as written.ClickHouse SQL.

Performance

9× faster than ClickHouse, with 10 clients querying at once.

p95 query latency
  1. 1

    Hotdata

    4 vCPU · 16 GiB

    0.38 s

    p50 0.17 s · 51.1 q/s

  2. 2

    ClickHouse

    4 vCPU · 16 GiB

    3.39 s

    p50 1.40 s · 6.4 q/s

Which one fits

Choose Hotdata when

  • You want 9× lower tail latency on the same hardware.
  • Your data lives in Postgres, a warehouse, and object storage, and you don't want to load it all first.
  • Your ClickHouse SQL should run as written, next to Postgres and Snowflake SQL.
  • You want it run for you, in your own VPC.

ClickHouse still fits when

  • You ingest large event streams into one database and serve dashboards from it.
  • You want to self-host and tune the database yourself.

Deployed in your VPC

We deploy Hotdata into your own VPC and operate it for you. If you would rather not run any infrastructure, a fully managed option is also available.

Security
Your data stays in your own cloud account. You keep control of the infrastructure, access, and keys.
Performance
Hotdata runs in the same network as your databases and object storage, so reads stay inside your cloud.