Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
Demystifying Data Compression in ClickHouse
ClickHouse Compression

Demystifying Data Compression in ClickHouse

Shiv Iyer
Introduction :Demystifying Data Compression “Compressing data is like putting it on a diet; it becomes leaner and faster.” – Unknown Data compression plays a pivotal role in optimizing storage and query performance in any database […]
Troubleshooting High CPU Usage in ClickHouse
clickhouse troubleshooting

Troubleshooting High CPU Usage in ClickHouse

Shiv Iyer
Introduction “Don’t watch the clock; do what it does. Keep going.” – Sam Levenson High CPU usage in ClickHouse can be a common challenge, especially when dealing with large datasets and complex queries. It can […]
Mastering Chained Joins In Clickhouse
ClickHouse Join

ClickHouse JOIN: Mastering Chained Joins

Shiv Iyer
Introduction Financial systems analytics demand sophisticated data manipulation, often involving multiple joins to extract valuable insights. In this guide, we will explore how to implement multiple joins, often referred to as chained joins, in ClickHouse, […]
Mastering Hash Joins In Clickhouse
ClickHouse Join

Hash Joins in ClickHouse: A Practical Guide

Shiv Iyer
Introduction : Hash Joins in ClickHouse  Hash Joins in ClickHouse are a powerful method for efficiently combining data from multiple tables. They fall under the category of “merge joins,” where ClickHouse takes advantage of sorted […]
Understanding Clickhouse Advanced Hash and Merge Joins
ClickHouse Performance

ClickHouse JOINs Explained: Advanced Hash and Merge Joins

Shiv Iyer
Introduction: ClickHouse Joins In the realm of data analytics, performance is often the key differentiator between success and stagnation. ClickHouse, an open-source columnar database management system, has gained popularity for its exceptional query performance, especially […]