I created a web page to compare different analytical databases (both self-managed and services, open-source and proprietary) on a realistic dataset.
It contains 20+ databases, each with installation and data loading scripts. And they can be compared to each other on a set of 43 queries, by data load time or by storage size.
There are switches to select different types of databases for comparison - for example, only MySQL compatible or PostgreSQL compatible.
If you play with the switches, many interesting details will be uncovered.
There are switches to select different types of databases for comparison - for example, only MySQL compatible or PostgreSQL compatible.
If you play with the switches, many interesting details will be uncovered.
Full description: https://github.com/ClickHouse/ClickBench/blob/main/README.md