PostgreSQL updates PostgreSQL 8.4

BANGALORE, INDIA: The PostgreSQL Global Development Group has recently released version 8.4 of open source database.

"Our development team has spent 16 months adding over two hundred improvements to all aspects of database functionality, helping every PostgreSQL user in small or large ways," said a spokesperson from PostgreSQL.

Many of the changes in PostgreSQL 8.4 are new or improved administration and monitoring tools and commands. Each user has their own favorite features which will make work with PostgreSQL easier and more productive for them added the release.

Among the most popular enhancements are:

* Parallel Database Restore, speeding up recovery from backup up to 8 times

* Per-Column Permissions, allowing more granular control of sensitive data

* Per-database Collation Support, making PostgreSQL more useful in multi-lingual environments

* In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to 8.4 without extensive downtime

* New Query Monitoring Tools, giving administrators more insight into query activity

* Greatly Reduced VACUUM Overhead through the Visibility Map

* New Monitoring Tools for current queries, query load and deadlocks

Version 8.4 also makes data analysis easier through the advanced ANSI SQL2003 features of windowing functions, common table expressions and recursive queries. Enhancements to stored procedures, such as default parameters and variadic parameters, make database server programming simpler and more compact.