Run affordable open source ClickHouse® anywhere with #AltinityCloud, Expert Support, BYOC, & real-time data lake integration to scale queries on cheap storage.
Berkeley, CA
- Tweets 2,446
- Following 366
- Followers 1,731
- Likes 1,006
🌮 Tomorrow evening: tacos + #observability, MCPs, #AI, OTel, & ClickHouse® at Grafana & Friends.
We’ll join talks & conversations around some current engineering problems: safer AI data access, MCP + k6, OTel on #K8s, & stateless #ClickHouse® ingestion.
hubs.la/Q04yqYrW0
42
📣 Raw EXPLAIN text can be a lot to parse.
The #AltinitySQLBrowser turns #ClickHouse® EXPLAIN PIPELINE output into an interactive processor graph, so parallelism and Resize points are easier to spot. Pan, zoom, or open it fullscreen.
💡 Full docs: hubs.la/Q04ypVrf0
1
100
Slow #ClickHouse® query? Start with the built-in tools. 💪🏽
▪ query_log: resources + runtime
▪ processors_profile_log: time per stage
▪ query_metric_log: live stats
▪ EXPLAIN + the chdig CLI
💡 Get the full breakdown: hubs.la/Q04xYzy60
1
106
Scaling #ClickHouse® storage without scaling compute? Meet CAS. 💥
Content-Addressed Storage (#CAS) adds shared object storage to existing MergeTree model, so storage can scale independently without replacing #MergeTree with a new engine.
CAS explained: hubs.la/Q04y7dTR0
2
136
Altinity retweeted
We're excited to have Joshua Lee, Developer Advocate for @AltinityDB, presenting "Observability is Broken and Open-Source (will be) the Solution" at #AllThingsOpen! 2026.allthingsopen.org/sessi…
1
1
281
0.65s vs. 1.42s on ~126M rows. Same #ClickHouse® table, same filter. The only change was the query’s ORDER BY. ⚡
If a query is sorting more than expected, check whether its ORDER BY matches the table’s: kb.altinity.com/engines/merg…
1
2
133
🇵🇱 Warsaw - thank you for making it an evening to remember.
Huge thanks to #OSACommunity for bringing everyone together, @dbcicero & other speakers for sharing the stage, & Josh Lee for hosting. Shoutout to everyone from the open source community who made the meetup so special.
2
92
Disk, memory, CPU, network. When #ClickHouse® has a problem, which one do you check first? 🤔
Our Sept. admin #training gets into ClickHouse internals so you can diagnose issues instead of guessing.
4 live sessions starting tomorrow (limited seats left): hubs.la/Q04x0mqb0
4
111
Warsaw, we’re on tomorrow! 🇵🇱🕺🏻
We're joining #OSACommunity for an evening on building #AI w/ live data, low latency, & real-world scale.
Expect streaming, RAG, #observability, databases, open-source infra discussion.
📍 Workin, Senatorska 2
🕕 6 PM
🔜 hubs.ly/Q04w_Zlv0
2
73
More partitions ≠ faster #ClickHouse®. 👎🏻
Too-granular partitioning means more parts, more files, more background work, & potentially more remote-storage requests.
Use PARTITION BY for the job it’s meant to do, not as a generic faster-SELECT switch.
👉🏻 hubs.la/Q04vVpxz0
1
3
121
“Have you guys called Altinity yet?” - Avi Press, CEO of @scarf_oss
As the data grew 200–300x, Scarf needed to bring #ClickHouse® costs under control. With Altinity’s help, they moved to #BYOC, optimized the schema & queries, & brought #TCO down by 60%.
hubs.la/Q04wQWnq0
3
188
Your slowest #ClickHouse® query may be the wrong one to optimize first.
A fast query running thousands of times can drive more total load than one obvious slow query. system.query_log + normalized_query_hash can help surface the patterns actually worth your optimization time. 👇🏻
5
162
#BYOC sounds great until the obvious question comes up: are you getting more control, or just taking on more ops? 🤔
Tomorrow in SF, we dig into that with #ClickHouse® as the example: where ops end, customer control begins, and when BYOC works well.
🎟️ hubs.la/Q04tQwt70
1
2
143
One unrelated read could flush everyone else’s write batch in #ClickHouse® Keeper. 💡
26.6 reworked batching/pipelining & fixed NuRaft follower appends. Keeper is now ~2x faster overall.
Still on #ZooKeeper because of old benchmarks? Retest 26.6: hubs.la/Q04tYwnj0
1
2
131
SaaS is convenient until workloads get expensive, data needs to stay put, or security wants tighter control. 😵💫
SF #meetup on 9/2: Altinity, @last9io, @nirvanalabsai, @tensor9ine discuss #BYOC, IOPS costs, and running software in customer clouds.
🎟️ hubs.la/Q04tQd8q0
2
5
208
Well, we’re a little bit biased here but we really like capacity based pricing for ClickHouse®. Even better when you can run it anywhere. 👀
1
1
169
Replication queue stuck in #ClickHouse®? ♻️
Before you hit “delete GET_PARTS,” check why the queue is stuck first. Task type matters, and the fix may be much simpler.
💪🏻 Full troubleshooting instructions: kb.altinity.com/altinity-kb-…
3
126
💰 Your #ClickHouse® bill is climbing. Where do you look first?
This month’s #OfficeHours focuses on cost optimization: how to find expensive queries and decide what to optimize first.
Bring cost questions. We'll answer them live.
📆 Aug 20, 8am PT
🔗 hubs.la/Q04szjqw0
1
4
237
🎉 So excited to introduce the Altinity SQL Browser—a rich #SQL console for ClickHouse® with charts, EXPLAIN pipeline graphs, autocomplete, & a saved-query library.
Deployed as a single HTML file.
🚀 Take it for a spin: hubs.la/Q04rjhMc0
📝 Docs: hubs.la/Q04rjhYd0
4
145
📣 We're partnering with @last9io because #observability costs shouldn't grow faster than the systems they monitor.
Last9 runs unified telemetry on #ClickHouse® and the full stack lives in your environment while we handle ClickHouse ops 24/7.
Learn more: hubs.la/Q04r8FyY0
2
4
216