--- title: PostgreSQL 19 ships four new stat views, ClickHouse... description: PostgreSQL 19 beta adds four system views that finally make autovacuum ordering, lock contention, and recovery state queryable instead of guessable. ClickHouse... canonical: https://daily.dev/posts/postgresql-19-ships-four-new-stat-views-clickhouse-acquires-a-security-startup-jgskvlwbi twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL 19 ships four new stat views, ClickHouse acquires a security startup | daily.dev og:description: PostgreSQL 19 beta adds four system views that finally make autovacuum ordering, lock contention, and recovery state queryable instead of guessable. ClickHouse... og:url: https://daily.dev/posts/postgresql-19-ships-four-new-stat-views-clickhouse-acquires-a-security-startup-jgskvlwbi og:image: https://api.daily.dev/og/posts/JGsKvlwbi.png og:image:alt: PostgreSQL 19 ships four new stat views, ClickHouse acquires a security startup og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL 19 ships four new stat views, ClickHouse acquires a security startup **[Databases Digest](https://daily.dev/sources/databases_digest)** · 4 min read · 0 upvotes · 0 comments ## Summary PostgreSQL 19 beta adds four system views that finally make autovacuum ordering, lock contention, and recovery state queryable instead of guessable. ClickHouse bought RunReveal to bring security-data expertise in-house and open-sourced a benchmark showing cheap models can nearly match top performers on analytics agent tasks at a fraction of the cost. Debezium shipped a maintenance release fixing a real throughput-degradation bug in long-running connectors. Uken Games posted an 87% cut in observability spend by swapping Datadog for a ClickHouse-based stack. ## Content **TLDR:** PostgreSQL 19 beta adds four system views that finally make autovacuum ordering, lock contention, and recovery state queryable instead of guessable. ClickHouse bought RunReveal to bring security-data expertise in-house and open-sourced a benchmark showing cheap models can nearly match top performers on analytics agent tasks at a fraction of the cost. Debezium shipped a maintenance release fixing a real throughput-degradation bug in long-running connectors. Uken Games posted an 87% cut in observability spend by swapping Datadog for a ClickHouse-based stack. --- ## PostgreSQL 19 beta adds four new system views for observability pg_stat_autovacuum_scores exposes the new per-table scoring system that now decides autovacuum processing order, replacing the old pg_class ordering that DBAs have been guessing around for years. pg_stat_lock gives cumulative lock contention stats per lock type including a fastpath_exceeded counter that matters for partition-heavy workloads, while pg_stat_recovery finally collapses standby state into one atomic snapshot instead of stitching together several functions that could disagree with each other. A fourth view, pg_dsm_registry_allocations, tracks dynamic shared memory used by extensions that no longer need shared_preload_libraries and a restart. [Read more](https://daily.dev/posts/BqYIYuLz1) ## ClickHouse acquires RunReveal, doubles down on agentic analytics ClickHouse bought RunReveal, a security data platform built on top of ClickHouse, to bring security-specific schema and retention expertise in-house. RunReveal keeps operating under its bring-your-own-database model with existing contracts untouched, but its agentic security investigation work is expected to feed into ClickHouse's broader agentic analytics roadmap. Separately, ClickHouse open-sourced a benchmark testing 28 models on 201 real analytics questions: Claude Fable 5.1 wins on correctness at 76.6%, but DeepSeek V4 Flash hits 65.7% at 52x lower cost, and the dominant failure mode across almost every model is picking the wrong plan, not bad SQL. [Read more](https://daily.dev/feed-by-ids?id=6vLVNnlqP&id=81A3CONc5) ## Debezium 3.6.2 fixes a slow-leak throughput bug in long-running connectors The maintenance release patches gradual throughput degradation caused by unbounded internal cache tracking, something anyone running Debezium connectors for weeks at a time has probably hit without knowing why. It also adds incremental snapshot support on PostgreSQL read-only replicas, masks passwords in Debezium Server logs, and bumps the PostgreSQL JDBC driver to 42.7.13 to close CVE-2026-54291. 41 issues resolved total, including DDL parser fixes for MySQL and Oracle. [Read more](https://daily.dev/posts/zcESADH7x) ## Uken Games cuts observability spend 87% by ditching Datadog for ClickHouse The Toronto studio replaced Datadog with an open-source stack (ClickHouse, OpenTelemetry, SigNoz, Prometheus, Grafana) and dropped annual costs from six figures down to about $12,000. All traces now live on a single ClickHouse node using roughly 170GB of disk, with two-week retention and sampling tuned to keep signal on errors and high-latency requests. They hit feature parity with Datadog and automated alerting through CloudFormation-as-code, which is the part that actually makes this reproducible rather than a one-off. [Read more](https://daily.dev/posts/nDgLfU6JO) --- ## Also notable - **PostGIS memory-safety bug patched across managed Postgres providers:** A researcher found an out-of-bounds memory access in the address_standardizer PostGIS extension exploitable by an ordinary tenant role, and Databricks and Neon shipped downstream patches before an upstream PostGIS release existed. [Read more](https://daily.dev/posts/bIEamlQdJ) - **Valkey 9.0's Atomic Slot Migration needs an unusually broad ACL:** ASM sends replication commands as the authenticated replicator user instead of an internal superuser client, so it requires a specific write-heavy ACL rule set (+@write ~* -@dangerous plus several exceptions) that differs from normal replication. [Read more](https://daily.dev/posts/c2HG69ftB) - **Idle Postgres replication slots can balloon WAL retention fast:** A demo shows an idle logical replication slot growing from 1,488 bytes to 45MB of retained WAL in under a minute, which is exactly the kind of thing that silently fills a primary's disk if nobody's watching. [Read more](https://daily.dev/posts/7idWGos8V) - **MariaDB's Q3 2026 releases mark the first cycle without 10.6:** 10.3.3, 11.8.9, 11.4.13, and 10.11.19 shipped as maintenance releases, with 10.6 now off the support list after reaching end of life on July 6. [Read more](https://daily.dev/posts/bbUwTzgdE) - **DuckDB's developer Duck Labs is being acquired by Amazon:** The note comes buried in a piece benchmarking a local Qwen3.8 27B plus DuckDB setup against GPT 5.6 Luna, where the local combo won on cost by over 17x on the DABstep SQL benchmark. [Read more](https://daily.dev/posts/ZcF9tQvLb) --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#observability](https://daily.dev/tags/observability), [#clickhouse](https://daily.dev/tags/clickhouse), [#debezium](https://daily.dev/tags/debezium) [View this post on daily.dev](https://daily.dev/posts/postgresql-19-ships-four-new-stat-views-clickhouse-acquires-a-security-startup-jgskvlwbi) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/postgresql-19-ships-four-new-stat-views-clickhouse-acquires-a-security-startup-jgskvlwbi","headline":"PostgreSQL 19 ships four new stat views, ClickHouse acquires a security startup","text":"PostgreSQL 19 beta adds four system views that finally make autovacuum ordering, lock contention, and recovery state queryable instead of guessable. ClickHouse bought RunReveal to bring security-data expertise in-house and open-sourced a benchmark showing cheap models can nearly match top performers on analytics agent tasks at a fraction of the cost. Debezium shipped a maintenance release fixing a real throughput-degradation bug in long-running connectors. Uken Games posted an 87% cut in observability spend by swapping Datadog for a ClickHouse-based stack.","url":"https://daily.dev/posts/postgresql-19-ships-four-new-stat-views-clickhouse-acquires-a-security-startup-jgskvlwbi","datePublished":"2026-09-02T04:18:25.563Z","dateModified":"2026-09-02T04:18:46.608Z","author":{"@type":"Organization","name":"Databases Digest","logo":"https://media.daily.dev/image/upload/s--ir1hdV8b--/f_auto,q_auto/v1773839400/logos/databases_digest?_a=BAMAMiiu0","url":"https://daily.dev/sources/databases_digest"},"interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/databases_digest","name":"Databases Digest"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Databases Digest","item":"https://daily.dev/sources/databases_digest"},{"@type":"ListItem","position":3,"name":"PostgreSQL 19 ships four new stat views, ClickHouse acquires a security startup"}]} ```