ClickHouse vs Redshift Performance for FinTech Risk Management

ClickHouse vs Redshift Performance for FinTech Risk Management

Alexander Zaitsev

ClickHouse SQL extensions, arrays, in particular, allow it to solve the business use case up to 100 times more efficiently than Redshift at 1/6th the cost. We know that ClickHouse is fast, but we were a bit surprised by these research results.

ClickHouse and Redshift Face Off Again in NYC Taxi Rides Benchmark

ClickHouse and Redshift Face Off Again in NYC Taxi Rides Benchmark

Alexander Zaitsev

Being that it has been roughly three years since we last compared ClickHouse to Amazon Redshift, we thought it was time for an update. Using the same popular benchmarking dataset of NYC taxi trips data over multiple years, current size is 1.3 billion rows.