Uncategorized Archives | Page 2 of 2

Tuning ClickHouse for High-Velocity Data Ingestion in Distributed Tables

Implementing Tiered Storage in ClickHouse: Leveraging S3 for Efficient Data Archival and Compliance

ClickHouse S3 Archival is a common strategy for handling large volumes of data efficiently, particularly for compliance purposes where data must be retained but is queried infrequently. Using tiered storage like S3 for archiving data […]

Hadoop and Teradata vs ClickHouse for Real-time Analytics in Modern Banking

Shiv Iyer

Introduction The migration from traditional Online Analytical Processing (OLAP) systems to real-time analytics on ClickHouse is driven by the growing need for faster and more cost-effective data processing in the modern banking industry. As customer […]

Why do you need great investor teams when you are serious about building a large corporation?

Shiv Iyer

I very rarely write blogs outside Tech., This blog is my experience with Sequoia Capital (investor in both MinervaDB and ChistaDATA); during the worst scenario, any business owner/Founder/CEO can be in. Yes, We have massive […]

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 […]

Monitoring ClickHouse Server CPU Usage

Shiv Iyer

Introduction ClickHouse is designed to be highly optimized for performance and scalability, with a focus on efficient use of system resources, including CPU usage. Understanding the CPU usage by a ClickHouse server can be important […]

Implementing Data Compression in ClickHouse with COMPRESS Function

How to implement Data Compression in ClickHouse with COMPRESS Function

ChistaDATA Inc.

Introduction ClickHouse is an open-source column-oriented database management system developed by Yandex. One of the critical features of ClickHouse is its ability to compress data in order to save storage space and increase query performance. […]

Runbook to Identify & Monitor Corrupted Indexes

Troubleshooting Corrupted Indexes in ClickHouse

Shiv Iyer

Introduction To troubleshoot index corruption in ClickHouse, you can follow these steps: Check the error logs: Look for any error messages related to index corruption in the ClickHouse logs. This can give you a clue […]

* Everything changes over time – Our blogs/posts and comments changes over time, That’s how it should be! Whatever we comment from ChistaDATA Inc. Teams (including Shiv Iyer) and other stakeholders or guest bloggers posted here are never permanent, These things worked for us. But, there is no guarantee they will work for you too, When using the recommendations from ChistaDATA or MinervaDB or MinervaSQL or any other online resources / Google, You must test the advice before applying them to your production systems, and always invest for a robust Database DR solution, Thank you for understanding.

Licensed under the Apache License, Version 2.0 (the “License”); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an “AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

PostgreSQL is a registered trademark of the PostgreSQL Community Association. ClickHouse is a registered trademark of ClickHouse, Inc. MongoDB is a registered trademark of MongoDB, Inc. Couchbase is a registered trademark of Couchbase, Inc. Redis is a registered trademark of Redis Ltd. Apache Cassandra is a registered trademark of the Apache Software Foundation. Milvus is a registered trademark of Zilliz. MinIO is a registered trademark of MinIO, Inc. Amazon Redshift and Amazon Aurora are registered trademarks of [Amazon.com](http://amazon.com/), Inc. Google Cloud is a registered trademark of Google LLC. Snowflake is a registered trademark of Snowflake Inc. Databricks is a registered trademark of Databricks, Inc. MySQL and InnoDB are registered trademarks of Oracle Corporation. MariaDB is a trademark of MariaDB Corporation Ab. All other trademarks are the property of their respective owners. Any other product or company names mentioned may be trademarks or trade names of their respective owners. Copyright © 2010–2026. All Rights Reserved by ChistaDATA®.

→ Index