--- title: "PostgreSQL 19 Beta Introduces SQL Graph Queries and Concurrent Table Repacking" url: https://daily.dev/posts/postgresql-19-beta-introduces-sql-graph-queries-and-concurrent-table-repacking-2adopzbmz source_url: https://www.infoq.com/news/2026/06/postgresql-19-graph-queries type: article source: "InfoQ" published: 2026-06-16T07:23:19.769Z updated: 2026-06-16T07:23:41.047Z tags: ["database", "architecture", "postgresql"] reading_time: 3 upvotes: 91 comments: 4 language: 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 Beta Introduces SQL Graph Queries and Concurrent Table Repacking **[InfoQ](https://daily.dev/sources/infoq)** · 3 min read · 91 upvotes · 4 comments ## Summary PostgreSQL 19 Beta 1 has been released, with general availability expected in September. Key features include native SQL Property Graph Queries (SQL/PGQ) enabling graph queries over relational tables without a separate graph database, and a new REPACK CONCURRENTLY command for online table rebuilds without downtime. Performance highlights include up to 2x faster inserts with foreign key checks, anti-join optimizations, incremental sorts, and eager aggregation. Logical replication gains automatic sequence synchronization and can now be enabled without a server restart. The new WAIT FOR LSN feature lets read replicas pause until caught up to a specific write position. Other notable changes include parallel autovacuum, automatic I/O worker scaling, pg_plan_advice for persisting query planner decisions, and JIT compilation disabled by default. AWS has made Beta 1 available in the RDS Preview Environment. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@sademban** · 5 upvotes > eagerly waiting for it <3 **@rafaelpastre** · 3 upvotes > PostgreSQL getting bigger and bigger and highly adopted! Great features on the way!! **@muazsajid** · 3 upvotes > ngl that seems good.. --- Tags: [#database](https://daily.dev/tags/database), [#architecture](https://daily.dev/tags/architecture), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/postgresql-19-beta-introduces-sql-graph-queries-and-concurrent-table-repacking-2adopzbmz)