Author | Lightnews

ClickHouse @clickhouse.com · 8h

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

1

ClickHouse @clickhouse.com · 17d

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 👇

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.

clickhou.se

1 5

ClickHouse @clickhouse.com · 21d

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

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.

clickhou.se

1 3

ClickHouse @clickhouse.com · Sep 30

🚀 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

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!

clickhou.se

ClickHouse @clickhouse.com · Sep 30

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 👇

clickhou.se

ClickHouse @clickhouse.com · Sep 22

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

Full story:

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…

clickhou.se

1 2

ClickHouse @clickhouse.com · Sep 19

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!

1

ClickHouse @clickhouse.com · Sep 19

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.

1 1

ClickHouse @clickhouse.com · Sep 18

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?

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

clickhou.se

1 3

ClickHouse @clickhouse.com · Sep 18

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.

ClickHouse @clickhouse.com · Sep 17

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

SREday - London, UK - September 18-19, 2025

Conference on Site Reliability Engineering, Cloud and DevOps. Probably the most awesome SRE conference in London, UK!

sreday.com

4

ClickHouse @clickhouse.com · Sep 17

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.

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…

clickhou.se

3

ClickHouse @clickhouse.com · Sep 16

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

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.

clickhou.se

2 2

ClickHouse @clickhouse.com · Sep 12

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! 👀

1

ClickHouse @clickhouse.com · Sep 9

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

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.

clickhou.se

ClickHouse @clickhouse.com · Sep 1

You can also do:

./clickhouse

(with no args)

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

1 2

Reposted by ClickHouse

𝙳𝚘𝚝𝚊𝚗 𝙷𝚘𝚛𝚘𝚟𝚒𝚝𝚜 #CNCFAmbassador #OpenSearchAmbassador @horovits.bsky.social · Sep 1

📢 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...

1 3 3

Reposted by ClickHouse

OpenObservability Talks 🎙️ @openobservability.bsky.social · Aug 31

📢 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

4 2

ClickHouse @clickhouse.com · Aug 27

What happens when you combine Slack, MCP, ClickHouse and data viz? Chat-native agentic BI.

We upgraded our Slack agent demo with the ability to generate charts directly inside a Slack thread.

Agentic BI in Slack: MCP-powered analytics and visualisations

Traditional BI assumes a dashboard is the destination. Most often, the destination is a conversation. We’re not replacing BI; we’re right‑sizing it. Dashboards remain for curated KPIs. Chat picks up…

clickhou.se

ClickHouse @clickhouse.com · Aug 26

Git-native ✓
Local-first ✓
Schemas as code ✓
Open source ✓
AI copilot ready ✓
Transparent migrations ✓

Modern DX for data infrastructure →

The 8 principles of great DX for data & analytics infrastructure

Learn the 8 design principals behind MooseStack - an open source developer toolkit for building TypeScript or Python apps on ClickHouse and open-source data infrastructure.

clickhou.se

1

ClickHouse @clickhouse.com · Aug 25

We're taking Open House on the road 🚗 Join us for free, half-day events in Sydney, NYC, Bangalore and Amsterdam this October. Register at:

Sydney 👉 clickhouse.com/openhouse/sy...
NYC 👉 clickhouse.com/openhouse/nyc
Bangalore 👉 clickhouse.com/openhouse/ba...
Amsterdam 👉 clickhouse.com/openhouse/am...

Open House 2025, The ClickHouse User Conference - Sydney, Australia.

clickhouse.com

ClickHouse @clickhouse.com · Aug 21

ClickHouse vs Postgres UPDATEs. Now its 🔥HOT🔥

Last week we compared raw engine performance with cold results. Now we’ve warmed up those caches to see more real-world hot results.

⚡ Single-row hot: Postgres leads by 2-3ms

🚀 Bulk hot: ClickHouse is up to 700x faster

👉

You can’t UPDATE what you can’t find: ClickHouse vs PostgreSQL

See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.

clickhou.se

1

ClickHouse @clickhouse.com · Aug 19

How do you stream changes from Delta Lake into ClickHouse?

1️⃣ We share what we learned using Delta Lake CDF
2️⃣ We open sourced a Python reference CDC implementation
3️⃣ Performance, schema design, and caveats

Consuming the Delta Lake Change Data Feed for CDC

In this post, we share everything we have learnt from our investigation into working with Delta Lake’s Change Data Feed (CDF). On top, we’re open sourcing an MIT-licensed, reference implementation of…

clickhou.se

ClickHouse @clickhouse.com · Aug 18

Get ready for House Party: The SQL 🕺 🪩

The Chainsmokers are back for round two on Dec 2 in Vegas. This is where database engineers become dance floor legends!

Sign up to save the date and get notified the moment registration opens.

clickhouse.com/company/even...

2

ClickHouse @clickhouse.com · Aug 15

An ORM for ClickHouse? Let's look at the open-source, MIT-licensed project Moose OLAP from fiveonefour. Inspired by the likes of SQLAlchemy, Drizzle and Prisma, it adapts the ORM experience to work on analytical databases like ClickHouse.

clickhou.se/3JkY30l

clickhou.se

1 2