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
Fatal Background Processes in ClickHouse
clickhouse troubleshooting

Fatal Background Processes in ClickHouse

Shiv Iyer
Introduction ClickHouse is an open-source columnar database management system that is designed to handle high volumes of data and support high concurrency. However, like any complex system, it is possible for background processes to fail, […]
How does ClickHouse Merge Sort Algorithm work?
ClickHouse SORT

How does ClickHouse Merge Sort Algorithm work?

Shiv Iyer
Introduction ClickHouse uses a merge-sort algorithm to sort data internally. The merge-sort algorithm works by dividing the data into smaller blocks, sorting each block individually, and then merging the sorted blocks together to produce the […]