ClickHouse Blog

RSS: https://clickhouse.com/rss.xml

ClickHouse 官方博客，开源高性能列式数据库，支持实时 SQL 分析查询。

ClickHouse开源PostgreSQL监控扩展：每秒百万级查询事件直灌ClickHouse

ClickHouse开源了pg_stat_ch，一个PostgreSQL扩展，把每个查询执行转为固定大小约4.6KB的事件流式写入ClickHouse，支持PG 16-18。pgbench 32客户端测试中，36,656 TPS下捕获770万事件零丢失，CPU开销约2%，TPS下降约11%（主要来自锁竞争）。ClickHouse侧压缩比约83:1，10K QPS工作负载月存储成本约100美元。设计选择包括：固定大小事件而非可变长度、ring buffer无背压（丢数据不阻塞PG）、try-lock+进程内缓冲将锁获取从15万/秒降至3万/秒。

点赞

收藏1 天前

Announcing support for ClickStack in the ClickHouse Terraform provider

The ClickHouse Terraform provider now manages ClickStack dashboards, alerts, sources, and webhooks, putting observability config in version control.

点赞

收藏2 天前

What’s new in the ClickHouse Grafana plugin

ClickHouse Grafana plugin 4.20 brings compact query mode, click-to-filter log investigation, guided variable and annotation editors, and OpenTelemetry dashboards

点赞

收藏3 天前

ClickStack and Hud bring runtime intelligence to AI-powered development

ClickStack and Hud now share trace IDs, pairing service-level observability with function-level runtime forensics so coding agents can assess risky changes before they ship, catch regressions right af...

点赞

收藏3 天前

How iFood built its agentic security platform on ClickHouse Cloud

iFood rebuilt its in-house security platform on ClickHouse Cloud, getting 9-16x faster queries at 40-50% of the cost and unlocking agentic threat hunts that cut a week of analyst work down to two hour...

点赞

收藏4 天前

pg_clickhouse v0.10：子查询下推与千倍TPC-H性能提升

pg_clickhouse v0.10将TPC-H查询下推覆盖率从12/22提升到16/22，Q17相关子查询从32.7秒降至37毫秒，性能提升三个数量级。核心突破是把相关子查询整体下推为ClickHouse的SubPlan，同时解决了PostgreSQL三值逻辑与ClickHouse二值逻辑在NULL处理上的差异问题——通过追踪表达式结果的使用方式来注入正确的NULL守卫。二进制驱动改用新C客户端库，支持流式读取和按连接隔离并发扫描，修复了并发崩溃问题。

点赞

收藏4 天前

What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates

Discover what's new in pg_clickhouse v0.10.0: 16 of 22 TPC-H queries now push down in full, plus a rebuilt C driver and broader aggregate support.

点赞

收藏5 天前

bitdrift brings ClickHouse-powered mobile observability to ClickStack

bitdrift joins ClickHouse’s House Mates program with a mobile observability integration, bringing mobile-native telemetry, tracing, and debugging to ClickStack.

点赞

收藏5 天前

Whats new in ClickStack - June + July

Explore ClickStack’s latest upgrades, from richer trace navigation and Prometheus connectivity to smarter dashboards, quieter alerts, faster filtering and support for exponential histogram metrics.

点赞

收藏6 天前

Postgres WAL 背压的工程实践

ClickHouse 的托管 Postgres 在 WAL 积压时自动限速写入，防止磁盘写满导致 PANIC 崩溃。通过 cgroup v2 I/O 控制器按积压段数分三级限流：100 段降 80%、500 段降 50%、1000 段降 20%。归档进程被排除在限流之外，确保排水路径始终全速运行。实测中积压峰值达 3433 段、53 GiB WAL，对象存储恢复后约 4 分钟清空积压，磁盘占用从未超过 33%。

点赞

收藏10 天前

CMU数据库教授Andy Pavlo加入ClickHouse，创立ClickHouse Labs研究团队

CMU数据库教授Andy Pavlo加入ClickHouse，领导新成立的ClickHouse Labs研究团队。他2016年就知道ClickHouse，当时以为太完美是骗局——因为它是C++写的且支持SIMD向量化执行，而当时主流开源分析型数据库还是JVM-based。研究团队将与工程团队紧密合作，加速优化落地，并探索数据库如何支持AI agent以及agent如何改进数据库开发。

点赞

收藏12 天前

我搭建了一个支持110种数据库的在线互动实验平台

ClickHouse团队搭建了一个支持110种数据库的在线互动平台，用户可直接在浏览器中运行查询和对比性能。每个数据库预加载1亿条记录，涵盖关系型和非关系型系统，包括BQN等小众引擎。平台基于ClickBench项目，通过Firecracker虚拟机实现隔离，单机承载百个系统。存储优化采用Btrfs压缩加reflinks，将100TB数据压缩到7.5TB磁盘。内存管理通过swap映射到主机page cache实现弹性扩展。网络隔离使用tap设备加iptables加代理，限制访问白名单域名。

点赞

收藏13 天前

What's new in clickhousectl v0.4.0

clickhousectl v0.4.0 adds horizontal autoscaling for Cloud services, ClickPipe schema discovery, finer control over ClickPipe ingestion, and opt-out anonymous usage telemetry.

点赞

收藏16 天前

Postgres on NVMe Benchmarks

We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.

点赞

收藏16 天前

Instrumenting my espresso machine with OpenTelemetry

Treating a Gaggia espresso machine like a distributed system: instrumenting an ESP32 with OpenTelemetry, streaming shots and whole-house sensors into ClickHouse Cloud, and putting ClickStack (plus an ...

点赞

收藏17 天前

What matters for performance: lessons from a year of benchmarks

点赞

收藏18 天前

Why strict memory overcommit matters for Postgres

Why ClickHouse Managed Postgres runs strict memory overcommit by default, and how it turns an instance-wide OOM restart into a single failed query — shown side by side on identical hardware, with no m...

点赞

收藏18 天前

ClickHouse docs relaunch

We have relaunched on Mintlify, with a redesigned search and Ask AI experience, a docs MCP server, simpler navigation, an interactive API playground, and expanded localization — built for both human r...

点赞

收藏20 天前

Benchmarking the ClickStack MCP Server with hdx-evals

A behind-the-scenes look at hdx-evals, the open-source framework we built to benchmark the ClickStack MCP server against a raw SQL baseline using deterministic synthetic incidents, sandboxed Claude ag...

点赞

收藏25 天前

Measuring the Impact of High Availability on Managed Postgres Performance

点赞

收藏25 天前

ClickHouse announced as Principal Partner and Front of Shirt Sponsor of Fulham Football Club

Fulham Football Club is proud to announce ClickHouse, a global technology company specialising in real-time analytics, data infrastructure and AI applications, as its newest Principal Partner and Fron...

点赞

收藏26 天前

Migrate Datadog telemetry with the OpenTelemetry Collector

Recent improvements to the OpenTelemetry Collector's Datadog receiver let teams reroute telemetry from their existing Datadog agents and SDKs to ClickStack. or any OTel destination making migrations a...

点赞

收藏26 天前