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%.
AI NEWS JOURNAL
Search AI news
Search headlines, summaries and articles to connect the dots.
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.
Introducing SCIM Provisioning in ClickHouse Cloud
ClickHouse Cloud now supports SCIM 2.0, so your identity provider can create, update, and deprovision organization members and sync group membership to ClickHouse roles automatically.
ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview
ClickHouse Workload for Microsoft Fabric brings sub-second analytics to OneLake data through a native Fabric workload, with dedicated ClickHouse Cloud compute for agents, dashboards, and applications.
Memory safety for Postgres extensions in C/C++
How ClickHouse’s Postgres extensions handle the memory safety challenges of combining C and C++, from clean language boundaries to isolated helper processes.
Can your Postgres survive a bad query?
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
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.
ClickHouse release 26.9
ClickHouse 26.9 introduces conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for DISTINCT, time-limited tokens, and faster min/max/count queries.
How Fountain rebuilt its data plane on ClickHouse Cloud to power Cue, the Frontline Superintelligence
Fountain cut analytics latency from three hours to under two minutes and costs by 66% by rebuilding Cue’s data plane on ClickPipes and ClickHouse Cloud.
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.
The official ClickHouse provider for Apache Airflow is now available
The official ClickHouse provider for Apache Airflow simplifies data workflows with standard SQL operators, bulk inserts, and shared setup across self-managed Airflow and Astronomer.