原文：https://en.wikipedia.org/wiki/PostgreSQL
发布历史
Release history
| Release | First release | Latest minor version | Latest release | End of life[154] | Milestones |
|---|---|---|---|---|---|
| 6.0 | 1997-01-29 | — | — | — | First formal release of PostgreSQL, unique indexes, pg_dumpall utility, ident authentication |
| 6.1 | 1997-06-08 | 6.1.1 | 1997-07-22 | — | Multicolumn indexes, sequences, money data type, GEQO (GEnetic Query Optimizer) |
| 6.2 | 1997-10-02 | 6.2.1 | 1997-10-17 | — | JDBC interface, triggers, server programming interface, constraints |
| 6.3 | 1998-03-01 | 6.3.2 | 1998-04-07 | 2003-03-01 | SQL-92 subselect ability, PL/pgTCL |
| 6.4 | 1998-10-30 | 6.4.2 | 1998-12-20 | 2003-10-30 | VIEWs (then only read-only) and RULEs, PL/pgSQL |
| 6.5 | 1999-06-09 | 6.5.3 | 1999-10-13 | 2004-06-09 | MVCC, temporary tables, more SQL statement support (CASE, INTERSECT, and EXCEPT) |
| 7.0 | 2000-05-08 | 7.0.3 | 2000-11-11 | 2004-05-08 | Foreign keys, SQL-92 syntax for joins |
| 7.1 | 2001-04-13 | 7.1.3 | 2001-08-15 | 2006-04-13 | Write-ahead log, outer joins |
| 7.2 | 2002-02-04 | 7.2.8 | 2005-05-09 | 2007-02-04 | PL/Python, OIDs no longer required, internationalization of messages |
| 7.3 | 2002-11-27 | 7.3.21 | 2008-01-07 | 2007-11-27 | Schema, table function, prepared query[155] |
| 7.4 | 2003-11-17 | 7.4.30 | 2010-10-04 | 2010-10-01 | Optimization on JOINs and data warehouse functions[156] |
| 8.0 | 2005-01-19 | 8.0.26 | 2010-10-04 | 2010-10-01 | Native server on Microsoft Windows, savepoints, tablespaces, point-in-time recovery[157] |
| 8.1 | 2005-11-08 | 8.1.23 | 2010-12-16 | 2010-11-08 | Performance optimization, two-phase commit, table partitioning, index bitmap scan, shared row locking, roles |
| 8.2 | 2006-12-05 | 8.2.23 | 2011-12-05 | 2011-12-05 | Performance optimization, online index builds, advisory locks, warm standby[158] |
| 8.3 | 2008-02-04 | 8.3.23 | 2013-02-07 | 2013-02-07 | Heap-only tuples, full text search,[159] SQL/XML, ENUM types, UUID types |
| 8.4 | 2009-07-01 | 8.4.22 | 2014-07-24 | 2014-07-24 | Window functions, column-level permissions, parallel database restore, per-database collation, common table expressions and recursive queries[160] |
| 9.0 | 2010-09-20 | 9.0.23 | 2015-10-08 | 2015-10-08 | Built-in binary streaming replication, hot standby, in-place upgrade ability, 64-bit Windows[161] |
| 9.1 | 2011-09-12 | 9.1.24 | 2016-10-27 | 2016-10-27 | Synchronous replication, per-column collations, unlogged tables, serializable snapshot isolation, writeable common table expressions, SELinux integration, extensions, foreign tables[162] |
| 9.2 | 2012-09-10[163] | 9.2.24 | 2017-11-09 | 2017-11-09 | Cascading streaming replication, index-only scans, native JSON support, improved lock management, range types, pg_receivexlog tool, space-partitioned GiST indexes |
| 9.3 | 2013-09-09 | 9.3.25 | 2018-11-08 | 2018-11-08 | Custom background workers, data checksums, dedicated JSON operators, LATERAL JOIN, faster pg_dump, new pg_isready server monitoring tool, trigger features, view features, writeable foreign tables, materialized views, replication improvements |
| 9.4 | 2014-12-18 | 9.4.26 | 2020-02-13 | 2020-02-13 | JSONB data type, ALTER SYSTEM statement for changing config values, ability to refresh materialized views without blocking reads, dynamic registration/start/stop of background worker processes, Logical Decoding API, GiN index improvements, Linux huge page support, database cache reloading via pg_prewarm, reintroducing Hstore as the column type of choice for document-style data.[164] |
| 9.5 | 2016-01-07 | 9.5.25 | 2021-02-11 | 2021-02-11 | UPSERT, row level security, TABLESAMPLE, CUBE/ROLLUP, GROUPING SETS, and new BRIN index[165] |
| 9.6 | 2016-09-29 | 9.6.24 | 2021-11-11 | 2021-11-11 | Parallel query support, PostgreSQL foreign data wrapper (FDW) improvements with sort/join pushdown, multiple synchronous standbys, faster vacuuming of large table |
| 10 | 2017-10-05 | 10.23 | 2022-11-10 | 2022-11-10 | Logical replication,[166] declarative table partitioning, improved query parallelism |
| 11 | 2018-10-18 | 11.22 | 2023-11-09 | 2023-11-09 | Increased robustness and performance for partitioning, transactions supported in stored procedures, enhanced abilities for query parallelism, just-in-time (JIT) compiling for expressions[167][168] |
| 12 | 2019-10-03 | 12.21 | 2024-11-14 | 2024-11-14 | Improvements to query performance and space utilization; SQL/JSON path expression support; generated columns; improvements to internationalization, and authentication; new pluggable table storage interface.[169] |
| 13 | 2020-09-24 | 13.17 | 2024-11-14 | 2025-11-13 | 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[170][171] |
| 14 | 2021-09-30 | 14.14 | 2024-11-14 | 2026-11-12 | Added SQL-standard SEARCH and CYCLE clauses for common table expressions, allow DISTINCT to be added to GROUP BY[172][173] |
| 15 | 2022-10-13 | 15.9 | 2024-11-14 | 2027-11-11 | Implements SQL-standard MERGE statement. PL/Python now only supports current Python 3, and plpythonu now means Python 3, no longer the discontinued Python 2. |
| 16 | 2023-09-14 | 16.5 | 2024-11-14 | 2028-11-09 | Improvements to logical replication, pg_stat_io view (for I/O metrics)[174] |
| 17 | 2024-09-26 | 17.1 | 2024-11-14 | 2029-11-08 | Performance boosts to the vacuum process, I/O layer, and query execution, expanding JSON functionality, more features to MERGE and improving COPY; enhances logical replication for high availability and upgrades, improvements to security, operations, monitoring, and analysis.[175] |
参考
https://en.wikipedia.org/wiki/PostgreSQL
