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.

"We were able to get up and running in record time,
delivering a fully resilient, enterprise class implementation to our clients."
Richard Clark, Director of Technology, BrightGen Ltd.

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

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.

Learn more about EnterpriseDB's Consulting services.

What Should I Do Now?

To purchase any services mentioned on this page, call +1 781-357-3390   or  1-877-377-4352 (US Only) today!

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 PostgreSQL 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 PostgreSQL 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 educational content for technologists about creating and deploying high performance PostgreSQL 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.