Explore ClickHouse Insights on ChistaDATA's Blog

Enhancing ClickHouse Query Efficiency: The Power of Materialized Columns in Practice

Introduction Incorporating materialized columns into ClickHouse for managing complex filtering conditions represents a strategic optimization that significantly boosts database performance. This technique revolves around pre-calculating and storing the results of expressions directly within the table, […]

Long integer query optimization in ClickHouse

Optimizing Long Integer Queries in ClickHouse: Strategies for High-Speed Data Analysis

Shiv Iyer

Introduction – Long Integer Queries Navigating the terrain of querying long integer data (64-bit integers) in ClickHouse is a journey of optimising performance through strategic choices in data types, leveraging indexing, and fine-tuning query operations. […]

RocksDB + ClickHouse for High-Velocity Workloads

Enhancing Data Ingestion: Integrating RocksDB with ClickHouse for High-Velocity Workloads

Shiv Iyer

Introduction: RocksDB ClickHouse Integration Integrating RocksDB with ClickHouse for high-velocity, high-volume data ingestion leverages the strengths of both systems to address specific challenges. RocksDB, a high-performance, embedded key-value store optimized for fast storage on flash […]

Optimizing Performance: Inside ClickHouse’s Thread Pool Management

Shiv Iyer

Introduction ClickHouse manages its thread pool operations with a keen focus on maximizing performance and efficiently handling concurrent queries and tasks. The internal handling of thread pools in ClickHouse is designed to optimize the usage […]

Migrating From Google BigQuery to ChistaDATA Cloud for ClickHouse: Part 1

ChistaDATA Inc.

Introduction BigQuery is Google‘s fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. – Wikipedia Google BigQuery has been around for over a decade and offers serverless / fully managed solutions for data warehouse/ analytical […]

ClickHouse Winter 2024 Release – v24.2

ChistaDATA Inc.

Introduction Each new release includes new features, improvements, and numerous bug fixes, and the ChistaDATA team is always on top of the latest releases. On 29th February 2024, ClickHouse version 24.2 (February 2024) was released, […]

Workload Scheduling In ClickHouse

ChistaDATA Inc.

Introduction Workload scheduling is a sophisticated method to efficiently manage resources among various tasks in ClickHouse. This technique is crucial for balancing different workloads, such as production and development tasks, ensuring optimal resource allocation and […]

ChistaDATA Inc.

Enterprise-class 24*7 ClickHouse Consultative Support and Managed Services

Blog

Enhancing ClickHouse Query Efficiency: The Power of Materialized Columns in Practice

Optimizing Long Integer Queries in ClickHouse: Strategies for High-Speed Data Analysis

Enhancing Data Ingestion: Integrating RocksDB with ClickHouse for High-Velocity Workloads

Optimizing Performance: Inside ClickHouse’s Thread Pool Management

Migrating From Google BigQuery to ChistaDATA Cloud for ClickHouse: Part 1

ClickHouse Winter 2024 Release – v24.2

Workload Scheduling In ClickHouse

The Five Principles of Customer-Aligned Pricing in OLAP Database Systems

ClickHouse January 2024 Release – v24.1

Why is Snowflake so Expensive?