4 ms·
Redshift doesn't separate compute from storage either unless you're using Spectrum. Presto isn't a database at all and can read from many data stores. The rest
by manigandham 8y ago
Redshift doesn't separate compute from storage either unless you're using Spectrum. Presto isn't a database at all and can read from many data stores. The rest are all cloud-hosted with lots of moving parts. MemSQL, Vertica, Actian, Greenplum, and SQL Server are better comparisons.
ClickHouse is a column-oriented db and actually one of the most advanced, focusing on performance at all costs with lots of table storage engines that provide flexibility for your exact use-case. It also supports distributed joins and deletes but has some limitations they are working on.
It can definitely use better tooling and compatibility though, but that's the tradeoff the core team made, and it seems to be working well for the companies that can afford the time and talent.
- georgewfraser 8y agoMy point is there’s just no advantage to ClickHouse. The things that make it fast are in every column store. There’s other options that do everything it does and more.
- manigandham 8y agoSpeed is the advantage. It's very fast for a self-hosted system and probably only beaten by BigQuery for throughput. You're right though that most people don't need it and can get 90% of the speed with better usability with the other options.
- bsg75 8y agoBy this definition we should all be running Oracle.