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: This beta release fixes numerous issues discovered in the previous betas, as well as documentation improvements and general polish
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 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.
Release Notes: This version fixes many small bugs found since 7.3.2 was released, and has improvements to the JDBC driver.