PostgreSQL versions/releases

https://en.wikipedia.org/wiki/PostgreSQL#Release_history

Releases (yearly)

PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history

• October 2021 PostgreSQL 14.0
  • Azure
  • GRANT pg_read_all_data TO xxx;

• October 2020 PostgreSQL 13.0 https://www.postgresql.org/docs/release/13.0/
  • Space savings and performance gains from de-duplication of B-tree index entries
  • Improved performance for queries that use aggregates or partitioned tables
  • Better query planning when using extended statistics
  • Parallelized vacuuming of indexes

Incremental sorting

• October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/
  • Ubuntu 20.04 LTS
• October 2018 PostgreSQL 11.0 https://www.postgresql.org/about/news/1894/, https://www.postgresql.org/docs/release/11.0/
• October 2017 PostgreSQL 10.0 https://www.postgresql.org/docs/release/10.0/ (Ubuntu 18.04 LTS (BionicBeaver))
• October 2010 PostgreSQL 9.0 https://www.postgresql.org/docs/release/9.0/
  • November 2010 PostgreSQL 9.1 https://www.postgresql.org/docs/release/9.1/
  • December 2010 PostgreSQL 9.2 https://www.postgresql.org/docs/release/9.2/
    • January 2011 PostgreSQL 9.3 https://www.postgresql.org/docs/release/9.3/
    • April 2011 PostgreSQL 9.4 https://www.postgresql.org/docs/release/9.4/
    • 2016-01-07 PostgreSQL 9.5 https://www.postgresql.org/docs/release/9.5/
    • 2016-09-29 PostgreSQL 9.6 https://www.postgresql.org/docs/release/9.6/

Related

• pg_upgradecluster
• MariaDB changelog
• AWS RDS for PostgreSQL release notes
• /etc/postgresql/
• brew install postgresql

See also

• PostgreSQL versions/releases, /etc/postgresql/

https://www.postgresql.org/about/news/postgresql-96-released-1703/