PostgreSQL 9.1 available for Java hosting clients at JVM Host!Published: 23/01/2012
In reply to high demand from our shared Java hosting clients we upgraded PostgreSQL to 9.1.x version.
cPanel team was expected to include PostgreSQL 9 support at the end of 2011 but no official date was given so we did some
tests and made the upgrade that some of our clients were waiting for.
"PostgreSQL 9.1 provides some of the most advanced enterprise capabilities of any open source database, and is backed by a vibrant and innovative community with proven customer success. PostgreSQL is well positioned for building and running applications in the cloud," said Charles Fan, Sr. VP RD, VMware.
Version 9.1 delivers several features which users have been requesting for years, removing roadblocks to deploying new or ported applications on PostgreSQL. These include:
- Synchronous Replication: enable high-availability with consistency across multiple servers
- Per-Column Collations: support linguistically-correct sorting per database, table or column.
- Unlogged Tables: greatly improves performance for ephemeral data
- K-Nearest-Neighbor Indexing: index on "distance" for faster location and text-search queries
- Serializable Snapshot Isolation: keeps concurrent transactions consistent without blocking, using "true serializability"
- Writeable Common Table Expressions: execute complex multi-stage data updates in a single query
- Security-Enhanced Postgres: deploy military-grade security and Mandatory Access Control
- Foreign Data Wrappers: attach and query other databases from PostgreSQL
- Extensions: easily create, load, and manage new database features