Welcome to WebmasterWorld Guest from 54.226.194.180

Forum Moderators: open

Message Too Old, No Replies

PostgreSQL 8.4 is out

finally recursive sql statements

     

bwakkie

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

5+ Year Member



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)

[developer.postgresql.org...]

Cheers,
Bastiaan

 

Featured Threads

Hot Threads This Week

Hot Threads This Month