Alexey Milovidov
The ClickHouse v26.1 release brings 25 features, 43 performance optimizations, and 176 bug fixes. Alexey walks through the technical updates - distinct queries are now 2x faster on low-cardinality columns, JIT compilation extends to nullable aggregates and decimals, and sparse n-grams improve text search selectivity. There's also a new Keeper dashboard that exposes cluster metrics and node data over HTTP, plus better async insert idempotency that now covers materialized views.
The bigger announcement is ClickHouse's managed Postgres service, now in private preview. It's purpose-built for teams running Postgres and ClickHouse together, offering native CDC replication and the PG-ClickHouse extension for querying ClickHouse through Postgres. The goal is to collapse the integration timeline from months to days, with minimal application changes. Sai demos the full flow—creating a Postgres instance, replicating to ClickHouse, and running analytical queries that are 5x faster than OLTP.
This session covers:
- System table additions, reverse-by-separator function, and projection syntax updates
- Max-min fair scheduler for more consistent query latencies under concurrency
- Data lake support for Paimon, Delta Lake deletions, and GCS
- Live Postgres demo with performance comparisons and query pushdown details
- Open source updates—Kubernetes operator, CHDB Pandas API, LangFuse acquisition
