[ruw1090]

Yea, Redshift looks like it was run on an ra3.xl (4 cores) and is comparing against clickhouse on a c6a.4xl (16 cores). I suspect if this were normalized Redshift would have an edge.

[zX41ZdbW]

Redshift configuration was selected to get 16 cores in total, so it is 4 nodes of ra3.xplus 4vCPU to get 16vCPU in total.

https://github.com/ClickHouse/ClickBench/tree/main/redshift

We can add more results on different configurations easily.

There is also Redshift Serverless, which does not have any hardware configuration to tune.

[ruw1090]

That makes sense, thanks for clarifying. I got confused by the UI.

[zX41ZdbW]

I've also rerun the benchmark on 4x ra3.4xlarge (48 cores in total) and added it to the comparison.