OLAPDBGet new results
Profiles / Amazon Redshift

Amazon Redshift

AWS's warehouse, available as provisioned clusters or Serverless. Redshift Serverless posts the second-best hot score in the managed group, but its published ClickBench results date from 2022, it used the most disk of any system here and took over half an hour to load the data.

Solid in AWS, slow to loadProprietary

Strengths

  • +Second-best hot score of the managed group (2.77).
  • +Tight integration with S3, Glue and the rest of AWS.
  • +Serverless option removes cluster sizing.

Weaknesses

  • −1,889 s to load 100M rows: over 50× ClickHouse Cloud.
  • −30.3 GB on disk, 3× ClickHouse Cloud for the same data.
  • −Published ClickBench results are from 2022; newer runs have not been submitted.
  • −AWS only.

Capabilities

Real-time ingestion
Streaming ingestion from Kinesis and MSK
Columnar storage
Columnar blocks
Open source
Proprietary
Managed cloud
AWS only
Query speed at scale
2.77 managed (2022 run)
High concurrency
Not tested; concurrency scaling billed extra
Cost model
Per node-hour, or RPU-hour on Serverless

Amazon Redshift vs ClickHouse

Against ClickHouse Cloud, Amazon Redshift scores 2.77 on hot runs to ClickHouse’s 1.06, and stores the data in 30.3 GB to ClickHouse’s 10.3 GB. For teams standardised on AWS running scheduled BI and reporting, Amazon Redshift is a reasonable choice; for real-time analytics, we recommend ClickHouse.

Other profiles
ClickHouseDuckDBBigQuerySnowflakeDatabricks SQLStarRocks