--- title: PostgreSQL 19 New Features: What's New and Why It Matters description: PostgreSQL 19 (expected late 2026) introduces a wide range of features addressing developer and operator needs. Highlights include: SQL/PGQ native graph... canonical: https://daily.dev/posts/hdcgv9gq5 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL 19 New Features: What's New and Why It Matters | daily.dev og:description: PostgreSQL 19 (expected late 2026) introduces a wide range of features addressing developer and operator needs. Highlights include: SQL/PGQ native graph... og:url: https://daily.dev/posts/hdcgv9gq5 og:image: https://api.daily.dev/og/posts/HdCgV9gq5.png og:image:alt: Post cover image 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 New Features: What's New and Why It Matters **[Bobby Iliev](https://daily.dev/sources/9adj6fgmy)** · [@bobbyiliev](https://daily.dev/bobbyiliev) · 221 upvotes · 3 comments ## Summary PostgreSQL 19 (expected late 2026) introduces a wide range of features addressing developer and operator needs. Highlights include: SQL/PGQ native graph queries on existing relational tables via the SQL:2023 standard; ON CONFLICT DO SELECT for atomic get-or-create semantics (~4x faster than the no-op workaround); FOR PORTION OF temporal data operations completing SQL:2011 support; pg_plan_advice contrib module for official query plan hints; REPACK CONCURRENTLY for online table rebuilding; parallel autovacuum for multi-index tables; native JSON output for COPY TO; logical replication improvements including sequence sync and dynamic WAL level; and 64-bit MultiXactOffset eliminating wraparound risk. Breaking changes include JIT off by default, LZ4 as default TOAST compression, RADIUS auth removal, and MD5 deprecation warnings. ## 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. **@bobbyiliev** · 7 upvotes > The concurrent table reorg one is the feature I've been waiting years for. Every time I've had to run VACUUM FULL on a multi-TB table it turned into a coordination exercise with every other team. Hard to overstate how much downtime planning this would have saved. **@deepjoshi\_dev** · 1 upvotes > Can wait to see it in action. ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 1 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/hdcgv9gq5) ```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/hdcgv9gq5","headline":"PostgreSQL 19 New Features: What's New and Why It Matters","text":"Shared: PostgreSQL 19 New Features: What's New and Why It Matters","url":"https://daily.dev/posts/hdcgv9gq5","datePublished":"2026-05-11T05:17:33.635Z","dateModified":"2026-05-11T05:19:00.881Z","author":{"@type":"Person","name":"Bobby Iliev","url":"https://daily.dev/bobbyiliev","image":"https://avatars3.githubusercontent.com/u/21223421?v=4","description":"DevOps, DevEx, cloud & open source\n","worksFor":{"@type":"Organization","name":"Materialize","logo":"https://res.cloudinary.com/daily-now/image/upload/s--4mL2CrlK--/f_auto/v1725263959/companies/materialize"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"EndorseAction"},"userInteractionCount":78960}},"image":"https://media.daily.dev/image/upload/s--OHB84bZF--/f_auto/v1722860399/public/Placeholder%2010","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":221},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":3}],"sharedContent":{"@type":"WebPage","url":"https://api.daily.dev/r/KTOzOhvnD"},"comment":[{"@type":"Comment","text":"The concurrent table reorg one is the feature I’ve been waiting years for. Every time I’ve had to run VACUUM FULL on a multi-TB table it turned into a coordination exercise with every other team. Hard to overstate how much downtime planning this would have saved.","datePublished":"2026-05-12T13:25:47.155Z","url":"https://daily.dev/posts/HdCgV9gq5#c-RHr4lYFja","author":{"@type":"Person","name":"Bobby Iliev","url":"https://daily.dev/bobbyiliev","image":"https://avatars3.githubusercontent.com/u/21223421?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":7}},{"@type":"Comment","text":"Can wait to see it in action.","datePublished":"2026-05-12T14:04:56.256Z","url":"https://daily.dev/posts/HdCgV9gq5#c-TmI6uXfQV","author":{"@type":"Person","name":"Deep Joshi","url":"https://daily.dev/deepjoshi_dev","image":"https://media.daily.dev/image/upload/s--TdY8j8Aa--/f_auto/v1776506972/avatars/avatar_aSUkzUQS97QJpQRxKMe49?_a=BAMAMiWQ0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/9adj6fgmy","name":"Bobby Iliev"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Bobby Iliev","item":"https://daily.dev/sources/9adj6fgmy"},{"@type":"ListItem","position":3,"name":"PostgreSQL 19 New Features: What's New and Why It Matters"}]} ```