ClickHouse's Avatar

ClickHouse

@clickhouse.com

ClickHouse is the fastest open-source OLAP database ⚡ Download: http://clickhouse.com GitHub: http://clickhou.se/GitHub Slack: http://clickhouse.com/slack

792
Followers
18
Following
156
Posts
12.11.2024
Joined
Posts Following

Latest posts by ClickHouse @clickhouse.com

Preview
ClickHouse Bangalore Meetup, Sat, Mar 14, 2026, 10:30 AM | Meetup Join us in Bangalore for yet another exciting meetup. This event brings together engineers, architects, and data leaders to explore how modern teams are building scalable,

Bangalore, we’re back! 🚀

Join us for another exciting ClickHouse Bangalore User Group meetup as we dive into building scalable, real-time analytics in the cloud.

📍 Awfis Mantri Commerce, Bannerghatta Road
🗓️ 14th March 2026, 10:30 AM onwards

Spots are limited —

09.03.2026 08:12 👍 0 🔁 0 💬 0 📌 0

The Agentic Data Stack is an open-source, composable architecture for agentic analytics. Runs on a laptop, scales to thousands of agents.

Three layers, all open source:

03.03.2026 17:00 👍 1 🔁 0 💬 0 📌 0
Preview
Getting started with ClickHouse? 13 mistakes and how to avoid them In this post, we highlight the most common 13 mistakes we see our new users encounter, why they occur and the correct approach.

Every database has its own mental model, and ClickHouse is no different. We wrote up 13 common mistakes we see when teams are getting started, and how to avoid them.

27.02.2026 15:16 👍 4 🔁 1 💬 1 📌 0
Preview
Cursor - ClickHouse Plugin Built to make you extraordinarily productive, Cursor is the best way to code with AI.

ClickHouse now has an official plugin on the Cursor Marketplace 🎉

The plugin packages the ClickHouse Agent Skills with 28 best-practice rules, and the ClickHouse MCP server for querying your database directly from the editor.

clickhou.se/4sbByfJ

24.02.2026 11:47 👍 2 🔁 0 💬 0 📌 0
Preview
How to set up ClickHouse for agentic analytics Agentic analytics has changed the warehouse contract. Stakeholders are skipping dashboards and asking chatbots directly: “What was net revenue in EMEA last quarter?”

Agentic analytics has changed the warehouse contract.

Amy Chen walks through how to set up ClickHouse Cloud for AI agents.

clickhou.se/4kTxCxI

24.02.2026 00:04 👍 1 🔁 0 💬 0 📌 0
Preview
Building an enterprise Postgres service in ClickHouse Cloud We’ve been investing heavily in state-of-the-art features to ensure customers get an enterprise-grade Postgres experience.

Our top priority building Postgres managed by ClickHouse is delivering an always-available, reliable, and operationally observable managed Postgres offering.

Here's what we've shipped so far:

20.02.2026 16:15 👍 2 🔁 0 💬 0 📌 0
Preview
Making large Postgres migrations practical: 1TB in 2 hours with PeerDB PeerDB's Postgres to Postgres migration features enable teams to migrate their existing Postgres databases quickly and with minimal downtime.

We benchmarked three ways to migrate a 1TB table from Postgres to Postgres.

Postgres managed by ClickHouse launched in January, and the most common question is: how can I migrate my large, existing Postgres without downtime?

19.02.2026 16:01 👍 4 🔁 0 💬 1 📌 0
Preview
pg_clickhouse is the fastest Postgres extension on ClickBench The pg_clickhouse extension minimizes the effort required to run typical analytics queries in Postgres by delegating execution to ClickHouse.

pg_clickhouse is the fastest PostgreSQL extension on ClickBench.

We built pg_clickhouse to let you query ClickHouse directly from Postgres. Rather than shoehorn analytics into Postgres, pg_clickhouse pushes down full query execution to ClickHouse.

clickhou.se/4qM2v8u

18.02.2026 16:54 👍 4 🔁 1 💬 0 📌 0
Preview
AI-powered migrations from Postgres to ClickHouse AI can drastically accelerate migrating analytical workloads from Postgres to ClickHouse. To set your agents up for success, give them the right environment.

Postgres + ClickHouse is becoming the default architecture for applications that need both transactional and analytical workloads. With Postgres managed by ClickHouse, the two run side by side from day one. But migrating existing analytical workloads off Postgres isn't trivial.

clickhou.se/4alI7pT

