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

See also

• PostgreSQL: pg_dump, pg_restore, pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB, Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user, createdb, GRANT, pg_stat, PostgreSQL VACUUM, EXPLAIN, pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL), EXPLAIN ANALYZE, Bitmap scan, EXPLAIN VERBOSE, EXPLAIN VERBOSE (PostgresSQL), WAL, ALTER USER, CREATE ROLE, CREATE USER, \du, show users, \l, The Statistics Collector, pganalyze, cron.schedule, Master, pg_tables, PostgreSQL replication, CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs

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