proomt

Search

Search posts, papers, and topics

ClickHouse

9 posts

  1. Postgres on NVMe: performance and the convergence of transactions and analytics

    Local NVMe storage cuts Postgres I/O latency from ms to µs, yielding ~9× higher TPS and 10× lower transaction latency on a 482 GiB pgbench workload. The gain comes from reduced IO wait, not more CPU work. To retain durability, combine NVMe with quorum synchronous replication and continuous WAL archiving (WAL‑G). For analytics, offload scans to ClickHouse via WAL‑based CDC (pg_clickhouse or the ne…

    ClickHouseclickhouse.com8 min

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

  3. September 2026 newsletter

    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.

    ClickHouseclickhouse.com7 min

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

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

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

  8. Replica-aware routing public beta

    Replica‑aware routing (public beta) lets ClickHouse Cloud users pin a query stream to a specific replica by sending a custom header (HTTP) or overriding the TLS SNI (native). The proxy (Envoy) hashes the tag and consistently forwards all requests with the same tag to that replica, giving read‑after‑write consistency for temporary tables, session objects, and warm replica caches. Stickiness is bes…

    ClickHouseclickhouse.com6 min

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