EnterpriseDB (EDB) has announced new versions of its flagship database and enterprise-class management console – Postgres Plus Advanced Server 9.3 and Postgres Enterprise Manager 4.0, respectively. The company also announced a new product, EDB Failover Manager, a critical component for meeting enterprise High Availability requirements.

Working with its largest customers, EDB develops new features, capabilities and products targeting the needs and requirements of the global enterprise.

EDB is the largest Postgres software and services provider with enterprise-class software, professional services, support and training to ensure success with Postgres as organisations expand their deployments of open source software to the data center. More than 2,000 enterprises, government agencies and other organisations worldwide use EnterpriseDB products and services to successfully deploy Postgres, reduce their reliance on costly traditional databases and slash database costs by more than 80 percent.

Postgres Plus Advanced Server

Postgres Plus Advanced Server 9.3 builds upon community PostgreSQL 9.3, which was released in September, and includes the important new features for better handling NoSQL-like applications, such as expanded JSON support.

Among the advances EDB has developed for Postgres Plus Advanced Server 9.3 are:

· Major performance improvements in partitioning expand the workloads that Postgres Plus Advanced Server is capable of handling, including large datasets that require scaling to hundreds and even thousands of table partitions. In read-only (SELECT) tests, Postgres Plus Advanced Server 9.3 performed 75 times faster than Postgres Plus Advanced Server 9.2 version. INSERT tests for a million rows across 1000 partitions showed over 400 percent improvement.

· The introduction of materialised views significantly improves the performance of resource-intensive queries, allowing database administrators (DBAs) to pre-select and pre-join commonly requested data and store the results so retrieving the data results in simpler, faster reads.

· New RPM packages ease the installation and maintenance of Postgres Plus Advanced Server for DBAs and the growing number of independent software vendors and systems integrators that are embedding EDB software into their products.

· Enhanced built-in package support speeds application development by saving developers time in coding operations like making HTTP callouts from the database manually. Instead, developers simply call these packages from the application. These packages have been implemented to be compatible with Oracle to ease migration of such applications into Postgres Plus Advanced Server.

EDB Failover Manager

EDB Failover Manager is the company’s newest in a collection of integrated enterprise-class tools. It addresses a gap in the market for a reliable, cost-effective solution to monitor the health of a streaming replication cluster and initiate failover in the event the master database fails.

The new product is critical for meeting high availability demands. It provides fault-tolerant database clusters, which significantly reduce downtime and helps to ensure data remains available and online if the main database fails. EDB Failover Manager provides cluster monitoring, failure detection and failover mechanisms that can be integrated into a variety of stringent High Availability solutions.

Postgres Enterprise Manager

Postgres Enterprise Manager is an enterprise-class tool for managing, monitoring and tuning large Postgres deployments. With Postgres Enterprise Manager, database professionals can easily manage more and larger databases across the enterprise from a single, highly customisable and easy-to-use graphical console.

The new capabilities available in Postgres Enterprise Manager 4.0 include customisable dashboards with the ability to control the look and feel as well as the content of monitoring views. The release also adds a series of new monitoring probes and alerts for Log Files, SQL injection attacks and replication configurations (binary streaming, xDB Replication Server and Slony).

Product Availability

Postgres Plus Advanced Server 9.3 and Postgres Enterprise Manager 4.0 are available now. EDB Failover Manager will be released for general availability on December 9, 2013.