Promoting a standby doesn't stop the old Postgres primary from taking writes. Here's how the control plane behind ClickHouse Managed Postgres fences it on bare metal, AWS and GCP, and why the design is fail-open.
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.
OpenReplay replaced Postgres with ClickHouse to ingest billions of events and up to 6 TB a day on a single, vertically scaled instance, with sub-second queries and retention handled by a single TTL setting.
Microsoft and Hugging Face have jointly launched the open-source framework ThinkingBox, which generates binary 0/1 rewards by comparing the LLM agent’s final database state after execution with the expected state, for reinforcement learning-based fine-tuning. The accompanying benchmark, ThinkingBox-Bench, includes 507 real-world backend tasks, none of which were used during training. After 50 steps of GRPO fine-tuning, Qwen3.8-27B achieved a 9.08-percentage-point improvement in pass@1 on the held-out test set, with Observed 20/20 nearly tripling; however, pass@20 declined in some domains, reflecting a trade-off between breadth and stability.
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.
A customer saw an extra ~32 ms on simple SELECT queries after idle periods. We traced it to unbatched Native protocol metadata packets overflowing a reset TCP congestion window, reproduced it with network namespaces, and fixed it by batching them.
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.
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.
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.
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.
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.
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.