PostgreSQL Performance Management

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

Postgres Enterprise Manager contains a variety of tools to help you perfect your PostgreSQL performance. Performance dashboards use multiple data probes to report back on the performance of the underlying operating system as well as the  database. Armed with charts and tables of data you can accurately pin point sensitive times or processes causing issues.  Postgres Expert is a DBA-in-a-box that detects best practice deviations in database configuration parameters, schema design, and security profiles of your Postgres installations and then provides recommended settings based on best practices.  Index Advisor recommends and/or deploys new single or composite table indexes based on specific troublesome queries you feed it.  The SQL Profiler captures complex SQL workloads on-demand or on-schedule overnight and allows multiple views of performance data to quickly find resource hogging queries in need of improvement.  Postgres Enterprise Manager is included in a Standard Edition database subscription for PostgreSQL.

Performance Optimization in Postgres Plus Advanced Server

A database subscription for Postgres Plus Advanced Server also includes Postgres Enterprise Manager and all its performance tools. In addition, Advanced Server comes with additional built-in database features designed to boost application performance.  Query optimizer hints allow developers and DBAs to alter execution plans chosen by the optimizer because they may know information about their data that the optimizer does not know - for instance that a particular index is better for certain queries. Optimized table partitioning that performs well into thousands of partitions.  Infinite Cache expands the in-memory database cache across commodity hardware blades for blazing performance with read mostly applications. Developer tools for faster data processing include: special array handling constructs, user defined object types, and pre-defined re-usable function packages.

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.

The Top 5 Ways to Supercharge Your Database

5 simple ways to supercharge your Postgres Plus and PostgreSQL databases to gain the best performance.

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.

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.