--- title: Postgres 18 just dropped. Now is the best time to learn... description: PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications.... canonical: https://daily.dev/posts/m9poq0slr twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Postgres 18 just dropped. Now is the best time to learn it... | daily.dev og:description: PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications.... og:url: https://daily.dev/posts/m9poq0slr og:image: https://api.daily.dev/og/posts/M9poq0SLr.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. # Postgres 18 just dropped. Now is the best time to learn it... **[Postgres Daily](https://daily.dev/sources/postgresdaily)** · [@bobbyiliev](https://daily.dev/bobbyiliev) · 10 upvotes · 0 comments ## Summary PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications. Key features include smarter query optimization for OR/IN clauses, enhanced hash joins, virtual generated columns as default, UUID version 7 support with timestamp ordering, improved RETURNING clause functionality, and temporal constraints with WITHOUT OVERLAPS. The upgrade process is now smoother with preserved statistics, eliminating the need to rebuild planner statistics after major version upgrades. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## 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 - [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments - [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments --- 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/m9poq0slr) ```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/m9poq0slr","headline":"Postgres 18 just dropped. Now is the best time to learn it...","text":"Shared: Postgres 18 just dropped. Now is the best time to learn it...","url":"https://daily.dev/posts/m9poq0slr","datePublished":"2025-08-16T11:14:28.662Z","dateModified":"2025-08-16T11:14:28.668Z","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":78870}},"image":"https://media.daily.dev/image/upload/s--CxzD6vbw--/f_auto/v1722860399/public/Placeholder%2005","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":10},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"sharedContent":{"@type":"WebPage","url":"https://api.daily.dev/r/Oi3KWxzaL"},"isPartOf":{"@type":"WebPage","url":"https://daily.dev/squads/postgresdaily","name":"Postgres Daily"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Postgres Daily","item":"https://daily.dev/squads/postgresdaily"},{"@type":"ListItem","position":3,"name":"Postgres 18 just dropped. Now is the best time to learn it..."}]} ```