PostgreSQL

PostgreSQL: The World's Most Advanced Open Source Relational Database

Download  New to PostgreSQL?
 

New to PostgreSQL?

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.

There is a wealth of information to be found describing how to install and use PostgreSQL through the official documentation. The open source community provides many helpful places to become familiar with PostgreSQL, discover how it works, and find career opportunities. Learn more on how to engage with the community.

   

Latest Releases

2024-09-26 - PostgreSQL 17 Released!

The PostgreSQL Global Development Group today announced the release of PostgreSQL 17, the latest version of the world's most advanced open source database.

PostgreSQL 17 builds on decades of open source development, improving its performance and scalability while adapting to emergent data access and storage patterns. This release of PostgreSQL adds significant overall performance gains, including an overhauled memory management implementation for vacuum, optimizations to storage access and improvements for high concurrency workloads, speedups in bulk loading and exports, and query execution improvements for indexes. PostgreSQL 17 has features that benefit brand new workloads and critical systems alike, such as additions to the developer experience with the SQL/JSON JSON_TABLE command, and enhancements to logical replication that simplify management of high availability workloads and major version upgrades.

For the full list of features in PostgreSQL 17, please review the release notes. You can download PostgreSQL 17 from the download page.

For the full press release and translations of the release announcement, please visit the press kit.

  • 17.0 · 2024-09-26 · Notes
  • 16.4 · 2024-08-08 · Notes
  • 15.8 · 2024-08-08 · Notes
  • 14.13 · 2024-08-08 · Notes
  • 13.16 · 2024-08-08 · Notes
  • 12.20 · 2024-08-08 · Notes
 

Upcoming Events

 indicates that an event is recognised under the community event guidelines and is directly helping the PostgreSQL community.

 

Mailing Lists

The PostgreSQL mailing lists 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.

In order to manage your mailing list subscription, you need a PostgreSQL community account. Signing up is easy and gives you direct access to the global PostgreSQL community.

 
 

Learning Opportunities Ahead

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.

 
 

Latest News

PostgreSQL 17 Released!

The PostgreSQL Global Development Group today announced the release of PostgreSQL 17, the latest version of the world's most advanced open source database.

PostgreSQL 17 builds on decades of open source development, improving its performance and scalability while adapting to emergent data access and storage patterns. This release of PostgreSQL adds significant overall performance gains, including an overhauled memory management implementation for vacuum, optimizations to storage access and improvements for high concurrency workloads, speedups in bulk loading and exports, and query execution improvements for indexes. PostgreSQL 17 has features that benefit brand new workloads and critical systems alike, such as additions to the developer experience with the SQL/JSON JSON_TABLE command, and enhancements to logical replication that simplify management of high availability workloads and major version upgrades.

"PostgreSQL 17 highlights how the global open source community, which drives the development of PostgreSQL, builds enhancements that help users at all stages of their database journey," said Jonathan Katz, a member of the PostgreSQL core team. "Whether it's improvements for operating databases at scale or new features that build on a delightful developer experience, PostgreSQL 17 will enhance your data management experience."

PostgreSQL, an innovative data management system known for its reliability, robustness, and extensibility, benefits from over 25 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes.

 

PLANET POSTGRESQL

What's so great about PostgreSQL v17?

  •  Laurenz Albe 
  •  2024-10-01

Vasilis Ventirozos

  •  Andreas 'ads' Scherbaum 
  •  2024-09-30

Waiting for PostgreSQL 18 – Add temporal PRIMARY KEY and UNIQUE constra

  •  Hubert 'depesz' Lubaczewski 
  •  2024-09-30

PostgreSQL Hacking Workshop - October 2024

  •  Robert Haas 
  •  2024-09-30

Table Access Method: How Data Update is Handled in PostgreSQL

  •  cary huang 
  •  2024-09-27

pgsql_tweaks 0.10.6 released

  •  Stefanie Janine 
  •  2024-09-27

Coming up in Postgres - PostgreSQL 17 and trends and innovations to watch

  •  Amit Kapila 
  •  2024-09-27

pgsql_tweaks 0.10.5 released

  •  Stefanie Janine 
  •  2024-09-26

Using pg_upgrade to Upgrading Your PostgreSQL Cluster on Windows

  •  semab tariq 
  •  2024-09-26

 

Seeing unexpected behavior?

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.