Difference between revisions of "PostgreSQL versions/releases"
Jump to navigation
Jump to search
↑ https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
↑ https://www.postgresql.org/about/news/postgresql-96-released-1703/
| (28 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | https://en.wikipedia.org/wiki/PostgreSQL#Release_history | + | [[PostgreSQL]]: https://en.wikipedia.org/wiki/PostgreSQL#Release_history |
== Releases (yearly) == | == Releases (yearly) == | ||
PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history | PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history | ||
| − | * | + | * Sep 2023 PostgreSQL 16.0 [https://www.postgresql.org/about/news/postgresql-16-released-2715/ annoucement] [https://www.postgresql.org/docs/release/16.0/ Release notes] |
| + | ** Introduces [[logical replication]] | ||
| + | ** <code>[[pg_stat_io]]</code> view for I/O metrics https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-IO-VIEW | ||
| + | ** [[Amazon RDS for PostgreSQL now supports major version 16]] | ||
| − | * | + | * Oct 2022 PostgreSQL 15.0: ([https://www.postgresql.org/docs/release/15.7/ 15.7])[https://www.postgresql.org/about/news/postgresql-15-released-2526/ announcement] [https://www.postgresql.org/docs/release/15.0/ Release notes] |
| + | ** Improved [[Sort]] Performance and [[Compression]] | ||
| + | ** Included SQL standard [[MERGE]] command | ||
| + | ** Additional [[logical replication]] options | ||
| + | ** [[jsonlog]] [[PostgreSQL logging|logging]] | ||
| + | ** <code>[[pg_walinspect]]</code> | ||
| + | ** Revokes the <code>[[CREATE]]</code> permission from all users except a [[database owner]] from the [[public]] (or default) [[schema]] <ref>https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS</ref> | ||
| + | |||
| + | * Oct 2021 PostgreSQL 14.0: [https://www.postgresql.org/docs/release/14.0/ Release notes] | ||
** [[Azure]] | ** [[Azure]] | ||
** <code>GRANT [[pg_read_all_data]] TO xxx;</code> | ** <code>GRANT [[pg_read_all_data]] TO xxx;</code> | ||
| − | * | + | * Oct 2020 [[PostgreSQL 13]].0: [https://www.postgresql.org/docs/release/13.0/ Release notes] |
** Space savings and performance gains from de-duplication of [[B-tree]] index entries | ** Space savings and performance gains from de-duplication of [[B-tree]] index entries | ||
** Improved performance for queries that use [[aggregates]] or [[partitioned tables]] | ** Improved performance for queries that use [[aggregates]] or [[partitioned tables]] | ||
| Line 16: | Line 27: | ||
** Parallelized [[vacuuming]] of [[Database index|indexes]] | ** Parallelized [[vacuuming]] of [[Database index|indexes]] | ||
** Incremental [[sorting]] | ** Incremental [[sorting]] | ||
| + | ** Added <code>[[FORCE]]</code> option to <code>[[DROP DATABASE]]</code> | ||
| + | ** Added <code>[[LOCALE]]</code> option to <code>[[CREATE DATABASE]]</code> | ||
| + | ** [[--quiet]] to [[pg_waldump]] | ||
| + | ** --include-foreign-data to [[pg_dump]] | ||
| + | |||
| + | |||
* October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/ | * October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/ | ||
** [[Ubuntu 20.04 LTS]] | ** [[Ubuntu 20.04 LTS]] | ||
| Line 33: | Line 50: | ||
* [[AWS RDS for PostgreSQL release notes]] | * [[AWS RDS for PostgreSQL release notes]] | ||
* <code>[[/etc/postgresql/]]</code> | * <code>[[/etc/postgresql/]]</code> | ||
| − | * <code>[[brew install postgresql]]</code> | + | * <code>[[brew install postgresql]], [[brew install postgresql@16]]</code> |
| + | * [[Amazon Aurora]] | ||
| + | * [[Using Amazon RDS Blue/Green Deployments for database updates]] | ||
| + | * [[engine version (Terraform resource: aws db instance)|engine_version]] Terraform resource: aws db instance | ||
== See also == | == See also == | ||
Latest revision as of 11:48, 7 November 2024
PostgreSQL: https://en.wikipedia.org/wiki/PostgreSQL#Release_history
Releases (yearly)[edit]
PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history
- Sep 2023 PostgreSQL 16.0 annoucement Release notes
- Oct 2022 PostgreSQL 15.0: (15.7)announcement Release notes
- Improved Sort Performance and Compression
- Included SQL standard MERGE command
- Additional logical replication options
- jsonlog logging
pg_walinspect- Revokes the
CREATEpermission from all users except a database owner from the public (or default) schema [1]
- Oct 2021 PostgreSQL 14.0: Release notes
- Azure
GRANT pg_read_all_data TO xxx;
- Oct 2020 PostgreSQL 13.0: Release notes
- 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
- Added
FORCEoption toDROP DATABASE - Added
LOCALEoption toCREATE DATABASE - --quiet to pg_waldump
- --include-foreign-data to pg_dump
- October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/
- 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[2] https://www.postgresql.org/docs/release/9.6/
Related[edit]
pg_upgradecluster- MariaDB changelog
- AWS RDS for PostgreSQL release notes
/etc/postgresql/brew install postgresql, brew install postgresql@16- Amazon Aurora
- Using Amazon RDS Blue/Green Deployments for database updates
- engine_version Terraform resource: aws db instance
See also[edit]
Advertising:
