PostgreSQL versions/releases
(Redirected from PostgreSQL 16)
Jump to navigation
Jump to search
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
- Introduces logical replication
pg_stat_io
view for I/O metrics https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-IO-VIEW
- 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
CREATE
permission 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
FORCE
option toDROP DATABASE
- Added
LOCALE
option 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
See also[edit]
Advertising: