EnterpriseDB's Postgres Plus Advanced Server 9.1 ships
PostgreSQL specialists EnterpriseDB have announced the general availability of Postgres Plus Advanced Server 9.1, the latest edition of their enhanced version of the open source PostgreSQL database. It builds upon September 2011's release of PostgreSQL and brings features introduced then to EnterpriseDB's commercial edition. This includes synchronous replication, where the master database will wait until at least one slave database has written the replicated transaction to disk before continuing, and unlogged tables, where tables that need higher performance but less reliability can skip writing transaction logs.
EnterpriseDB enhancements include improved read management, which improves performance on read-only workloads or systems with more CPUs, and improved write scalability, with a new lock manager and avoidance allowing the database to utilise 32 or more processor cores. There are the usual differences between the Postgres Plus Advance Server and PostgeSQL, for example, the advanced server comes with .NET client support (Npgsql), distributed caching, pgSQL debugger and Oracle compatibility. The company has improved its Oracle compatibility in 9.1, with a "Virtual Private Database" which offers row level security policies allowing many users and roles to access centralised tabled securely and correctly.
Postgres Plus Advanced Server 9.1 subscriptions start at $4,395 per annum for a single support contract for a one socket server with 1 day response. Postgres Plus Advanced Server 9.1 is available to download, for 32-bit and 64-bit Windows and Linux x86, Solaris SPARC, Solaris X86-64 and HP-UX, as an evaluation under a limited use licence. EnterpriseDB also offer binary downloads of PostgreSQL 9.1; the most recent source for the database is available from PostgreSQL.org.