PostgreSQL speeds up database
Version 8.4 offers 300 new features
By Rodney Gedda, Computerworld Australia | Computerworld Australia | Published: 14:05, 03 July 2009
The PostgreSQL project has released a new version of the eponymous open source database, with 300 new features.
Notable enhancements in PostgreSQL version 8.4 include parallel database restore for speeding up recovery from backup (by up to eight times); per-column permissions for more granular control of sensitive data; and per-database collation support to make PostgreSQL more useful in multi-lingual environments. Also new in 8.4 is in-place upgrades through pg_migrator (beta) to enable upgrades from 8.3 to 8.4 without "extensive" downtime and new query monitoring tools to give administrators more insight into query activity.
Kevin Grittner, database administrator for the Wisconsin courts system, said the new release boosts application performance.
Related Articles on Techworld
"Version 8.4 has added several optimisations, such as semi-joins and anti-joins, which provide dramatic improvement in the run time of some of our most demanding queries," Grittner said.
According to the developers, version 8.4 makes data analysis easier through the advanced ANSI SQL2003 features of windowing functions, common table expressions and recursive joins.
Jeffrey Webster, CTO of ZooLoo.com, said: "We've used PostgreSQL for seven years now, and we're really looking forward to many of the features in 8.4, particularly column permissions, per-database locale, partial matches for GIN indexes and user defined exceptions. PostgreSQL has allowed us to grow without sacrificing data integrity."
The OpenStreetMap project is also a PostgreSQL user.
OpenStreetMap system administrator Tom Hughes said when the mapping service was planning the new version of its API, it needed a world-class database that runs well at the scale it needs.
