<!doctype html><html lang="en"> <head> <title>PostgreSQL: The world's most advanced open source database</title> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta http-equiv="Content-Type" content="text/xhtml; charset=utf-8" /> <meta name="description" content="The official site for PostgreSQL, the world's most advanced open source database" /> <meta name="theme-color" content="#336791"/> <meta name="copyright" content="The PostgreSQL Global Development Group" /> <meta property="og:url" content="https://www.postgresql.org/" /> <meta property="og:type" content="article" /> <meta property="article:author" content="PostgreSQL Global Development Group" /> <meta property="article:published_time" content="2025-10-28T21:07:39.020633" /> <meta property="og:image" content="https://www.postgresql.org/media/img/about/press/elephant.png" /> <meta property="og:title" content="PostgreSQL" /> <meta property="og:description" content="The world's most advanced open source database." /> <meta property="og:site_name" content="PostgreSQL" /> <link href="/media/css/fontawesome.css?e54c1eb0" rel="stylesheet"> <link rel="stylesheet" href="/media/css/bootstrap-4.4.1.min.css"> <link rel="shortcut icon" href="/favicon.ico" /> <link rel="stylesheet" type="text/css" href="/dyncss/base.css?e54c1eb0"> <script src="/media/js/theme.js?e54c1eb0"></script> </head> <body> <div class="container-fluid"> <div class="row justify-content-md-center"> <div class="col"> <!-- Header --> <nav class="navbar navbar-expand-lg navbar-light bg-light"> <a class="navbar-brand p-0" href="/"> <img class="logo" src="/media/img/about/press/elephant.png" alt="PostgreSQL Elephant Logo"> </a> <input type="checkbox" id="navbar-toggler" aria-controls="pgNavbar" aria-expanded="false" aria-label="Toggle navigation"> <label for="navbar-toggler" id="navbar-toggler-label" class="navbar-toggler" tabindex="0"><span class="navbar-toggler-icon"></span></label> <div class="navbar-collapse" id="pgNavbar"> <ul class="navbar-nav mr-auto"> <li class="nav-item p-2"><a href="/" title="Home">Home</a></li> <li class="nav-item p-2"><a href="/about/" title="About">About</a></li> <li class="nav-item p-2"><a href="/download/" title="Download">Download</a></li> <li class="nav-item p-2"><a href="/docs/" title="Documentation">Documentation</a></li> <li class="nav-item p-2"><a href="/community/" title="Community">Community</a></li> <li class="nav-item p-2"><a href="/developer/" title="Developers">Developers</a></li> <li class="nav-item p-2"><a href="/support/" title="Support">Support</a></li> <li class="nav-item p-2"><a href="/about/donate/" title="Donate">Donate</a></li> <li class="nav-item p-2"><a href="/account/" title="Your account">Your account</a></li> </ul> <form role="search" method="get" action="/search/"> <div class="input-group"> <input id="q" name="q" type="text" size="20" maxlength="255" accesskey="s" class="form-control" placeholder="Search for..."> <span class="input-group-btn"> <button class="btn btn-default" type="submit"><i class="fas fa-search"></i></button> </span> </div><!-- /input-group --> </form> <form id="form-theme" class="form-inline d-none"> <button id="btn-theme" class="btn btn-default ml-1" type="button"></button> </form> </div> </nav> </div> </div> <div class="row justify-content-center pg-shout-box"> <div class="col text-white text-center">September 25, 2025: <a href="/about/news/postgresql-18-released-3142/"> PostgreSQL 18 Released!</a></div> </div> </div> <div class="jumbotron jumbotron-fluid pg-jumbotron"> <div class="container"> <h1 class="text-white pg-jumbotron-header">PostgreSQL: The World's Most Advanced Open Source Relational Database</h1> <div class="row"> <div class="col text-center"> <a class="btn btn-light btn-rounded" role="button" href="/download/">Download <i class="fa fa-arrow-right" aria-hidden="true"></i></a> <a class="btn btn-light btn-rounded" role="button" href="/about/">New to PostgreSQL?</a> </div> </div> </div></div><!-- END Jumbotron --><div class="container margin"> <!-- Start First Feature Row --> <div class="row"> <!-- Feature --> <div class="col-lg-6 feature"> <img src="/media/img/about/press/elephant.png" alt="PostgreSQL Elephant Logo"> <h2>New to PostgreSQL?</h2> <div class="text"> <p> PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. </p> <p> There is a wealth of information to be found describing how to <a href="/download/">install</a> and <a href="/docs/">use</a> PostgreSQL through the <a href="/docs/">official documentation</a>. The <a href="/community/">open source community</a> provides many helpful places to become familiar with PostgreSQL, discover how it works, and find career opportunities. Learn more on how to <a href="/community/">engage with the community</a>. </p> </div> <a href="/about/" title="Learn More"><button type="button" class="btn btn-center btn-primary btn-inline-block">Learn More</button></a> <a href="/about/featurematrix/" title="Feature Matrix"><button type="button" class="btn btn-center btn-primary btn-inline-block">Feature Matrix</button></a> <a href="/about/governance/" title="Governance"><button type="button" class="btn btn-center btn-primary btn-inline-block">Governance</button></a> </div> <!-- END Feature --> <!-- Feature --> <div class="col-lg-6 feature"> <i class="fas fa-download"></i> <h2>Latest Releases</h2> <div class="text"> <p> <strong> 2025-09-25 - <a href="/about/news/postgresql-18-released-3142/"> PostgreSQL 18 Released! </a> </strong> </p> <p> The PostgreSQL Global Development Group today announced the release of <a href="/docs/18/release-18.html">PostgreSQL 18</a>, the latest version of the world's most advanced open source database. </p> <p> PostgreSQL 18 improves performance for workloads of all sizes through a new I/O subsystem that has demonstrated up to 3× performance improvements when reading from storage, and also increases the number of queries that can use indexes. This release makes major-version upgrades less disruptive, accelerating upgrade times and reducing the time required to reach expected performance after an upgrade completes. Developers also benefit from PostgreSQL 18 features, including virtual generated columns that compute values at query time, and the database-friendly <code>uuidv7()</code> function that provides better indexing and read performance for UUIDs. PostgreSQL 18 makes it easier to integrate with single-sign on (SSO) systems with support for OAuth 2.0 authentication. </p> <p> For the full list of features in PostgreSQL 18, please review the <a href="/docs/18/release-18.html">release notes</a>. You can download PostgreSQL 18 from the <a href="/download/">download</a> page. </p> <p> For the <a href="/about/press/"></a>full press release</a> and <a href="/about/press/">translations of the release announcement</a>, please visit the <a href="/about/press/">press kit</a>. </p> <ul> <li class=""><strong>18.0</strong> · 2025-09-25 · <a href="/docs/18/release-18.html">Notes</a></li> <li class="pg-bg-gray"><strong>17.6</strong> · 2025-08-14 · <a href="/docs/17/release-17-6.html">Notes</a></li> <li class=""><strong>16.10</strong> · 2025-08-14 · <a href="/docs/16/release-16-10.html">Notes</a></li> <li class="pg-bg-gray"><strong>15.14</strong> · 2025-08-14 · <a href="/docs/15/release-15-14.html">Notes</a></li> <li class=""><strong>14.19</strong> · 2025-08-14 · <a href="/docs/14/release-14-19.html">Notes</a></li> <li class="pg-bg-gray"><strong>13.22</strong> · 2025-08-14 · <a href="/docs/13/release-13-22.html">Notes</a></li> </ul> </div> <a href="/download/" title="Download"><button type="button" class="btn btn-center btn-primary">Download</button></a> <a href="/support/versioning/" title="Why Upgrade?"><button type="button" class="btn btn-center btn-outline-secondary btn-inline-block">Why Upgrade?</button></a> <a href="/support/security/" title="Security"><button type="button" class="btn btn-center btn-outline-secondary btn-inline-block">Security</button></a> </div> <!-- END Feature --> </div> <!-- END First Feature Row --> <!-- Start Second Feature Row --> <div class="row"> <!-- Feature --> <div class="col-lg-6 feature"> <i class="fas fa-calendar-alt"></i> <h2>Upcoming Events</h2> <div class="text"> <ul> <li class=" non-badged"> 2025-11-20 · <a href="/about/event/postgis-day-2025-2557/">PostGIS Day 2025</a> </li> <li class="pg-bg-gray "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2025-11-21 · <a href="/about/event/postgresql-conference-japan-2025-2552/">PostgreSQL Conference Japan 2025</a> </li> <li class=" "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2026-02-06 · <a href="/about/event/cern-pgday-2026-2566/">CERN PGDay 2026</a> </li> <li class="pg-bg-gray "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2026-03-05 – 2026-03-06 · <a href="/about/event/postgresqlscale23x-2565/">PostgreSQL@SCaLE23x</a> </li> <li class=" "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2026-03-11 – 2026-03-13 · <a href="/about/event/pgconf-india-2026-2560/">PGConf India 2026</a> </li> <li class="pg-bg-gray "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2026-03-26 · <a href="/about/event/pgday-paris-2026-2562/">pgDay Paris 2026</a> </li> <li class=" "> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> 2026-05-05 · <a href="/about/event/pgconfbe-2026-2564/">PGConf.BE 2026</a> </li> </ul> <p> <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event"> indicates that an event is recognised under the <a href="/about/policies/conferences/">community event guidelines</a> and is directly helping the PostgreSQL community. </p> </div> <a href="/about/events/" title="Check Schedule"><button type="button" class="btn btn-center btn-primary btn-inline-block">Check Schedule</button></a> <a href="/account/events/new/" title="Add Your Event"><button type="button" class="btn btn-center btn-primary btn-inline-block">Add Your Event</button></a> </div> <!-- END Feature --> <!-- Feature --> <div class="col-lg-6 feature"> <i class="fas fa-envelope"></i> <h2>Mailing Lists</h2> <div class="text"> <p> The PostgreSQL <a href="https://lists.postgresql.org" target="_blank" rel="noopener">mailing lists</a> enable you to interact with active community participants on subjects related to the development of PostgreSQL, discovering how to use PostgreSQL, or learning about upcoming events and product releases. </p> <p> In order to manage your mailing list subscription, you need a <a href="/account/">PostgreSQL community account</a>. <a href="/account/">Signing up</a> is easy and gives you direct access to the <a href="/community/">global PostgreSQL community</a>. </p> </div> <a href="https://lists.postgresql.org" title="Subscribe"><button type="button" class="btn btn-center btn-primary btn-inline-block">Subscribe</button></a> <a href="https://www.postgresql.org/list/" title="View Archives"><button type="button" class="btn btn-center btn-outline-secondary btn-inline-block">View Archives</button></a> </div> <!-- END Feature --> </div> <!-- END Second Feature Row --></div><!-- CTA --><div class="container-fluid"> <div class="row"> <div class="col-lg-6 cta cta-3"></div> <div class="col-lg-6 cta-text"> <h2>Learning Opportunities Ahead</h2> <p class="text-left"> Want to learn more about PostgreSQL and help build the community? Come to one of the many events, local user groups, & training sessions where you can meet experienced PostgreSQL users and enhance your database skills. </p> <a href="/about/events/" title="Browse Events"><button type="button" class="btn btn-light btn-rounded">Browse Events</button></a> <a href="/community/user-groups/" title="Browse User Groups"><button type="button" class="btn btn-light btn-rounded">Browse User Groups</button></a> </div> </div></div><!-- END CTA --><!-- News --><div class="container"> <div class="row"> <div class="col-lg-7"> <h2 class="centered-lines">Latest News</h2> <!-- Featured Post --> <header> <h3> <a href="/about/news/postgresql-18-released-3142/"> PostgreSQL 18 Released! </a> </h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-09-25</li> <!--<li><i class="far fa-comments"></i> 0</li>--> </ul> </header> <p> The PostgreSQL Global Development Group today announced the release of <a href="/docs/18/release-18.html">PostgreSQL 18</a>, the latest version of the world's most advanced open source database. </p> <p> PostgreSQL 18 improves performance for workloads of all sizes through a new I/O subsystem that has demonstrated up to 3× performance improvements when reading from storage, and also increases the number of queries that can use indexes. This release makes major-version upgrades less disruptive, accelerating upgrade times and reducing the time required to reach expected performance after an upgrade completes. Developers also benefit from PostgreSQL 18 features, including virtual generated columns that compute values at query time, and the database-friendly <code>uuidv7()</code> function that provides better indexing and read performance for UUIDs. PostgreSQL 18 makes it easier to integrate with single-sign on (SSO) systems with support for OAuth 2.0 authentication. </p> <p> "The efforts of the global open source community shape every PostgreSQL release and help deliver features that meet users where their data resides," said Jonathan Katz, a member of the PostgreSQL core team. "PostgreSQL 18 builds on the project's long, rich history of delivering a reliable and robust data management experience, while continuing to expand the workloads it can support." </p> <p> PostgreSQL, an innovative data management system known for its reliability, robustness, and extensibility, benefits from nearly 30 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes. </p> <ul class="bold"> <li><a href="/about/news/postgresql-18-released-3142/">Release Announcement</a></li> <li><a href="/about/press/">Press Kit & Translations</a></li> <li><a href="/docs/18/release-18.html">PostgreSQL 18 Release Notes</a></li> <li><a href="/support/versioning/">Versioning Policy</a> <li><a href="/download/">Download</a></li> </ul> <a href="/about/newsarchive/" title="Archives"><button type="button" class="btn btn-primary btn-center btn-inline-block">Browse Archives</button></a> <a href="/account/news/new/" title="Submit News"><button type="button" class="btn btn-primary btn-center btn-inline-block">Submit News</button></a> </div> <div class="col-lg-5"> <div class="sidebar"> <!-- Archives --> <ul class="divided"> <li> <h3><a href="/about/news/pg_dbms_errlog-v22-released-3161/">pg_dbms_errlog v2.2 released</a></h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-10-20 by HexaCluster</li> </ul> </li> <li> <h3><a href="/about/news/pg_ivm-113-released-3159/">pg_ivm 1.13 released</a></h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-10-20 by IVM Development Group</li> </ul> </li> <li> <h3><a href="/about/news/credcheck-v41-has-been-released-3156/">credcheck v4.1 has been released</a></h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-10-20 by HexaCluster</li> </ul> </li> <li> <h3><a href="/about/news/plhaskell-v50-released-3162/">PL/Haskell v5.0 Released</a></h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-10-20 by PL/Haskell</li> </ul> </li> <li> <h3><a href="/about/news/announcing-pg_oidc_validator-3160/">Announcing pg_oidc_validator</a></h3> <ul class="meta"> <li><i class="far fa-clock"></i> 2025-10-20 by Percona</li> </ul> </li> </ul> <!-- END Archives --> </div> </div> </div></div><!-- Blog --> <div class="container margin"> <div class="row"> <div class="col-md-12"> <h2 class="centered-lines"><span>PLANET POSTGRESQL</span></h2> <div class="feature"><i class="fas fa-globe"></i></div> </div> </div> <!-- First Row Planet PostgreSQL --> <div class="row"> <!-- First Column First Row Planet PostgreSQL --> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k6"> #PostgresMarathon 2-009: Prepared statements and partitioned table lock explosi</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Nikolay Samokhvalov</li> <li><i class="far fa-clock"></i> 2025-10-28</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k7"> The Future of CYBERTEC and PostgreSQL</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Hans-Juergen Schoenig</li> <li><i class="far fa-clock"></i> 2025-10-28</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k4"> Explaining IPC:SyncRep – Postgres Sync Replication is Not Actually Sync Replicatio</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Jeremy Schneider</li> <li><i class="far fa-clock"></i> 2025-10-27</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k0"> Troubleshooting PostgreSQL Logical Replication, Working with LSNs</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Robert Bernier</li> <li><i class="far fa-clock"></i> 2025-10-27</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k5"> Slonik on the Catwalk: PGConf.EU 2025 Recap</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Mayur B.</li> <li><i class="far fa-clock"></i> 2025-10-27</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7k1"> Returning Multiple Rows with Postgres Extensions</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Shaun Thomas</li> <li><i class="far fa-clock"></i> 2025-10-27</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7j-"> Contributions for week 43, 2025</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Cornelia Biacsics</li> <li><i class="far fa-clock"></i> 2025-10-26</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7ju"> Temporal Joins</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Christopher Winslett</li> <li><i class="far fa-clock"></i> 2025-10-24</li> </ul> </div> </div> <div class="col-md-4"> <div class="text-center"> <h3><a href="https://postgr.es/p/7jn"> Loading The Titanic Passenger Data Into PostgreSQL With DBeaver Part 2</a></h3> <ul class="meta"> <li><i class="far fa-comments"></i> Dave Stokes</li> <li><i class="far fa-clock"></i> 2025-10-22</li> </ul> </div> </div> </div> <!-- END First Row Planet PostgreSQL --> <div class="row"> <div class="col-sm-12"> <a href="https://planet.postgresql.org" title="Browse Archives" target="_blank" rel="noopener"><button type="button" class="btn btn-center btn-primary">Browse Archives</button></a> </div> </div> </div> <!-- SUBMIT A BUG --> <div class="container-fluid"> <div class="row"> <div class="col-lg-6 cta-text"> <h2>Seeing unexpected behavior?</h2> <p> The PostgreSQL community takes pride in releasing software that reliably stores your data. If you believe you've discovered a bug, please click the button below and follow the instructions on how to submit a bug. </p> <a href="/account/submitbug/" title="Submit a Bug"><button type="button" class="btn btn-light btn-rounded">Submit a Bug</button></a> </div> <div class="col-lg-6 cta cta-2"></div> </div> </div> <!-- END SUBMIT A BUG --> <!-- Footer --> <footer id="footer"> <!-- Copyright --> <div class="container"> <a href="/about/policies/">Policies</a> | <a href="/about/policies/coc/">Code of Conduct</a> | <a href="/about/">About PostgreSQL</a> | <a href="/about/contact/">Contact</a><br/> <p>Copyright © 1996-2025 The PostgreSQL Global Development Group</p> </div> </footer> <script src="/media/js/main.js?e54c1eb0"></script> </body></html> 
