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
ClickHouse Row Number Functions for High Performance
ClickHouse Functions

ClickHouse Row Number Functions for High Performance

Shiv Iyer
Introduction Row numbering methods play a crucial role in ClickHouse’s performance, particularly when dealing with extensive datasets and intricate queries. Different approaches, such as using the ROW_NUMBER() function, ARRAY JOIN clause, WITH ORDINALITY syntax, or […]
Inside the ClickHouse Query Execution Pipeline
ClickHouse Internals

ClickHouse Query Execution Pipeline: A Look Inside

Shiv Iyer
Introduction When it comes to high-performance analytics, ClickHouse stands out as a powerful columnar database. Behind its blazing-fast query processing lies a sophisticated execution pipeline that optimizes query performance and enables efficient data retrieval. In […]
How is Spill-to-Disk Optimization implemented in ClickHouse Memory?
ClickHouse Performance

ClickHouse Spill to Disk: How Memory Optimization Works

Shiv Iyer
Introduction Spill-to-Disk optimization is a pivotal feature in ClickHouse, designed to enhance both performance and reliability in scenarios where memory constraints arise during query execution. This optimization mechanism efficiently manages memory resources by temporarily storing […]