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
Analytics

Connecting ClickHouse® to Apache Kafka®

Shiv Iyer
Connecting ClickHouse® to Apache Kafka®: A Complete Technical Guide Introduction Apache Kafka and ClickHouse form a powerful combination for real-time analytics and data processing. ClickHouse, a high-performance columnar database, excels at analytical workloads, while Kafka […]
Cassandra

ColumnStore vs. Modern Data Warehousing

Shiv Iyer
ColumnStore vs. Modern Data Warehousing: Optimizing Real-Time Analytics Performance Introduction Real-time analytics has become the cornerstone of data-driven decision making, demanding storage architectures that can handle massive volumes while delivering sub-second query performance. This technical […]
ClickHouse Performance

Eliminating Expensive JOINs in ClickHouse

Shiv Iyer
Eliminating Expensive JOINs in ClickHouse: Advanced JSON and Array Optimization Techniques for High-Performance Analytics Introduction In the world of high-performance analytics, JOIN operations often represent the most significant bottleneck in query execution. ClickHouse, the open-source […]
ClickHouse Performance

ClickHouse Thread Architecture

Shiv Iyer
Mastering ClickHouse Thread Architecture: A Deep Dive into High-Performance Query Execution ClickHouse’s reputation as one of the fastest analytical databases stems largely from its sophisticated thread management system. Understanding how ClickHouse orchestrates threads can help […]
ClickHouse Query Performance

Troubleshooting Suboptimal ClickHouse Queries

Shiv Iyer
ClickHouse Queries To troubleshoot and optimize slow ClickHouse queries, follow these steps: 1. Use EXPLAIN to Analyze Query Plans EXPLAIN syntax SELECT * FROM table WHERE condition Available syntax options: EXPLAIN PLAN – shows execution […]
ClickHouse Performance

ClickHouse Query Optimizer

Shiv Iyer
ClickHouse Query Optimizer: How It Transforms Your SQL Into Lightning-Fast Execution ClickHouse’s reputation for blazing-fast analytics isn’t accidental – it’s the result of a sophisticated query optimization pipeline that transforms your SQL into highly efficient […]