What I learned from a month with WalShadow on ClickHouse Managed Postgres
Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.
AI NEWS JOURNAL
Search AI news
Search headlines, summaries and articles to connect the dots.
The Agentic Analytics Benchmark: ranking tables and labeling failures with Jev
Jev ranks warehouse tables and labels agent failures in under a second, but adding retrieval hints leaves accuracy flat across 20 models on the Agentic Analytics Benchmark.
The new cost-based join optimizer with reordering support for non-inner joins
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
Trace and evaluate Cursor agents with Langfuse, powered by ClickHouse
Connect Cursor to Langfuse to trace every agent turn, pinpoint expensive model and tool calls, and use evaluations to confirm a fix actually helps, with ClickHouse powering the analytics underneath.
The Agentic Analytics Benchmark, round two: GPT-6, Claude Opus 5.5, Claude Sonnet 5.5
We added GPT-6 Astra, Luna and Sol, Claude Opus 5.5 and Claude Sonnet 5.5 to the Agentic Analytics Benchmark: all five land mid-board within a point of each other, and Sonnet 5.5 brings the biggest change in turns, cost and truncated runs.
Introducing the (blazing fast!) native TCP client for .NET
ClickHouse’s new native TCP client for .NET brings faster reads and inserts with fewer allocations, columnar APIs, POCO support, and a path to migrate from HTTP.
Scaling ClickStack alerting with built-in anomaly detection
Managed ClickStack now flags unusual values on the charts you already use with built-in z-score anomaly detection, and a faster, sharded scheduler lets teams bring tens of thousands of alerts over from tools like Grafana.
Why Redshift Serverless can’t match ClickHouse Cloud for real-time analytics
ClickHouse Cloud delivered 1,996× better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
How iSAM Funds built an options research platform for a 10,000x data problem with ClickHouse Cloud
iSAM Funds uses ClickHouse Cloud to research full options history, achieving 35–50x compression and 100x faster single-core ingestion while simplifying its data pipelines.
How we migrated Clera’s 500 GB production database to ClickHouse Managed Postgres overnight
Clera migrated its 500 GB production database and 500+ tables to ClickHouse Managed Postgres overnight, cutting CPU usage from 100% to 10–20%.
🗽 Postgres Summit US 2026 retrospective
Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
Why BigQuery can’t match ClickHouse Cloud for real-time analytics
ClickHouse Cloud delivered 438× better performance per dollar than BigQuery in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
Executable UDFs are now generally available on ClickHouse Cloud
Executable UDFs are now generally available on ClickHouse Cloud across AWS, GCP, and Azure, with native runtimes, network access, observability, and API and Terraform support.
What is direct I/O, and why does ClickHouse Managed Postgres use it for backups?
ClickHouse Managed Postgres uses direct I/O and stripe-sized reads to keep backups fast while protecting the page cache and query latency.
chDB Durable Layer for agent memory
The chDB Durable Layer keeps agent memory fast to query locally while making its analytical state recoverable across laptops, CI jobs, and short-lived sandboxes.
Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026
Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.