September 2026 Summaries

PostgreSQL 19, still in beta at the time of writing, introduces four system views aimed at improving observability: pg_stat_lock provides cluster-wide cumulative lock-wait, wait-time, and fast-path exhaustion statistics by lockable object type, helping identify contention and partition-heavy workloads that may benefit from higher max_locks_per_transaction; pg_stat_recovery consolidates standby recovery details into a single atomic snapshot, including replay positions, timelines, pause state, transaction replay time, and promotion status; and pg_stat_autovacuum_scores reveals the per-table scoring system behind a new autovacuum prioritization model that ranks relations by transaction age, dead tuples, inserts, and analyze staleness, with configurable component weights. The smaller pg_dsm_registry_allocations view exposes dynamic shared memory registry allocations used increasingly by extensions that need shared state without requiring preload configuration or a server restart. Together, these additions expand SQL-accessible monitoring data for locks, replication, maintenance, and extension memory, though final behavior and naming may still change before the PostgreSQL 19 general release.

No summary generated yet.

ClickHouse has acquired RunReveal, a security data platform built on ClickHouse, to bring its security expertise in-house while continuing to support independent companies building security products on the database. The acquisition reflects the demanding nature of security workloads, which require high-throughput ingestion of diverse telemetry, long-term retention, efficient storage, and rapid querying for investigations and threat detection. ClickHouse says the combined team will improve security-focused reference architectures, schema and retention guidance, and product roadmap feedback, while RunReveal will remain available through its bring-your-own-database model and existing customers will retain support and contract terms. The companies also emphasize the growing importance of security data for monitoring AI agents and defending against machine-speed threats, with RunReveal’s agentic investigation capabilities expected to help inform future analytics support across the ClickHouse platform.

ClickHouse has released data-agent-mnist, an open, reusable benchmark harness for evaluating agentic analytics models against a company’s own data warehouse, using 201 anonymized and synthetically reconstructed questions drawn from production traffic of its internal DWAINE assistant. Unlike conventional text-to-SQL tests, the benchmark evaluates agents that must discover schemas, plan across multiple steps, execute queries, and return correct result sets, with ground truth established through agreement among models from Anthropic, OpenAI, and Google and answers judged by a provider-diverse panel. In tests of 28 models, Claude Fable 5.1 achieved the highest correctness score at 76.6%, while several open-weight frontier models ranked highly and DeepSeek V4 Flash offered a much cheaper option, scoring 65.7% for roughly $1 per full evaluation compared with $52 for Fable 5.1. The findings suggest that model performance depends strongly on the specific warehouse and workload, that discovering relevant tables is often more difficult than writing executable SQL, and that incorrect planning accounts for most failures. The project also includes privacy safeguards, contamination testing, deterministic data generation, and scripts intended to let organizations create repeatable, tailored benchmarks and compare future models under consistent conditions.

Uken Games, a Toronto-based mobile game studio serving millions of players, replaced Datadog with an observability stack centered on ClickHouse, OpenTelemetry, SigNoz, managed Prometheus, Grafana, and CloudWatch, cutting annual monitoring costs by 87% to about $12,000. The company distinguishes product analytics, which measures engagement and retention, from technical observability, which tracks infrastructure performance, errors, and latency across hundreds of containers, machines, disks, databases, and service deployments. Its new vendor-agnostic trace pipeline uses lightweight OpenTelemetry agents on ECS instances and scalable gateway collectors to filter, batch, and send data through SigNoz to a single ClickHouse node, which stores all traces in roughly 170 GB. Uken retained CloudWatch for logs, used AWS-managed Prometheus for metrics, and automated Grafana alerts through code, enabling hundreds of alerts and frequent queries across its systems. The migration also prompted the team to reduce unnecessary telemetry by retaining errors and slow requests, sampling successful traces, basing alerts on unsampled aggregate metrics, and limiting retention to two weeks, while achieving feature parity with its former platform without downtime.