End Point

News

Welcome to End Point's blog

Ongoing observations by End Point people.

PostgreSQL 8.1 Shows Database Progress

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).
  • Temporary views.

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.