17.02.2026 16:38 👍 4 🔁 0 💬 0 📌 0
Preview
pg_stat_ch: a PostgreSQL extension that exports every metric to ClickHouse We’re open sourcing pg_stat_ch: a PostgreSQL extension that turns every query execution into a fixed-size ~4.6KB event and streams them into ClickHouse.

We're open sourcing pg_stat_ch, a PostgreSQL extension that turns every query execution into a structured event and streams it to ClickHouse.

Kaushik Iska walks through how it works under the hood: clickhou.se/4rQ8VEG

🐘 It's Postgres Week at ClickHouse 🐘 Today through Feb 20th

13.02.2026 16:29 👍 5 🔁 0 💬 0 📌 0

Say hello to clickhouse.build - the open source, agentic CLI that helps you add ClickHouse to your existing Postgres-backed TypeScript application.

clickhou.se/4pgZSvB

02.12.2025 17:02 👍 2 🔁 0 💬 0 📌 0
Preview
From OTel to Rotel: Petabyte-scale tracing with 4x greater throughput Read how Streamfold’s Rotel pushes OpenTelemetry 4x faster into ClickHouse - benchmarking efficiency at scale and revealing the tools that make it happen

Can you 4x OTel thoughput with Rust? Meet Rotel: pushing 460K spans/sec/core (vs 130k)

How? By diving deep into Rust's threading model, resolving allocator lock contention, and reengineering JSON serialization with RowBinary encoding to stream data efficiently into ClickHouse.

25.11.2025 18:11 👍 8 🔁 0 💬 0 📌 2
Post image

Shout out to Todd Stoffel for this independent analytics benchmark 👏

While we love seeing ClickHouse top the charts, benchmarks always leave us with one thought: could we be even faster?

clickhou.se/4oEQktn

30.10.2025 16:02 👍 3 🔁 0 💬 0 📌 0
Preview
ClickHouse’s JSON data type gets even better The latest changes to the JSON data type in v25.8 make ClickHouse the leader in analytics over JSON data.

58x faster and 3,300x less memory 🤯 ClickHouse v25.8 makes analytics over complex JSON better than ever.

Pavel explains how the new JSON type serialisation formats work 👇

13.10.2025 16:42 👍 6 🔁 1 💬 0 📌 0
Preview
ClickHouse’s JSON data type gets even better The latest changes to the JSON data type in v25.8 make ClickHouse the leader in analytics over JSON data.

The ClickHouse JSON type was already fast, but v25.8 made it 58x faster and use 3,300x less memory.

The problem: JSON docs with 10,000+ unique paths killed performance.

The solution → clickhou.se/48iNcPb

200k rows, 10k paths:
⚡ 3.63s → 0.063s
💾 12.53 GiB → 3.89 MiB

09.10.2025 16:01 👍 3 🔁 1 💬 0 📌 0
Preview
What's new in ClickStack. September '25. Discover what’s new in ClickStack this month, including importing and exporting dashboards, custom aggregations, chunking time windows, and more!

🚀 What's New in ClickStack – Sept '25

clickhou.se/4gOrZ1H

This release brings:
• Import/export dashboards
• Custom OTel Collector config
• Custom aggregations (full CH power 💪)
• Time-window chunking + delta() functions

30.09.2025 17:41 👍 0 🔁 0 💬 0 📌 0

When ProcessOut needed a faster, leaner way to power billions of payment transactions, they turned to ClickHouse Cloud ⚡️

Read how switching from Elasticsearch to ClickHouse cut costs by two-thirds and shrunk latency from minutes to seconds 👇

30.09.2025 16:06 👍 0 🔁 0 💬 0 📌 0
Preview
How Changan Ford cut costs by 40% and powered precision marketing with ClickHouse Enterprise Edition Changan Ford migrated their Customer Data Platform to ClickHouse Enterprise Edition, cut costs by 40%, eased the operational workload, and gave the team stability and confidence even during their…

How do you unify trillions of data points, reduce costs 40%, and eliminate downtime? Ask Changan Ford.

Full story:

22.09.2025 16:01 👍 2 🔁 0 💬 1 📌 0

What do zombies, Bollywood, and romantasy have in common?

Nataly Merezhuk will show how JSON, vector, and full-text search in ClickHouse can be used to map relationships across unstructured data at scale and answer your most imaginative questions!

Don't miss this talk at PyConUK on Saturday!

19.09.2025 16:01 👍 1 🔁 0 💬 0 📌 0

Final day of SREDay! Dale McDiarmid takes the stage at 15:00 to introduce ClickStack.

