Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

PostgreSQL 8.4 is out

finally recursive sql statements

7:33 am on Jul 3, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:Sept 30, 2005
votes: 0

Nice new features copy-paste from there release notes:

* 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

For me personally my favorite new feature is the use of WITH RECURSIVE!
(also the fact that there is no potential of being owned by Oracle is a big + compared to MySQL)