Critical.
Authoritative.
Strategic.
Subscribe to CIO Magazine »

Open source PostgreSQL 9.1 beta released

More options for database administration and fault tolerance

The PostgreSQL open source database project has released the first beta of version 9.1, which its developers say has more new features than appeared with the 9.0 release, including synchronous replication to help prevent data loss.

Version 9.1 beta contains all of the features which will be in the final 9.1 release, which is expected two to four months from now, depending on the rate of testing and bug fixing.

PostgreSQL 9.0 was released in September last year.

New features coming in 9.1 include synchronous replication, which allows administrators to create synchronous standby databases as another option for fault tolerance.

Synchronous replication includes "transaction-controlled synchronous commit", which the developers say is a PostgreSQL innovation.

Another innovation is “serializable snapshot isolation” for “true serializablity” without blocking. This feature supports complex finanical transactions at a high rate of concurrency.

To improve development of spatial applications, new “K-Nearest-Neighbor” indexing has been added allowing an indexed search of “what’s near”.

Also new is integration of third-party extensions through the PostgreSQL Extension Network (PGXN) at: www.pgxn.org.

According to its developers, PostgreSQL has always offered database customisation, but with 9.1 those customisations can be “packaged, managed and upgraded easily”.

Support for per-column collations will multilingual databases, where each column can be a separate language, and unlogged tables will do high-speed writes of ephemeral data.

In another win for DBAs, the new writeable common table expressions support allows executing recursive updates and other data changes in one SQL statement instead of a whole script.

PostgreSQL 9.1 will also allow different types of data sources, like files and other databases, to be attached to it and used like tables.

Security enhanced PostgreSQL now supports full integration of mandatory access control through SELinux systems.

PostgreSQL is online at: PostgreSQL.org.

Follow Rodney Gedda on Twitter: @rodneygedda

Join the CIO Australia group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.

More about: etwork, Linux
References show all

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Users posting comments agree to the CIO comments policy.
Login or register to link comments to your user profile, or you may also post a comment without being logged in.
Related Coverage
Related Whitepapers
Latest Stories
Community Comments
Tags: databases, open source, postgresql
Latest Blog Posts
Whitepapers
  • New Mobility Requires a New Network Strategy
    Computing has gone through several major transitions through the ages, each of which raised the value of the network and dramatically lowered the cost of computing. In the years after its birth in the mainframe era, the computing industry shifted to client/server and then Internet computing. Today, we are beginning yet another major computing revolution: the shift to mobile computing. This revolution already allows us to carry mini computers, called “smartphones,” in our pockets. This shift will drive down the cost of computing even further and drive up the value of the network, forever changing its role in organisations. Read on.
    Learn more »
  • Closing the print security gap - The market landscape for print security
    Today, many organisations continue to rely on printing to support business processes, particularly in the public sector, finance industry and legal profession. Whilst MFPs and printers have improved business productivity, they pose the same security risk as any networked device if left unprotected. With reported data breaches on the rise and growing industry and regulatory requirements around information security, businesses may suffer financial and reputational damage if they ignore the risks of unsecured printing. Read more.
    Learn more »
  • Stella Travel Services embarks on a strategic refresh of print operations
    Stella Travel Services embraces Managed Print Services (MPS) to deliver savings, centralise and consolidate print operations in order to gain control of print costs and streamline IT support. Read more.
    Learn more »
All whitepapers
rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments