PostgreSQL 8.1 Shows Database Progress
By Jon Jensen · Monday, November 14, 2005
At End Point we recommend PostgreSQL for most of our database-backed software development due to its powerful features, reliability, speed, and liberal license. On November 8, 2005, PostgreSQL 8.1 was released, and it offers a number of useful new features, including:
Two-phase commit (transactions across distant servers).
Numerous new SQL features (regexp_replace function; indexed MIN and MAX aggregates; SQL-standard quoting; non-blocking SELECT FOR UPDATE, better time zone handling; cross-table DELETE and TRUNCATE).
More powerful in-database functions with mutable function parameters and improved PL/Perl language support (return_next and spi_fetchrow; use strict; return arrays).
Convenient interactive error retry in psql client (coded by End Point's own Greg Sabino Mullane).
Integrated encryption (pgcrypto module for PGP, SHA, AES, and DES encryption functions).
Improved performance (better multiprocessor support; shared row locking; bitmap scan of indexes; ability to use multi-column indexes on single columns in any order).
Easier database administration (autovacuum integration; ROLE replaces USER and GROUP; functions to determine on-disk storage space).
We are consistently pleased with the steady improvements shown by the PostgreSQL Global Development Group and have already begun using this new version in our development.