Health Check and Tune-up

The FSP Health Check provides clients with an audit of their PostgreSQL, operating system and storage configuration. It is designed to identify potential issues and performance optimisations as well as provide a set of "best practice" guidelines for PostgreSQL operation.

The FSP Health Check runs over a day and includes:

• Evaluation of operating system configuration. Includes I/O scheduling, memory and buffer/cache, security and network tuning.
• Analysis of PostgreSQL setup. Includes postgresql.conf evaluation and tuning, feasibility evaluation for upgrades to the latest version of PostgreSQL, audit of PostgreSQL memory use and suitability to existing hardware configuration.
• Storage infrastructure recommendations. Determine whether storage configuration upgrades (such as using a different RAID level, or purchasing SAN hardware) would enhance performance and provide a benefit for the client.

In addition to the Health Check, FSP can also provide the Health Tune-up — an additional day in which the experienced FSP team assists in implementing the recommendations laid out on the Health Check.

Bench Check

If your application has outgrown its current infrastructure, the FSP team can help benchmark potential hardware upgrades and architectures to find the solution that provides the best price and performance.

The FSP team can tailor a benchmarking program to suit your application and workload by capturing real traffic and simulating database load under a variety of situations.

Depending on requirements, the Bench Check runs over a course of 1 to 5 days.

The Upgrade

Need to upgrade PostgreSQL to take advantage of performance improvements and enhanced functionality? The FSP team is ready to assist clients in migrating to newer versions of PostgreSQL with minimal downtime and no upgrade hassles.

The Upgrade runs over a course of 1 to 5 days, depending on requirements.

Ops Review

The Ops Review is a comprehensive analysis service undertaken by FSP experts to ensure that current implementation and procedures are delivering the best possible PostgreSQL experience and are in accordance with best practices.

Depending on requirements, the Ops Review includes analysis of performance bottlenecks, review of database schema, advice on backup regimen and suitability of potential replication solutions.

The Ops Review runs over a course of 2 days.

For more information, contact Fujitsu.