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
Download: http://clickhouse.com
GitHub: http://clickhou.se/GitHub
Slack: http://clickhouse.com/slack
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
While we love seeing ClickHouse top the charts, benchmarks always leave us with one thought: could we be even faster?
clickhou.se/4oEQktn
October 30, 2025 at 4:02 PM
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
While we love seeing ClickHouse top the charts, benchmarks always leave us with one thought: could we be even faster?
clickhou.se/4oEQktn
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 👇
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
October 13, 2025 at 4:42 PM
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 👇
Pavel explains how the new JSON type serialisation formats work 👇
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
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
October 9, 2025 at 4:01 PM
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
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
🚀 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
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
September 30, 2025 at 5:41 PM
🚀 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
clickhou.se/4gOrZ1H
This release brings:
• Import/export dashboards
• Custom OTel Collector config
• Custom aggregations (full CH power 💪)
• Time-window chunking + delta() functions
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 👇
Read how switching from Elasticsearch to ClickHouse cut costs by two-thirds and shrunk latency from minutes to seconds 👇
clickhou.se
September 30, 2025 at 4:06 PM
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 👇
Read how switching from Elasticsearch to ClickHouse cut costs by two-thirds and shrunk latency from minutes to seconds 👇
How do you unify trillions of data points, reduce costs 40%, and eliminate downtime? Ask Changan Ford.
Full story:
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
September 22, 2025 at 4:01 PM
How do you unify trillions of data points, reduce costs 40%, and eliminate downtime? Ask Changan Ford.
Full story:
Full story:
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!
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!
September 19, 2025 at 4:01 PM
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!
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!
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.
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.
September 19, 2025 at 8:01 AM
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.
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.
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?
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
September 18, 2025 at 4:05 PM
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?
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?
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.
Store everything, aggregate nothing.
Hear about our journey to 100 PB and 500 trillion rows.
September 18, 2025 at 8:02 AM
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.
Store everything, aggregate nothing.
Hear about our journey to 100 PB and 500 trillion rows.
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
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
September 17, 2025 at 6:14 PM
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
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
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.
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
September 17, 2025 at 5:04 PM
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.
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.
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
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
September 16, 2025 at 4:00 PM
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
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
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! 👀
If you're in SF, you can spot our billboards around the city and on the 101! 👀
September 12, 2025 at 2:21 PM
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! 👀
If you're in SF, you can spot our billboards around the city and on the 101! 👀
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
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
September 9, 2025 at 4:01 PM
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
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
Reposted by ClickHouse
📢 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...
#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...
September 1, 2025 at 8:00 AM
📢 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...
#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...
Reposted by ClickHouse
📢 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
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
August 31, 2025 at 12:11 PM
📢 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
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
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.
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
August 27, 2025 at 8:36 PM
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.
We upgraded our Slack agent demo with the ability to generate charts directly inside a Slack thread.
Git-native ✓
Local-first ✓
Schemas as code ✓
Open source ✓
AI copilot ready ✓
Transparent migrations ✓
Modern DX for data infrastructure →
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
August 26, 2025 at 4:09 PM
Git-native ✓
Local-first ✓
Schemas as code ✓
Open source ✓
AI copilot ready ✓
Transparent migrations ✓
Modern DX for data infrastructure →
Local-first ✓
Schemas as code ✓
Open source ✓
AI copilot ready ✓
Transparent migrations ✓
Modern DX for data infrastructure →
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...
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
August 25, 2025 at 4:14 PM
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...
Sydney 👉 clickhouse.com/openhouse/sy...
NYC 👉 clickhouse.com/openhouse/nyc
Bangalore 👉 clickhouse.com/openhouse/ba...
Amsterdam 👉 clickhouse.com/openhouse/am...
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
👉
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
August 21, 2025 at 9:00 PM
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
👉
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
👉
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
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
August 19, 2025 at 4:01 PM
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
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
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...
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...
August 18, 2025 at 4:06 PM
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...
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...
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/3JkY30l
clickhou.se
August 15, 2025 at 4:04 PM
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/3JkY30l
Curiosity got the better of us: how do ClickHouse’s new UPDATEs compare to Postgres?
clickhou.se/3Hx2XXx
⚡ Single-row updates: parity
🚀 Bulk updates: up to 4,000× faster
clickhou.se/3Hx2XXx
⚡ Single-row updates: parity
🚀 Bulk updates: up to 4,000× 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
August 13, 2025 at 5:23 PM
Curiosity got the better of us: how do ClickHouse’s new UPDATEs compare to Postgres?
clickhou.se/3Hx2XXx
⚡ Single-row updates: parity
🚀 Bulk updates: up to 4,000× faster
clickhou.se/3Hx2XXx
⚡ Single-row updates: parity
🚀 Bulk updates: up to 4,000× faster