--- title: PostgreSQL 19 adds graph queries, MySQL 9.7 LTS ships... description: PostgreSQL 19 beta's SQL/PGQ feature landed in the previous digest, but today's posts add more depth on what's shipping across the ecosystem. MySQL 9.7 LTS... canonical: https://daily.dev/posts/postgresql-19-adds-graph-queries-mysql-9-7-lts-ships-the-hypergraph-optimizer-to-community-imy3j9kbm twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL 19 adds graph queries, MySQL 9.7 LTS ships the Hypergraph Optimizer to community | daily.dev og:description: PostgreSQL 19 beta's SQL/PGQ feature landed in the previous digest, but today's posts add more depth on what's shipping across the ecosystem. MySQL 9.7 LTS... og:url: https://daily.dev/posts/postgresql-19-adds-graph-queries-mysql-9-7-lts-ships-the-hypergraph-optimizer-to-community-imy3j9kbm og:image: https://api.daily.dev/og/posts/IMY3j9kBM.png og:image:alt: PostgreSQL 19 adds graph queries, MySQL 9.7 LTS ships the Hypergraph Optimizer to community 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 adds graph queries, MySQL 9.7 LTS ships the Hypergraph Optimizer to community **[Databases Digest](https://daily.dev/sources/databases_digest)** · 4 min read · 1 upvotes · 1 comments ## Summary PostgreSQL 19 beta's SQL/PGQ feature landed in the previous digest, but today's posts add more depth on what's shipping across the ecosystem. MySQL 9.7 LTS brings the Hypergraph Optimizer to the community edition for the first time, with up to 8x faster complex joins. PostgreSQL 18 on RDS and Aurora gets skip scan optimization delivering up to 21x faster queries on multi-column B-tree indexes. Redis is cutting 200 roles and repositioning around AI workloads, which is worth watching if you depend on their roadmap. ## Content **TLDR:** PostgreSQL 19 beta's SQL/PGQ feature landed in the previous digest, but today's posts add more depth on what's shipping across the ecosystem. MySQL 9.7 LTS brings the Hypergraph Optimizer to the community edition for the first time, with up to 8x faster complex joins. PostgreSQL 18 on RDS and Aurora gets skip scan optimization delivering up to 21x faster queries on multi-column B-tree indexes. Redis is cutting 200 roles and repositioning around AI workloads, which is worth watching if you depend on their roadmap. --- ## MySQL 9.7 LTS ships Hypergraph Optimizer to community edition The Hypergraph Optimizer was previously locked to MySQL HeatWave and Enterprise. Version 9.7 LTS opens it to the community edition, substituting hash joins for nested loop joins on complex queries and delivering up to 8x faster execution in those cases. The release also adds JSON Relational Duality Views, improved Group Replication flow control, automatic node eviction, and the ability for lower-version replicas to connect to higher-version sources for rolling upgrades. One hard warning: 9.7.0 contains high-severity CVEs, so go straight to 9.7.1 or later. [Read more](https://daily.dev/posts/4Ld8CcBg5) ## PostgreSQL 18 on RDS and Aurora: skip scan cuts query time up to 21x PostgreSQL 18's skip scan optimization lets the planner use multi-column B-tree indexes even when the leading column isn't in the WHERE clause, with benchmarks showing up to 21x faster queries without adding new indexes. The release also adds autovacuum_vacuum_max_threshold to cap dead tuple accumulation on large tables, vacuum_truncate as a server-wide GUC to reduce AccessExclusiveLock contention, and new timing columns in pg_stat_all_tables for tracking per-table vacuum overhead. If you're running large tables with composite indexes, this is worth testing before assuming you need to restructure your index strategy. [Read more](https://daily.dev/posts/GR3dGROsD) ## OFFSET pagination at depth 4000 took 47 seconds; keyset pagination took 12ms A concrete case study on a real admin orders table: OFFSET-based pagination cost scales with skip depth, not result size, because the database still scans and discards every skipped row. Switching to keyset pagination with a composite index on (created_at DESC, id DESC) dropped the query from 47 seconds to 12ms. The migration path is practical: cap legacy OFFSET at 5000, add composite indexes first, convert hot admin views, then replace deep-paging scripts with cursor-based exports. The post also flags COUNT(*) for totals and ORM-generated OFFSET defaults as common traps that survive the initial migration. [Read more](https://daily.dev/posts/H7BkJKxna) ## Redis cuts 200 roles, pivots to AI-native positioning Redis CEO Rowan Trollope announced a reduction of approximately 200 roles globally alongside a restructuring toward GenAI and agent workloads. Engineering and Product are moving to smaller IC-focused structures. Israel remains Redis's largest site but takes a significant hit from the R&D changes. If Redis is in your stack for caching or pub/sub, it's worth watching whether this pivot shifts investment away from the core data structures you rely on toward AI-specific features. [Read more](https://daily.dev/posts/0fw6l6WjL) --- ## Also notable - **PostgreSQL 17 adds event_triggers GUC to escape broken login triggers without a server restart:** Passing options='-c event_triggers=off' in the connection string disables event triggers before they fire, giving superusers a way out when a buggy login trigger locks everyone out — previously the only escape was restarting in single-user mode. [Read more](https://daily.dev/posts/2eqDC3XMW) - **PostgreSQL LISTEN/NOTIFY can trigger AccessExclusive lock cascades on pg_database under load:** A production incident showed NOTIFY causing AccessExclusive lock cascades that halted a busy database; the fix moves NOTIFY off the transaction hot path using unlogged queue tables and pg_try_advisory_xact_lock batching. [Read more](https://daily.dev/posts/VKYpsjsCR) - **Plaud migrated from MySQL+S3 to TiDB at 300 million rows, achieving P95 latency under 10ms:** Splitting structured metadata from unstructured content across MySQL and S3 with no shared transaction boundary pushed consistency problems into the application layer; TiDB resolved this with ~10x QPS headroom and online schema changes without downtime. [Read more](https://daily.dev/posts/Wo4JrKe3g) - **pg_lake open-sourced: Apache Iceberg tables natively inside Postgres with object storage query support:** After roughly 2.5 years of development and 1,500+ GitHub stars, pg_lake brings Iceberg tables and object storage import/export directly into Postgres without leaving the ecosystem. [Read more](https://daily.dev/posts/2lNJDaMUj) - **Amazon RDS now allows up to four storage modifications within a rolling 24-hour window:** The previous six-hour cool-off period is replaced by a four-modification rolling window, covering storage size, type, and performance changes with no downtime, across all RDS engines in all commercial regions. [Read more](https://daily.dev/posts/6z6FniXiV) ## Similar posts on daily.dev - [PostgreSQL 19 Beta Introduces SQL Graph Queries and Concurrent Table Repacking](https://daily.dev/posts/postgresql-19-beta-introduces-sql-graph-queries-and-concurrent-table-repacking-2adopzbmz) · InfoQ · 91 upvotes · 4 comments - [PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements](https://daily.dev/posts/postgresql-18-on-amazon-aurora-and-amazon-rds-performance-enhancements-lag8ehltp) · AWS Database Blog · 0 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#redis](https://daily.dev/tags/redis), [#mysql](https://daily.dev/tags/mysql) [View this post on daily.dev](https://daily.dev/posts/postgresql-19-adds-graph-queries-mysql-9-7-lts-ships-the-hypergraph-optimizer-to-community-imy3j9kbm) ```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-adds-graph-queries-mysql-9-7-lts-ships-the-hypergraph-optimizer-to-community-imy3j9kbm","headline":"PostgreSQL 19 adds graph queries, MySQL 9.7 LTS ships the Hypergraph Optimizer to community","text":"PostgreSQL 19 beta's SQL/PGQ feature landed in the previous digest, but today's posts add more depth on what's shipping across the ecosystem. MySQL 9.7 LTS brings the Hypergraph Optimizer to the community edition for the first time, with up to 8x faster complex joins. PostgreSQL 18 on RDS and Aurora gets skip scan optimization delivering up to 21x faster queries on multi-column B-tree indexes. Redis is cutting 200 roles and repositioning around AI workloads, which is worth watching if you depend on their roadmap.","url":"https://daily.dev/posts/postgresql-19-adds-graph-queries-mysql-9-7-lts-ships-the-hypergraph-optimizer-to-community-imy3j9kbm","datePublished":"2026-07-16T04:19:10.091Z","dateModified":"2026-09-13T21:08:56.977Z","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":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"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 adds graph queries, MySQL 9.7 LTS ships the Hypergraph Optimizer to community"}]} ```