Observability vendors built three separate engines because they didn't have a database that could handle logs, metrics, AND traces at scale.

We do. And we open sourced the whole stack.

19.09.2025 08:01 👍 1 🔁 1 💬 0 📌 0
Preview
Breaking free from rising observability costs with open cost-efficient architectures Discover how open, cost-efficient architectures can break the cycle of runaway observability costs and vendor lock-in

One crypto exchange's actual Datadog bill: $65M/year 🤯

The observability industry has built tools that are more expensive than the systems they monitor. It's like paying more for your car's dashboard than the engine.

How did this become normal?

18.09.2025 16:05 👍 4 🔁 0 💬 1 📌 0

Heading to SREDay today? Don't miss Rory Crispin at 15:00.

Store everything, aggregate nothing.

Hear about our journey to 100 PB and 500 trillion rows.

18.09.2025 08:00 👍 0 🔁 0 💬 0 📌 0
Preview
SREday - London, UK - September 18-19, 2025 Conference on Site Reliability Engineering, Cloud and DevOps. Probably the most awesome SRE conference in London, UK!

100 petabytes. 500 trillion rows. That's our observability platform at ClickHouse.

Thurs 18th 15:00: Rory Crispin on why "store everything, aggregate nothing" actually works

Fri 19th 15:00: Dale McDiarmid on ClickStack and treating o11y as a data problem, not a search problem

clickhou.se/48mvES6

17.09.2025 18:14 👍 5 🔁 0 💬 0 📌 0
Preview
Optimizing ClickHouse for Intel's ultra-high core count processors Intel's latest processor generations are pushing the number of cores in a server to unprecedented levels. For analytical databases like ClickHouse, ultra-high core counts represent a huge opportunity…

Can more cores make your database slower? Turns out, what flies at 32 cores can crawl at 480.

clickhou.se/48rGmGS

Intel performance engineers went deep on ClickHouse running on their newest processors - 240+ cores per socket, 480+ cores in multi-socket systems.

17.09.2025 17:04 👍 3 🔁 0 💬 0 📌 0
Preview
Build ClickHouse-powered APIs with React and MooseStack This is a practical guide of how to build a ClickHouse-powered API in your web app that will be familiar to anyone who’s worked with Postgres.

Built analytics on Postgres? You know what happens next: works great initially, then queries slow down as you scale.

clickhou.se/3IpjLQQ

Add ClickHouse speed without a rewrite:
- Keep Postgres as source of truth
- CDC to ClickHouse
- TypeScript APIs with MooseStack
- Auto-generated React clients

16.09.2025 16:00 👍 3 🔁 2 💬 0 📌 0
Post image

AI demands more than what traditional databases can deliver. Faster ingestion, sub-second queries, and cost efficiency at massive scale. It's no wonder the world's leading AI companies use ClickHouse.

If you're in SF, you can spot our billboards around the city and on the 101! 👀

12.09.2025 14:21 👍 2 🔁 0 💬 0 📌 0
Preview
TimescaleDB to ClickHouse replication: Use cases, features, and how we built it The Postgres CDC connector in ClickPipes now supports one-time migrations and continuous replication from TimescaleDB.

The ClickPipes Postgres connector now supports CDC from TimescaleDB 🎉

You can:
• Rapidly move existing state with parallel snapshotting
• Keep hypertables in sync with low-latency CDC
• Handle schema changes without breaking the pipeline
• Work with compressed tables

09.09.2025 16:01 👍 0 🔁 0 💬 0 📌 0

You can also do:

./clickhouse

(with no args)

And then you'll have a CLI + the database engine running all in process.

01.09.2025 11:36 👍 2 🔁 0 💬 1 📌 0
Post image

📢 ClickHouse’s New Observability Stack Unveiled 📢

#ClickHouse is doubling down on #observability with the release of #ClickStack

Check out my fireside chat with @mikeshi42.bsky.social, Head of observability
@clickhouse.com, co-founder @hyperdx.bsky.social :
👉 horovits.medium.com/clickstack-c...

01.09.2025 08:00 👍 3 🔁 3 💬 1 📌 0
Post image

📢 August episode is out! 📢
ClickStack: #ClickHouse’s New #Observability Stack Unveiled

@horovits.bsky.social hosted @mikeshi42.bsky.social, Head of observability @clickhouse.com

🎧 podcasters.spotify.com/pod/show/ope...
📺 www.youtube.com/watch?v=vdsE...

recap post:
medium.com/p/73f129a179a3

31.08.2025 12:11 👍 2 🔁 4 💬 0 📌 0