Dive into our latest blog to explore a rigorous ClickHouse benchmark tournament, featuring AWS’s 7th-gen Intel m7i, AMD m7a, and Graviton m7g instances. With Altinity.Cloud’s easy configuration, discover which instance offers the best price-performance ratio for your cloud operations. Find…
Key-value pairs are widely used to organize data but can become challenging when you want to analyze data of different formats. Learn how you can normalize and extract from different formats with a single approach.
Supported in ClickHouse, Apache Parquet has use cases other than just a storage format in the Hadoop ecosystem. See what results we got when we tested it in Altinity.Cloud to query Parquet files at S3 with the same efficiency as…
AWS introduced new instance type families, powered by Graviton3 ARM processors: m7g and r7g. We tested m7g’s performance using the ClickHouse SSB workload and found it’s 35% faster its older brother m6g, and 15% faster than Intel m6i instance! Learn…
Rick Bilodeau from Imply published an excellent article in June 2020 comparing Druid cost-efficiency to Google Big Query for what they called ‘hot analytics’ — sub-second response time with high query concurrency. We appreciate this effort and great results of…
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…
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…
Jan 1, 2020Cost-efficiency and performance are critical for big data analytics. For this reason a recent blog post from ScyllaDB guys caught our attention. They collected over 500 billion data points and were able to query it with 1B rows/sec…
July 10, 2019Modern analytical databases would not exist without efficient data compression. Storage gets cheaper and more performant, but data sizes typically grow even faster. Moore’s Law for big data outperforms its analogy in hardware. In our blog we already…
May 23, 2019ClickHouse offers incredible flexibility to solve almost any business problem in a multiple of ways. Schema design plays a major role in this. For our recent benchmarking using the Time Series Benchmark Suite (TSBS) we replicated TimescaleDB schema…
Dec 4, 2018Our previous take on time series benchmarks attracted a lot of interest so we decided to dig into more details. We conducted 3 different ClickHouse scalability tests using the same TSBS dataset and benchmarking infrastructure. In this article…
Nov 15, 2018Once upon a time we spotted TSBS (https://github.com/timescale/tsbs) — Time Series Benchmark Suite, started by InfluxDB engineers and polished to perfection by TimescaleDB team. The suite allows to compare apples-to-apples when testing different databases: it is a framework…
