Postgres Database Tuning and Scaling

Most large-scale production database infrastructures involve multiple servers, multiple cores per CPU, gigabytes of memory and terabytes of disk storage. Databases deployed to serve specific applications and user communities frequently evolve into much larger, more strategic resources servicing numerous applications and multiple end user populations. DBAs and IT managers are continually challenged to meet application performance expectations in the face of this increasing demand, and to scale that performance reasonably as database usage evolves.

PostgreSQL Performance Tuning

Our Performance Tuning Wizard utilizes elements of EnterpriseDB's Dynatune technology, featured in Postgres Plus Advanced Server, to help configure your PostgreSQL server for the workload of your choosing on your hardware.

To install this application within PostgreSQL, download it here or select the 'Application Stack Builder' menu option from the PostgreSQL 8.3 menu on your Windows server, and follow the wizard to choose, download and install the package.

Performance Optimization in Postgres Plus Advanced Server

At its core, Postgres Plus Advanced Server leverages the renowned performance and scaling features of PostgreSQL. In addition, Advanced Server provides value-added capabilities needed by many production databases and applications, including:

• Dynamic Tuning and Workload Profiling - continuously tune Advanced Server databases based on available hardware and application usage profiles
• Integrated Connection Management - makes intelligent use of existing database connections, thereby reducing overhead and improving system throughput
• In-Memory Distributed Caching - enables database applications to use a massive grid of memory cache distributed across multiple servers and abstracted from the database
• GridSQL^® Parallel Query - enables near linear scalability for data warehousing and business intelligence applications

Learn more about Postgres Plus Advanced Server.

Architectural Health Check Service (AHC)

AHC, EnterpriseDB's most popular packaged service, delivers a three-day, comprehensive review of your PostgreSQL or Postgres Plus database environment. During the AHC review, EnterpriseDB experts analyze database configuration parameters, hardware and operating system resources, and application type and data usage patterns. Following the review, we provide you with high-impact recommendations on how to configure, tune and optimize your database.

Learn more about EnterpriseDB's Architectural Health Check service.

Partitioning Setup Service

EnterpriseDB's partitioning Setup service is specifically designed to help create effective partitioning strategies for their large Postgres databases. Using best practice templates, EnterpriseDB experts evaluate database volumes and types, transaction and query profiles, application response time requirements and other factors critical to large database operation. Our objective in this analysis is to develop an effective partitioning strategy - which may include a combination of horizontal and vertical partitioning - and work side-by-side with your DBAs to carefully vet our recommendations. Once approved, we work with your team to implement that strategy by leveraging PostgreSQL's robust partitioning capabilities. The results: improved database manageability, performance and availability. Best of all, your DBAs and application developers are equipped to operate your partitioned database right out of the blocks.

Learn more about EnterpriseDB's Partitioning Setup service.

What Should I Do Now?

Depending on your business needs and timing considerations, we recommend the following next steps:

Contact us directly. This is the fastest and easiest way to learn more. Our sales engineering team can help you determine the quickest path to optimizing your Postgres databases.

Download and evaluate Postgres Plus Advanced Server. By evaluating our software, your technologists can quickly determine the depth of our Oracle^® compatibility and the completeness of our Postgres database foundation.

Below are resources that will help IT managers learn more about how organizations are leveraging EnterpriseDB's performance tuning and scaling solutions today, as well as edu cational content for technologists about creating and deploying high performance Postgres databases.

IT Managers		DBAs, Architects, and Developers
	EnterpriseDB Engineering Study: Performance Benchmarking This white paper, written by the EnterpriseDB engineering team, uses a popular RDBMS benchmark suite to compare the performance of Postgres Plus Advanced Server, MySQL® and a popular proprietary database product.		PostgreSQL Performance Tuning Bruce Momjian discusses every aspect of performance including server settings, problem queries and more.
	hi5 Networks Case Study Learn how hi5 Networks, the leading social network in more than 25 countries with over 80 million registered users, dramatically improved application scalability and performance by leveraging EnterpriseDB's packaged services and expert consulting.		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.
	FortiusOne Case Study Learn how FortiusOne, the leading social network in more than 25 countries with over 80 million registered users, dramatically improved application scalability and performance by leveraging EnterpriseDB's packaged services and expert consulting.		Postgres Plus and JBoss®: New Division of Labor for Enterprise Applications This EnterpriseDB white paper discusses performance and scalability strategies available to organizations deploying a highly popular open source OLTP stack - JBoss and Postgres.
	The Top 5 Ways to Supercharge Your Database 5 simple ways to supercharge your Postgres Plus and PostgreSQL databases to gain the best performance.