---
title: "Redshift"
description: "1 posts about Redshift, summarised, each linking to the original."
---

# Redshift
> 1 posts about Redshift, summarised, each linking to the original.

## Articles

### [Why Redshift Serverless can’t match ClickHouse Cloud for real-time analytics](https://yomu.fyi/post/why-redshift-serverless-can-t-match-clickhouse-cloud-for-real-time-ana.md)
- Company: [Clickhouse](https://yomu.fyi/company/clickhouse.md)
- Published: Oct 14, 2026
- Type: Benchmark

CostBench streamed 113.2 billion stock-market quotes into both systems while four aggregate queries ran every ten minutes and two drill-down queries ran every hour. ClickHouse asynchronous inserts order raw data and build pre-aggregations during ingestion, while Redshift relies on separate background sorting and materialized view refreshes. ClickHouse Cloud led in preparation cost ($28.69 versus 522.03), normalized query cost ( 0.05 versus $24.97), and accumulated query runtime (58.12 seconds versus 1.69 hours). The combined score shows ClickHouse Cloud delivered 1,996× better end-to-end performance per dollar in this continuous-ingestion comparison. The difference originates in the preparation path: ClickHouse makes data query-ready during inserts, whereas Redshift’s streaming, sorting, and refresh steps advance independently.