--- title: Get Excited About Postgres 18 | daily.dev description: PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip... canonical: https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Get Excited About Postgres 18 | daily.dev og:description: PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip... og:url: https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7 og:image: https://api.daily.dev/og/posts/0eq8ZHjg7.png og:image:alt: Get Excited About Postgres 18 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. # Get Excited About Postgres 18 **[Crunchy Data](https://daily.dev/sources/crunchydata)** · 8 min read · 75 upvotes · 2 comments ## Summary PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip scans for multi-column indexes, virtual generated columns as the default, and OAuth 2.0 authentication support. The async I/O feature allows workers to batch reads and optimize idle time, while UUID v7 provides better locality through timestamp-based prefixes. Skip scans enable using multi-column indexes even when leading columns aren't in query conditions, and virtual generated columns compute values on-the-fly without storage overhead. ## 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. **@alexlittle** · 0 upvotes > This is huge, can’t wait to use it **@byteoutlaw** · 0 upvotes > I am cooking up the front end atm, but with pg I cannot wait to play DBA! 🙃 ☺️ So nice I can stay in a modern, open sauce kitchen while cooking with all the utensils I need! (json(like nosql schemas), geo and vector ect.) --- Tags: [#performance](https://daily.dev/tags/performance), [#database](https://daily.dev/tags/database), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7) ```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":"TechArticle","headline":"Get Excited About Postgres 18","url":"https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7"},"datePublished":"2025-09-12T16:32:58.615Z","dateModified":"2025-09-12T16:33:19.520Z","description":"PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/db545bed504312e09b7980ee9ce504f5?_a=AQAEulh","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/db545bed504312e09b7980ee9ce504f5?_a=AQAEulh","isAccessibleForFree":true,"articleSection":"Crunchy Data","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Crunchy Data","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/689da8cf2d2a4fa4b09736e4f4b18fce","url":"https://daily.dev/sources/crunchydata"},"commentCount":2,"discussionUrl":"https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":75},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":2}],"keywords":"performance,database,postgresql","timeRequired":"PT8M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Crunchy Data","item":"https://daily.dev/sources/crunchydata"},{"@type":"ListItem","position":3,"name":"Get Excited About Postgres 18"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/get-excited-about-postgres-18-0eq8zhjg7","comment":[{"@type":"Comment","text":"This is huge, can’t wait to use it","datePublished":"2025-10-09T15:17:24.013Z","url":"https://daily.dev/posts/0eq8ZHjg7#c-Ax8CraNRz","author":{"@type":"Person","name":"Alex Little","url":"https://daily.dev/alexlittle","image":"https://lh3.googleusercontent.com/a/ACg8ocK0qaVMAcTEgLH0D57lq-hefAg4nNZKCtJrAwGbFUjCZbzqZA=s96-c"}},{"@type":"Comment","text":"I am cooking up the front end atm, but with pg I cannot wait to play DBA! 🙃 ☺️ So nice I can stay in a modern, open sauce kitchen while cooking with all the utensils I need! (json(like nosql schemas), geo and vector ect.)","datePublished":"2025-10-14T05:35:00.133Z","url":"https://daily.dev/posts/0eq8ZHjg7#c-ePh9ynh2R","author":{"@type":"Person","name":"Jacob B. Bonde","url":"https://daily.dev/byteoutlaw","image":"https://media.daily.dev/image/upload/s--veTChHK7--/f_auto/v1733220070/avatars/avatar_5cQvIZKr5tDFDotVDjulg"}}]} ```