The Group PostgreSQL Global Development has released version 8.4 of the database of open source with advanced features. There are nearly 300 improvements to administration, programming and query language opening up new possibilities with this database.
Some improvements are:
* Restoring the database using parallel processes, accelerating the recovery of a back up to 8 times compared to the previous version.
* Column privileges, to control access to a greater level of detail.
* Language settings and management for database. To be able to select the most appropriate depending on the language that is required.
* Update 8.3 to 8.4 with minimal downtime
* New tools for monitoring consultations, delivering information to managers to know what is happening in the database.
* Implement advanced features of ANSI SQL: 2003 which allow complex queries into a single expression which previously required several.
* Improvements in stored procedures, for example using default parameters in the statement or list of arguments of variable length, the style C + + / Java.
Besides the new features, this new version includes improvements to the strong performance, particularly in complex operations.
While there are other databases of open source with a large base of users as MySQL, PostgreSQL orientation has always been to implement the features that make face to face with advanced databases such as Oracle. In this issue again The project has made it clear what distinguishes PostgreSQL jurisdiction in the world of open source.
Link: via PostgreSQL
