August 2026 newsletter

ClickHouse announced that Andy Pavlo, formerly a professor at Carnegie Mellon University, is joining the company to establish ClickHouse Labs, an applied research lab focused on improving ClickHouse and its managed PostgreSQL service. The August 2026 newsletter also highlights the 26.7 release, which includes performance improvements from community member Manuel Raimann, such as up to 7× faster wide-integer comparisons and 5× faster Delta decompression, and the Open House Roadshow visiting six cities including Amsterdam, Singapore, and London.

A new database research lab, an interactive playground for over 100 databases, and our biggest release post ever - it’s just your average month in the world of ClickHouse In this issue, meet Andy Pavlo, the newest member of the ClickHouse team, learn about what’s new in 26.7, and catch up on the latest in ClickHouse Managed Postgres, observability, vector search, and more. And don’t forget to register for the Open House Roadshow, which is visiting six cities over the next six weeks. Featured community member: Manuel Raimann This month's featured community member is Manuel Raimann, Head of Engineering at Redact.dev. Manuel contributed a series of performance improvements in the recent ClickHouse 26.7 release. His work sped up wide-integer comparisons by up to 7×, Delta decompression by up to 5×, and statistical and bitwise aggregates by up to 4×. He also made numeric array operations and primary-key index filtering faster. Apart from contributing to ClickHouse, he also contributes to the open-source Deadlock API https://github.com/deadlock-api , which provides game data and analytics for Deadlock, Valve’s upcoming game combining third-person shooting with MOBA-style gameplay. ➡️ Connect with Manuel on LinkedIn https://www.linkedin.com/in/manuel-raimann/ Open House Roadshow The Open House Roadshow https://clickhouse.com/company/events?category=Open+House continues, with visits to Amsterdam https://clickhouse.com/openhouse/amsterdam-2026 Sep 1 , Singapore https://clickhouse.com/openhouse/singapore-2026 Sep 24 , and London https://clickhouse.com/openhouse/london-2026 Sep 30 . Each stop will feature talks from both ClickHouse employees and customers, as well as optional training workshops. We’ll also be visiting New York City, Bangalore, and Munich. ➡️ See all Open House locations https://clickhouse.com/company/events?category=Open+House 26.7 release The 26.7 release blog post is our longest one yet. While there is certainly value in brevity, we’re going to let ourselves off this time because there were so many features that we needed to tell you about As always, we have join optimizations. The hash join algorithm has been made more efficient by reducing the probe-side input and shrinking build-side hash tables. ClickHouse will now also automatically choose how to arrange joins in a multi-table query. Text indexes now store token positions, a feature that’s needed for efficient phrase search. We tested it on a Hacker News dataset, and a query for the phrase "Google web search" was 40 times faster. The EXPLAIN clause has a new member: EXPLAIN ANALYZE , which runs every query-processing phase before discarding the result rows and annotating the logical execution-plan tree with measurements collected during actual execution. That’s just a brief taster - we’ll let you read the blog post to find out the rest Andy Pavlo joins ClickHouse to establish ClickHouse Labs The news of the month and maybe the year? is that Andy Pavlo is joining ClickHouse to establish ClickHouse Labs. Andy was previously a professor in the Computer Science Department at Carnegie Mellon University since 2013. ClickHouse Labs is an applied research lab that will conduct scientifically valuable research and then help transform the best ideas into technology that matters to users. In addition to developing ideas to improve ClickHouse, the lab will work with the ClickHouse PostgreSQL team to help establish its managed service as a market leader in performance and reliability. Your TTL is working. That might be the problem. Amrelboridy’s disk kept filling up, but there wasn’t any indication why. There weren’t any orphaned or detached parts, and data retention was healthy. In this blog post, Amrelboridy explains what happens in ClickHouse when a row’s Time To Live TTL expires and how configuring the partition key can save you a lot of headaches. Alexey created a playground for 110 database systems Alexey has extended ClickBench, a benchmark for analytical databases, to include an interactive playground https://benchmark.clickhouse.com/playground where you can run ad hoc queries on the 100m-record ClickBench dataset against over 100 database systems. The playground runs on Firecracker microVMs on an AWS EC2 instance, and in the blog post, Alexey explains why this was the only approach that provided strong isolation, reasonable cost, and fast startup. Postgres vs ClickHouse is the wrong question. I use both. Artem Senenko explains that “Postgres vs ClickHouse” is the wrong question because the databases solve different problems. He uses Postgres for mutable data, such as monitors, incidents, teams, and configuration. But the continuously growing stream of immutable check results goes into ClickHouse for efficient storage and fast analytical queries. The majority of the blog post focuses on ways to optimize ClickHouse, including compression codecs, tenant-aware sort keys, per-row retention periods, and materialized views that pre-aggregate data for dashboards. What's new in ClickHouse Managed Postgres: Customer notifications, better observability, faster backups, extensions, and more In the latest issue of What’s New in ClickHouse Managed Postgres, we introduce a smoother onboarding experience, proactive storage notifications, richer observability, and faster, more predictable backups for databases larger than 10 TB. We’ve also expanded the extension ecosystem: pg re2 makes regular-expression queries up to 9× faster, while improvements to pg clickhouse and pg stat ch enable more efficient analytics and query monitoring across Postgres and ClickHouse. How we build and evaluate our MCP server for SRE agents Brandon Pereira explains how the ClickStack team built hdx-evals, an open-source framework for measuring the reliability of AI agents' investigations into production incidents. Across five reproducible scenarios containing millions of synthetic logs and spans, the purpose-built ClickStack MCP server scored 7–20 percentage points higher than giving agents direct SQL access through the ClickHouse MCP server. Brandon also explores how tool schemas, response design, actionable errors, and query speed influence agent accuracy and consistency. Quick reads - Kaushik Iska explains how ClickHouse Managed Postgres uses tiered, WAL-aware write throttling https://clickhouse.com/blog/wal-backpressure-clickhouse-managed-postgres to slow clients before an archiving backlog fills the disk, giving the archiver time to recover before automatically restoring full throughput. - Arsad Tanzim builds a ClickHouse, OpenTelemetry, and Grafana prototype https://medium.com/@arsadtanzim/i-tried-replacing-my-logs-metrics-and-traces-stack-with-just-clickhouse-1dbbaa69d083 to unify logs, metrics, and traces in one SQL-queryable backend. - Mohamed Hussain S tests ClickHouse vector search https://medium.com/stackademic/can-clickhouse-replace-a-vector-database-i-actually-tested-it-9f0c54f2b036 and finds it can replace a dedicated vector database when embeddings sit alongside analytical data, while vector-only workloads with constant high-frequency writes favor a purpose-built system. - Jordan Simonovski turns a Gaggia espresso machine into an OpenTelemetry-instrumented system https://clickhouse.com/blog/espresso-machine-observability-with-otel , streaming ESP32 and household sensor data into ClickStack and using an LLM agent to turn each shot into actionable brewing advice. Get started today Interested in seeing how ClickHouse works on your data? Get started with ClickHouse Cloud in minutes and receive $300 in free credits. Sign up https://console.clickhouse.cloud/signUp?loc=blog-cta-1616-get-started-today-sign-up&utm blogctaid=1616 Upcoming events Global virtual events PostgreSQL and ClickHouse, Better Together https://clickhouse.com/company/events/202608-APJ-PostgreSQL-ClickHouse-Better-Together - Aug 25, 2026 Data Architecture Blueprints featuring Zappi https://clickhouse.com/company/events/202608-AMER-Webinar-Data-Architecture-Zappi - Aug 26, 2026 ClickHouse Managed Postgres 소개: pg clickhouse로 구현하는 실시간 분석 https://clickhouse.com/company/events/webinar-managed-postgres-korea-sept17 - Sep 17, 2026 Virtual training Query Optimization with ClickHouse Workshop https://clickhouse.com/company/events/202609-APJ-query-optimization-workshop - Sep 29, 2026 Real-time Analytics with ClickHouse: Level 1 https://clickhouse.com/company/events/202610-APJ-Real-time-Analytics-ClickHouse-Level1 - Oct 20, 2026 Real-time Analytics with ClickHouse: Level 2 https://clickhouse.com/company/events/202610-APJ-Real-time-Analytics-ClickHouse-Level2 - Oct 21, 2026 Real-time Analytics with ClickHouse: Level 3 https://clickhouse.com/company/events/202610-APJ-Real-time-Analytics-ClickHouse-Level3 - Oct 22, 2026 Events in AMER Fulham Football Club Premier League Watch Party https://www.premierleague.com/en/coast-to-coast - Atlanta - Aug 24, 2026 Vancouver Data Engineering Meetup https://clickhouse.com/company/events/vancouver202608 - Aug 25, 2026 Better Days: A Hackathon — San Francisco https://clickhouse.com/company/events/sfhackathon202608 - Aug 28, 2026 The Boston Data Party Trivia Night https://clickhouse.com/company/events/boston202608 - Aug 31, 2026 AWS Summit Sao Paulo https://aws.amazon.com/pt/events/summits/sao-paulo/ - Sep 3, 2026 DevOpsDays Santiago https://santiago.devopsdayschile.cl/ - Sep 8-9, 2026 Open House Roadshow New York https://clickhouse.com/openhouse/nyc-2026 - Sep 10 Hands-on training: Building agents with ClickHouse and LibreChat — Boston https://luma.com/clickh-nw1d - Sep 14 Astronomer Orchestrate Everything https://www.astronomer.io/events/orchestrate-everything - Sep 16, 2026 dbt Summit https://www.getdbt.com/dbt-summit - Las Vegas - Sep 15-18, 2026 All In Conference https://allinevent.ai/?gad source=1&gad campaignid=24065615896&gbraid=0AAAAAp4XQCYgxFpav8IvuXLwsDHGQpEiq&gclid=Cj0KCQjw4orUBhCjARIsAIbF3qzRbNKwlsUJ6yDn3TyEUeV8urkw3OP-QTs3Ck4QITsdJM9ru-JrEk0aAoweEALw wcB - Montreal - Sep 16-17, 2026 Rows and Columns summit San Francisco https://luma.com/clickh-wavw - Sep 22nd Google Cloud Summit Brasil https://cloudonair.withgoogle.com/events/google-cloud-summit-brasil-2026-1 - Sep 23-24, 2026 Runway by RunReveal https://runway.runreveal.com/ - San Francisco - Sep 29, 2026 CoreWeave Fully Connected https://coreweave.com/fully-connected-2026 - San Francisco - Sep 29 - Oct 2, 2026 Events in EMEA Amsterdam In-person training - From 0 to Production: Observing and Improving AI Agents with Langfuse https://clickhouse.com/company/events/202609-EMEA-Amsterdam-AI-Agents-w-Langfuse - Sep 1, 2026 Amsterdam In-person training - One Database, Every Workload: A ClickHouse Workshop https://clickhouse.com/company/events/202609-EMEA-Amsterdam-One-Database-Every-Workload - Sep 1, 2026 Open House Roadshow Amsterdam https://clickhouse.com/company/events/202609-amsterdam-open-house - Sep 1, 2026 The Agentic Data Stack, Berlin https://clickhouse.com/company/events/202609-EMEA-DACH-Germany-Berlin-The-Agentic-Data-Stack - Sep 2, 2026 AWS Summit Tel Aviv https://aws.amazon.com/events/summits/tel-aviv/ - Sept 10, 2026 Tech Race Warsaw https://techracesummit.com/ - Sept 10, 2026 The Agentic Data Stack https://clickhouse.com/company/events/202609-EMEA-UKI-Roundtable-AgenticLLMStack - London - Sep 11, 2026 ClickHouse Amsterdam Meetup @ Adyen https://clickhouse.com/company/events/ai-builders-and-databases-sep-amsterdam-2026 - Sep 15, 2026 AI Builders and Databases Happy Hour Cape Town https://clickhouse.com/company/events/ai-builders-and-databases-sep-cape-town-2026 - Sep 15, 2026- BigData Paris The Agentic Data Stack - Paris https://clickhouse.com/company/events/202609-EMEA-France-Paris-The-Agentic-Data-Stack - Sep 17, 2026 The Agentic Data Stack - Zurich https://clickhouse.com/company/events/202609-EMEA-DACH-Zurich-The-Agentic-Data-Stack - Sep 17, 2026- IDC Madrid - Sept 22, 2026 - AI Engineer Paris Langfuse - Sept 22-24, 2026 Stockholm In-Person Training: Real-time Analytics with ClickHouse https://clickhouse.com/company/events/202609-EMEA-Stockholm-Real-time-Analytics-w-ClickHouse - Sep 23, 2026 AI Builders and Databases Barcelona https://luma.com/p7td11mb - Sep 23, 2026- BigDataLondon - Sept 23-24, 2026 - FabCON - Sept 28 - Oct 1 AI Builders and Databases Paris https://clickhouse.com/company/events/ai-builders-and-databases-sep-paris-2026 - Sep 29, 2026 Agentic AI Forum Dubai https://www.agenticaiforum.net/ - Sept 30, 2026 London In-person training - From 0 to Production: Observing and Improving AI Agents with Langfuse https://clickhouse.com/company/events/202609-EMEA-London-AI-Agents-w-Langfuse - Sep 30, 2026 London In-person training - One Database, Every Workload: A ClickHouse Workshop https://clickhouse.com/company/events/202609-EMEA-London-One-Database-Every-Workload - Sep 30, 2026 Open House Roadshow London https://clickhouse.com/openhouse/london-2026 - Sep 30, 2026 Munich In-person training - From 0 to Production: Observing and Improving AI Agents with Langfuse https://clickhouse.com/company/events/202610-EMEA-Munich-AI-Agents-w-Langfuse - Oct 6, 2026 Munich In-person training - One Database, Every Workload: A ClickHouse Workshop https://clickhouse.com/company/events/202610-EMEA-Munich-One-Database-Every-Workload - Oct 6, 2026 Open House Roadshow Munich https://clickhouse.com/company/events/202610-munich-open-house - Oct 6, 2026 World Summit AI Amsterdam https://worldsummit.ai/ - Oct 7-8, 2026 AI Builders and Databases Stockholm https://clickhouse.com/company/events/ai-builders-and-databases-oct-stockholm-2026 - Oct 8, 2026 AI Builders and Databases Tel Aviv https://clickhouse.com/company/events/ai-builders-and-databases-oct-tel-aviv-2026 - Oct 12, 2026 SRECon Dublin Happy Hour by the Quay https://luma.com/clickh-6n6u - Oct 13, 2026 SRECon Dublin https://www.usenix.org/conference/srecon25emea - Oct 13-15, 2026 Data Innovation Summit Dubai https://datainnovationsummit.com/region/mea/ Oct 14-15 Oslo In-Person Training: Real-time Analytics with ClickHouse https://clickhouse.com/company/events/202610-EMEA-Oslo-Real-time-Analytics-w-ClickHouse - Oct 14, 2026- PostgreSQL Conference Europe - Oct 20-23, 2026 AWS Cloud Days Riyadh https://aws.amazon.com/events/cloud-days/riyadh/ - Oct 21, 2026 London In-Person Training: Real-time Analytics with ClickHouse https://clickhouse.com/company/events/202610-EMEA-London-Real-time-Analytics-w-ClickHouse - Oct 21, 2026 AI Builders and Analytics London https://clickhouse.com/company/events/ai-builders-and-analytics-oct-london-2026 - Oct 21, 2026 AI Builders and Databases Dubai https://luma.com/clickh-vtzf - Oct 22, 2026- Battle of the Quants London - Oct 22, 2026 Dublin In-Person Training: Real-time Analytics with ClickHouse https://clickhouse.com/company/events/202610-EMEA-Dublin-Real-time-Analytics-w-ClickHouse - Oct 23, 2026 AI Builders and Databases Madrid https://luma.com/clickh-1qqg - Nov 3, 2026 AI Builders and Databases Cyprus https://clickhouse.com/company/events/ai-builders-and-databases-nov-cyprus-2026 - Limassol - Nov 26, 2026 Events in APAC ClickHouse Melbourne Meetup - Aug 2026 https://clickhouse.com/company/events/ch-mel-meetup-26aug26 - Aug 26, 2026 NEOZO AI Meetup × ClickHouse: How Modern Data Platforms Power AI https://clickhouse.com/company/events/ch-bkk-meetup-01sep26 - Bangkok - Sep 1, 2026 Open House Roadshow Bangalore https://clickhouse.com/company/events/202609-APJ-India-Bangalore-Open-House-Roadshow - Sep 22, 2026 Open House Roadshow Singapore https://clickhouse.com/company/events/202609-APJ-ASEAN-Singapore-Open-House-Roadshow - Sep 24, 2026