Release Notes: There are several major new features in this release, including synchronous replication and other replication features, per-column collations, unlogged tables, extensions, K-Nearest-Neighbor indexing, Serializable Snapshot Isolation, Writeable Common Table Expressions, SE-Postgres (Military-grade security), the PostgreSQL Extension Network, and SQL/MED (Management of External Data), with foreign data wrappers for Oracle, MySQL, CouchDB, Redis, CSV, Twitter, and more. There have also been improvements in performance and database administration, and several SQL and PL/PgSQL features.
Release Notes: Improves concurrent access to the shared buffer cache. Allows index scans to use an intermediate in-memory bitmap. Two-phase commit has been added. Creates a new role system that replaces users and groups. Automatically uses indexes for MIN() and MAX(). Adds shared row level locks using SELECT ... FOR SHARE. Adds dependencies on shared objects, specifically roles. Improves performance for partitioned tables.
Release Notes: This release features native support for Win32, savepoints, point in time recovery, tablespaces, overhauled buffer management for better performance and scalability, the ability to change the type of a column via ALTER TABLE, and much more.
Release Notes: Several very large features are included in this release. The aim is for this release to be as rock solid as possible, but at least one of the features added involved such changes that may warrant a bit of extra testing post-release before deploying it in production.
Release Notes: GROUP BY processing has been improved by using hash buckets. There is a new multikey hash join capability. Queries using the explicit JOIN syntax are now better optimized. There is faster and more powerful regular expression code, full support for IPv6 connections and IPv6 address data types, and major improvements in SSL performance and reliability. The free space map efficiently reuses empty index pages. There is an SQL-standard information schema, a new client-to-server protocol, a new version of full-text indexing, and a new autovacuum tool. libpq and ECPG applications are now fully thread-safe.
Release Notes: This release completes nearly a year's worth of work. New features include schema support, prepared queries, dependency tracking, improved privileges, table (record) based functions, improved internationalization support, and a whole slew of other new features, fixes, and performance improvements.
No changes have been submitted for this release.
Release Notes: In this release, vacuuming no longer locks tables, there is no longer a problem with installations that exceed four billion transactions, OIDs are now optional, a new MD5 encryption option allows more secure storage and transfer of passwords, and program and library messages can now be displayed in several languages.
Release Notes: There is no longer a problem with installations that exceed four billion transactions. OID's are now optional. The optimizer now computes histogram column statistics during ANALYZE. A new MD5 encryption option allows much more secure storage and transfer of passwords. A new Unix-domain socket authentication option is available on Linux and *BSD systems, and a new table access statistics module to get fine-grained information about table and index usage was added.
Release Notes: Quite a few bugfixes, updates, and new features.