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.

Troubleshooting Inadequate System Resources error in ClickHouse

Introduction Troubleshooting “Inadequate System Resources” errors in ClickHouse often involves dealing with settings like max_memory_usage and max_bytes_before_external_group_by. These settings are crucial for managing memory usage, especially in environments where resources are limited or when handling […]

ClickHouse v/s PostgreSQL & MySQL for Real-time Analytics

“ClickHouse, with its columnar storage approach, is inherently suited for high-velocity data ingestion and real-time analytics, offering superior performance, scalability, and cost-effectiveness, making it a strategic choice for organizations seeking real-time insights and decision-making.” Introduction […]

ClickHouse Query Profiling for Performance Monitoring

Introduction Creating a Python CLI (Command-Line Interface) application for custom profiling of ClickHouse Server queries involves several components. The application will allow users to input queries via the command line, execute them on a ClickHouse […]

1 2 3 22