Benchmarking ClickHouse

ClickHouse, ClickHouse Performance Benchmarking, Columnar Database System, Data Analytics, Massively Parallel Processing Systems

Recently one of the customers wanted me to evaluate and recommend a Columnar Database System of Data Analytics. I have chosen ClickHouse, Vertica, Greenplum and MariaDB ColumnStore for this exercise. I have to admit all the Columnar Database Stores chosen for this exercise have there own compelling reasons and optimal at their own capacities. ClickHouse performance (by response time) was very impressive compared to Vertica, Greenplum and MariaDB ColumnStore . You can download the PDF here, reviews and comments are welcome, Thank you !

About Shiv Iyer 36 Articles

WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.

Contact:

* Everything changes over time – Our blogs/posts and comments changes over time, That’s how it should be! Whatever we comment from MinervaDB Inc. Teams (including Shiv Iyer) and other stakeholders or guest bloggers posted here are never permanent, These things worked for us. But, there is no guarantee they will never work for you too, When using the recommendations from ChistaDATA or MinervaDB or MinervaSQL or any other online resources / Google, You must test the advice before applying them to your production systems, and always invest for a robust Database DR solution, Thank you for understanding.

Email – contact@minervadb.com

(We are online 24*7)

Google Hangouts – contact@minervadb.com

(for emergency support and quick response)

☛ Contact Shiv Iyer
▬▬▬▬▬▬▬▬▬▬▬▬▬
Email – shiv@minervadb.com
Google Hangouts – shiv@minervadb.com

☛ Shiv Iyer LinkedIn
▬▬▬▬▬▬▬▬▬▬▬▬▬

https://www.linkedin.com/in/thewebscaledba/

☛ Shiv Iyer GitHub
▬▬▬▬▬▬▬▬▬▬▬▬▬

https://github.com/shiviyer

Discounts are applicable only for multi-year contracts / long-term engagements, We don’t hire low-quality and cheap rookie consultants to manage your mission-critical Database Systems Infrastructure Operations and so our consulting rates are competitive. Being a virtual corporation (no physical offices anywhere in the world), whatever you pay go directly to our consultant’s fee. It’s impossible for us to offer you low-cost consulting, support and remote DBA services with elite-class team, Thanks for understanding and doing business with MinervaDB.

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner. Copyrights © 2010-2022 All Rights Reserved by MinervaDB®.

UA-155183614-1

The WebScale Database Infrastructure Operations Experts

Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations

Benchmarking ClickHouse

Related Articles

How to use ProxySQL to work on ClickHouse like MySQL ?

ClickHouse and ProxySQL queries rewrite (Cross-post from ProxySQL)

Database Replication from MySQL to ClickHouse for High Performance WebScale Analytics