Postgres Plus® White Papers and Data Sheets

EnterpriseDB promotes community education through a vibrant ecosystem of solutions, industry thought leaders, partners and customers. Below you will find white papers that provide context and practices for using Postgres Plus open source database products and data sheets that provide helpful details on EnterpriseDB's products, services and partner programs.

Postgres Overviews

Which Postgres is Right for Me?

Discover the differences between PostgreSQL, Postgres Plus Standard Server and Postgres Plus Advanced Server and optimize your choice of open source database. You'll learn enough about the different capabilities, modules, and uses for each product to make the best Postgres choice for your organization.

Postgres Plus Technical Evaluation Guide

This document outlines common approaches and topics to evaluating open source databases in general and Postgres Plus databases in particular. In includes links to multiple assets designed to inform you of all aspects of evaluating an open source database.

Beyond PostgreSQL: A Look Inside Postgres Plus Advanced Server

While EnterpriseDB's Postgres Plus Advanced Server is built upon the rock-solid PostgreSQL foundation, it delivers many significant value-added features and add-on products not available in the community edition.

Web 2.0 Database Strategies: New Applications Need New Architectures

The objective of this white paper is to help you determine whether to adopt an open source database as part of your IT infrastructure. Further, the paper explores three adoption strategies IT organizations are using successfully today.

What's New in Postgres Plus Advanced Server v9

This short paper covers all the new features in Advanced Server including: SQL Profiler, Index Advisor, Streaming Replication, Hot Standby, Replication from Microsoft SQL Server, Upgrade In Place, new development and object capabilities, Oracle enhancements, high speed loader improvements, partitioning scripts, and Infinite Cache with dynamic management.

Effectively Managing Postgres in the Enterprise

Research shows the typical DBA is responsible for an average of 35 databases with the trend only moving upward. Recognizing this issue, EnterpriseDB has introduced the first enterprise-architected management tool for DBAs who are looking to widely adopt Postgres in their enterprise and desire the same type of management capabilities they get from tools that are included from other database vendors that they work with. This whitepaper describes this solution – Postgres Enterprise Manager – in detail and focuses on how data management professionals will benefit from the enterprise-class capabilities supplied by the tool.

A Cloud-Ready Enterprise Database Checklist

A recent study done by the IT industry analyst group IDC found that, while cloud computing accounts for less than 2% of IT spending today, it’s estimated that by 2015 nearly 20% of all information will be "touched" and enabled by cloud computing environments. IDC believes that as much as 10% of all data will be maintained in a cloud by 2015.

This equates to large volumes of data being stored in the cloud, with much of it being offered in a database-as-a-service (DBaaS) fashion. The data volumes stored in the cloud will likely be enormous, considering that IDC predicts a 50X data growth multiple in the next decade.

Modern businesses are looking to both public and private clouds as enablers for their database management systems. However, many admit that they struggle with selecting the database provider(s) to utilize in their move to cloud computing and what features they need in order to benefit from such a move. This paper examines the question of what constitutes an enterprise-class database that takes advantage of the various benefits of cloud computing environments.

Postgres and Oracle Compatibility

A Manager's Guide to Oracle Cost Containment

This paper identifies popular Oracle cost containment strategies and provides helpful case studies that illustrate how Oracle costs are being managed in the field today at Sony Online Entertainment and FTD florists.

Delivering Oracle® Compatibility: An EnterpriseDB White Paper

Take a high-level tour through the five main areas of Oracle Compatibility built into Postgres Plus Advanced Server. For a more detailed document, download the Oracle Compatibility Developer's Guide.

Oracle® Database Migration: Pitfalls and Promise

Read why past migration tools and strategies fail and why it is still so difficult for organizations to move from one database technology to another. This discussion is followed by a brief review of EntepriseDB's revolutionary compatibility software and an actual migration walk-through using EnterpriseDB's unique Oracle Migration tools.

Oracle® Compatibility Developer's Guide

