All releases tagged Stable
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: Built-in replication based on log shipping. Easier database object permissions management. pg_upgrade to support in-place upgrades. Multiple performance enhancements for specific types of queries. Full support for 64-bit Windows.
Release Notes: pg_get_ruledef() now parenthesizes negative constants. ALTER AGGREGATE ... OWNER TO was made to update pg_shdepend.
Release Notes: A privilege escalation exploit in SECURITY DEFINER functions was patched.
Release Notes: The server has been changed to reject invalidly-encoded multi-byte characters in all cases. This release rejects unsafe uses of \' in string literals. libpq's string-escaping routines have been modified to be aware of encoding considerations and standard_conforming_strings.
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 includes a new, patent-free buffer replacement policy (2Q) that replaces a patent-pending algorithm from IBM (ARC). Write performance on Windows has been significantly improved. The major version number of the libpq library has been incremented, and a number of bugs have been fixed.
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: 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 addresses a potentially serious (although rare) server startup failure that was recently reported. It is critical for users of PostgreSQL version 7.3.3, and highly recommended for all other PostgreSQL users.
