3rd October 2019: PostgreSQL 12 Released!

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

PostgreSQL Elephant Logo

New to PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system with over 30 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 PostgreSQL community provides many helpful places to become familiar with the technology, discover how it works, and find career opportunities. Reach out to the community here.

Latest Releases

2019-10-03 - PostgreSQL 12 Released!

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

PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization. This release provides application developers with new capabilities such as SQL/JSON path expression support, optimizations for how common table expression (WITH) queries are executed, and generated columns.

The PostgreSQL community continues to support the extensibility and robustness of PostgreSQL, with further additions to internationalization, authentication, and providing easier ways to administrate PostgreSQL. This release also introduces the pluggable table storage interface, which allows developers to create their own methods for storing data.

For more information, please see the release notes. Download PostgreSQL 12 here.

  • 12.0 · 2019-10-03 · Notes
  • 11.5 · 2019-08-08 · Notes
  • 10.10 · 2019-08-08 · Notes
  • 9.6.15 · 2019-08-08 · Notes
  • 9.5.19 · 2019-08-08 · Notes
  • 9.4.24 · 2019-08-08 · Notes

Upcoming Events

PostgreSQL Community Event 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 12 Released!

  •  2019-10-03

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

PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization. This release provides application developers with new capabilities such as SQL/JSON path expression support, optimizations for how common table expression (WITH) queries are executed, and generated columns.

The PostgreSQL community continues to support the extensibility and robustness of PostgreSQL, with further additions to internationalization, authentication, and providing easier ways to administrate PostgreSQL. This release also introduces the pluggable table storage interface, which allows developers to create their own methods for storing data.

PLANET POSTGRESQL

New Pg::Explain and explain.depesz.com

  •  Hubert 'depesz' Lubaczewski
  •  2019-11-12

List PostgreSQL tables using extensions

  •  Dimitri Fontaine
  •  2019-11-12

Database Tab Sweep

  •  Colin Charles
  •  2019-11-10

Achieving k-anonymity with PostgreSQL

  •  damien clochard
  •  2019-11-07

pgAdmin3 for PostgreSQL 12.0

  •  Abdul Yadi
  •  2019-11-07

Seeing unexpected behavior?

The PostgreSQL community takes pride in releasing software that will reliably store 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.