Difference between revisions of "PostgreSQL versions/releases"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(71 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]]
 +
** <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
 +
** Improved performance for queries that use [[aggregates]] or [[partitioned tables]]
 +
** Better query planning when using extended statistics
 +
** Parallelized [[vacuuming]] of [[Database index|indexes]]
 +
** 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]]
 
* October 2018 PostgreSQL 11.0 https://www.postgresql.org/about/news/1894/, https://www.postgresql.org/docs/release/11.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/
+
* 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/
 
* 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/
 
** 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/
 
** 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<ref>https://www.postgresql.org/about/news/postgresql-96-released-1703/</ref> https://www.postgresql.org/docs/release/9.6/
 +
 +
== Related ==
 +
* <code>[[pg_upgradecluster]]</code>
 +
* [[MariaDB changelog]]
 +
* [[AWS RDS for PostgreSQL release notes]]
 +
* <code>[[/etc/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 ==
−
* {{PostgreSQL}}
+
* {{PostgreSQL versions}}
−
* {{changelogs}}
 
  
 
[[Category:changelogs]]
 
[[Category:changelogs]]

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


Related[edit]

See also[edit]

  • ↑ https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
  • ↑ https://www.postgresql.org/about/news/postgresql-96-released-1703/
    • Retrieved from "https://www.wikieduonline.com/index.php?title=PostgreSQL_versions/releases&oldid=353759"

    Advertising: