ClickHouse
ClickHouse Primary Index Design: Parts, Partitions and Granules
A practitioner’s deep dive into MergeTree internals — parts, partitions, granules, and primary index design — from the ChistaDATA engineering team.
ClickHouse
Analytics
Vector ClickHouse Pipeline: Observability Worth the Effort
Vector ClickHouse pipeline: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
Mining the ClickHouse Query Log for Performance Insights
ClickHouse query log: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
ClickHouse Disk and Memory Alerting: Signals That Catch Outages Early
ClickHouse disk and memory alerting: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
ClickHouse Telemetry Retention: TTL Policies That Control Cost
ClickHouse telemetry retention: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
ClickHouse Capacity Planning for Observability Workloads
ClickHouse capacity planning: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
Real-Time Analytics
ClickHouse Kafka Real-Time Analytics: Architecting Streaming at Scale
Architect production-grade real-time streaming analytics with ClickHouse and Apache Kafka using the Kafka table engine, Materialized Views, and ReplicatedMergeTree.
Observability
ClickStack & HyperDX: Full-Stack ClickHouse Observability
Deploy ClickStack and HyperDX — the open-source full-stack observability platform built natively on ClickHouse for logs, metrics, traces, and session replay.
Observability
ClickHouse for Prometheus Long-Term Metrics Storage
Solve the Prometheus retention problem with ClickHouse — remote_write, the native TimeSeries engine, downsampling Materialized Views, and tiered S3 storage.
ClickHouse
Materialized Views in ClickHouse
Materialized Views in ClickHouse for High-Performance Analytics Materialized views are the secret behind interactive dashboards that feel instant on billion-row tables. In this guide, ChistaDATA engineers detail both incremental and refreshable materialized view patterns in […]