This guide describes the Oracle compatibility features of Postgres Plus Advanced Server 9.1. It is the definitive reference for all the Oracle supported features.

Cost Containment Strategies for Oracle Database Users

While many enterprises have been able to wring out significant cost savings by migrating to open source software for operating systems and middleware, there has been a reluctance to extend to the database layer due to concerns about complexity, risk and operational pain of migration. This paper will provide best practices for migrating Oracle applications to lower cost PostgreSQL alternatives; quantifying and mitigating associated risks; and reducing the operational pain associated with migration.

Postgres Technical Topics

Breaking the Scalability Barrier with Infinite Cache

This white paper describes the Infinite Cache architecture, how it works, the details of key features, monitoring statistics, and performance test results.

EnterpriseDB Engineering Study: Performance Benchmarking

EnterpriseDB engineers put three databases through rigorous performance benchmarking. Using the open source benchmark, BenchmarkSQL, EnterpriseDB engineers compare EnterpriseDB with MySQL and a popular proprietary database.

High Availability Database Solutions for PostgreSQL and Postgres Plus

This paper discusses the failover and redundancy capabilities of specific high availability products that can be used in conjunction with PostgreSQL, Postgres Plus, and the Oracle-compatible database Postgres Plus Advanced Server.

Postgres Plus and JBoss®: New Division of Labor for New Enterprise Applications

Traditional Web and enterprise application architectures leverage JBoss extensively to service compute-, display- and data-intensive operations. But Web 2.0 and other advanced applications require much higher volumes of transactional data, and their scaling requirements are indeterminate. This paper suggests a rebalancing of responsibilities between JBoss and Postgres Plus.

Protecting PostgreSQL from SQL Injection Attacks

A number of recent high profile SQL injection attacks against prominent organizations have reminded data management professionals how quickly a serious data breach can happen and the consequences that come with being a victim. This white paper shows how SQL/Protect can create a SQL firewall for your PostgreSQL database.

Why Use xDB Replication Server from EnterpriseDB

The use cases of replication can be many, however the core reasons that replication is used are the following: simple backup, sharded or read scale-out architecture, business intelligence / reporting, and simple high availability. This paper provides an overview of EnterpriseDB’s xDB Replication Server, describes how the solution functions, and then looks at the question of why the xDB Replication Server should be considered over the built-in replication functionality offered in PostgreSQL 9.0 and above.

Getting Started with Postgres Plus Advanced Server on HP-UX

This document provides an introduction to Postgres Plus Advanced Server on HP-UX and is designed to acquaint you with the basics of how to be successful in your deployment of the database. It serves as a help aid to get you up to speed with the basics of the database server and provides links to documentation resources that will give you much more detail in each area that is covered. Topics covered include: Installation, Configuration, database interfaces/utilities/tools, Managing Security, Storage Management, Tables and Indexes, Loading data, Development Basics, Replication, Backup and Recovery, Performance Tuning, Migrating from other databases and more.

Postgres and MySQL

A Visual Guide for Migrating MySQL® to Postgres Plus

This paper contrasts MySQL and Postgres Plus products from EnterpriseDB detailing the business and technical reasons for migrating from MySQL to Postgres Plus. The paper also shows a sample migration using the MySQL Migration Wizard from EnterpriseDB and concludes with multiple strategies for moving large amounts of MySQL data to Postgres Plus.

A Comparison between MySQL and PostgreSQL Replication

Replication is not restricted to only the major proprietary databases; open source databases such as Oracle’s MySQL and PostgreSQL also offer built-in replication as a feature. With recent releases of MySQL 5.5 and PostgreSQL 9.0, questions are being asked about how they differ in their replication technologies.

Postgres Plus 9.0 vs. MySQL® 5.5: Comparison and Commentary

This paper provides an extensive feature by feature comparison between Postgres Plus Standard and Advanced Servers v9.0 against MySQL v5.5 including the InnoDB storage engine. Each section is followed with commentary.