PostgreSQL 里程碑

郑全

Release First release Latest minor version Latest release Milestones
0.01 1995-05-01 0.03 1995-07-21 Initial release as Postgres95
1.0 1995-09-05
1.09 1996-11-04 Changed copyright to a more liberal license
6.0 1997-01-29 — Name change from Postgres95 to PostgreSQL, unique indexes, pg_dumpall utility, ident authentication.
6.1 1997-06-08 6.1.1 1997-07-22 Multi-column 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 SQL92 subselect capability, PL/pgTCL
6.4 1998-10-30 6.4.2 1998-12-20 VIEWs and RULEs, PL/pgSQL
6.5 1999-06-09 6.5.3 1999-10-13 MVCC, temporary tables, more SQL statement support (CASE, INTERSECT, and EXCEPT)
7.0 2000-05-08 7.0.3 2000-11-11 Foreign keys, SQL92 syntax for joins
7.1 2001-04-13 7.1.3 2001-08-15 Write-ahead log, Outer joins
7.2 2002-02-04 7.2.8 2005-05-09 PL/Python, OIDs no longer required, internationalization of messages
7.3 2002-11-27 7.3.21 2008-01-07 Schema, Internationalization
7.4 2003-11-17 7.4.30 2010-10-04 Optimization all-round
8.0 2005-01-19 8.0.26 2010-10-04 Native server on Microsoft Windows, savepoints, tablespaces, exception handling in functions, point-in-time recovery
8.1 2005-11-08 8.1.23 2010-12-16 Performance optimization, two-phase commit, table partitioning, index bitmap scan, shared row locking, roles
8.2 2006-12-05 8.2.23 2011-09-26 Performance optimization, online index builds, advisory locks, warm standby
8.3 2008-02-04 8.3.23 2013-02-07 Heap-only tuples, full text search, SQL/XML, ENUM types, UUID types
8.4 2009-07-01 8.4.18 2013-10-10 Windowing functions, default and variadic parameters for functions, column-level permissions, parallel database
restore, per-database collation, common table expressions and recursive queries
PostgreSQL 里程碑
Release First release Latest minor version Latest release Milestones
9.0 2010-09-20 9.0.14 2013-10-10 Built-in binary streaming replication, Hot standby, 64-bit Windows, per-column triggers and conditional trigger
execution, exclusion constraints, anonymous code blocks, named parameters, password rules
9.1 2011-09-12 9.1.10 2013-10-10
Synchronous replication, per-column collations, unlogged tables, k-nearest-neighbor indexing, serializable snapshot
isolation, writeable common table expressions, SE-Linux integration, extensions, SQL/MED attached tables (Foreign
Data Wrappers), triggers on views
9.2 2012-09-10 9.2.5 2013-10-10 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.1 2013-10-10 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, replication improvements