proomt

Search

Search posts, papers, and topics

All posts

ClickHouseMark Needham7 min readintermediate

September 2026 newsletter

Read on clickhouse.com

Summary

ClickHouse's September 2026 newsletter highlights the 26.8 release with features like pipelined SQL and custom HTTP handlers, alongside previews for On-Demand Compute and a PromQL-compatible TimeSeries engine. It also covers new Postgres integration tools and a cost-performance benchmark for cloud data warehouses.

  • ClickHouse 26.8 introduces pipelined SQL (`|>`) and custom HTTP handlers for streaming API use cases.
  • On-Demand Compute (preview) offers dedicated workers, a new cost-based optimizer, and distributed query execution for intensive workloads.
  • A new TimeSeries engine with PromQL support (preview) allows ingesting Prometheus metrics and querying them directly in ClickHouse.
  • WalShadow enables sub-second Postgres WAL replication to ClickHouse, and a `chdb` Postgres extension expands import/export.

Data engineers and architects using or considering ClickHouse will find valuable updates on new features, performance benchmarks, and enhanced integration with Postgres and Prometheus.

6/10
observabilityperformancedatabasespostgresclickhousedata warehousing

Related reading

  2. Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026

    The author recaps two Dutch conferences where they presented ClickHouse‑Postgres extensions and discussed PostgreSQL 19 monitoring enhancements. The post explains how pg_clickhouse provides transparent query push‑down to ClickHouse and how pg_stat_ch streams per‑query metrics, plus new logging defaults and system views in PG 19.

    ClickHouseclickhouse.com7 min

  3. What's new in ClickStack - Aug ’26

    ClickStack August 2026 update adds general‑availability dashboard variables (including cross‑source SQL, Lucene, PromQL macros), chart formulas for derived metrics, a metrics explorer UI, release‑marker overlays, OIDC auth for the collector, and a beta LLM observability dashboard. It also introduces a private‑preview TimeSeries engine with PromQL support, letting ClickStack store and query Promet…

    ClickHouseclickhouse.com16 min

  4. ClickHouse is now available on the dbt platform

    ClickHouse released a public‑beta dbt v2 adapter written in Rust that ships inside the dbt binary and talks to ClickHouse via the new ADBC driver. The adapter promises up to 30× faster dbt parsing and leverages ClickHouse’s sub‑second, high‑concurrency engine (e.g., materialized views, MCP server). A private‑beta integration on the dbt Platform now lets users develop, schedule, and catalog ClickH…

    ClickHouseclickhouse.com8 min

  5. The official ClickHouse provider for Apache Airflow is now available

    The post announces the official ClickHouse provider for Apache Airflow, showing how to install it, configure a ClickHouse connection, and run queries using standard SQL operators or a ClickHouseHook. It includes examples for both self‑hosted Airflow and the Astronomer managed platform.

    ClickHouseclickhouse.com5 min

  6. ClickHouse welcomes RunReveal

    ClickHouse announced it has acquired RunReveal, a security data platform built on ClickHouse, to deepen its expertise in security workloads. The deal promises better guidance for security teams while keeping RunReveal's product unchanged for existing customers.

    ClickHouseclickhouse.com2 minHN7