PostgreSQL Performance Audit

The Performance Audit is the perfect way to identify Performance and Maintenance hot spots on a production system. It is especially effective when combined with an configuration and systems review such as the the Audit and Tune.

Performance Audit

Performance Audit, single machine:

The goal of this audit is to identify database performance issues, improving the responsiveness of the target system and utilizing existing resource in an efficient manner.

We achieve this by examining all kinds of system indicators, from information collected by monitoring tools and logs to the database statistics. Based on this data, we make suggestions about PostgreSQL configuration and query performance.

Performance Audit Features:

analyze information from system monitoring tools, such as sar, iostat or vmstat
examine table and index bloat
check system-wise and per-table autovacuum settings
check the logs for errors and warnings
identify and examine slow queries
check wal/checkpoints for performance bottlenecks

To perform the audit effectively, we need some extra information about the target system, particularly, whether there are monitoring tools available on the target system and how can we access the data collected. We would like you to turn on log_min_duration_statement, setting it to the duration that is considered slow for your queries (if not sure, set it to 1s), making sure that logs are stored on the target system for examination. Generally, any kind of additional information about existing performance issues can be useful to us.

As a result, we deliver a detailed report, highlighting the issues discovered during audit with the suggestions on how to fix them and improve overall database performance.

$3495.00

Purchase