Audit and Tune

Audit & Tune is a way for CMD to become familiar with a Client's environment. It provides a thorough overview of the environment and documents best practices including optimizations to be made for the PostgreSQL Environment.

Should the Client decide that our recommendations are proper for their environment, CMD will happily make the documented changes during business hours at no extra charge. Pricing includes a single cluster/server.

1. If you are a new client, download the services agreement.
2. Sign and return the documents in full via (pick one):
   • billing <at> commandprompt.com
   • Fax: 503.210.0334.

The Audit and Tune services offers reviews, documents and optimizes the following:

Verify PostgreSQL

• Version
• Maintenance Regime
• SCM (postgresql.conf/pg_hba.conf)
• Backups
• Resources

Optimize PostgreSQL

• Caching
• Planner
• Maintenance
• Writer processes

Verify Operating System

• CPU Architecture
• OS Architecture
• PostgreSQL Architecture
• SCM (sysctl.conf)
• File system

Optimize Operating System

• Kernel Parameters
• Scheduler (Linux)
• Log maintenance
• Logging configuration

Verify Hardware

• RAID Controller
• BBU
• RAID Level
• Number of Spindles
• SCSI/SATA/NAS/SAN
• IO Performance
• CPU Utilization
• CPU Bottlenecks

Optimize Hardware

• Read Ahead
• Network Performance

Verify Application interface

• Connectivity
• Network connections
• Long running queries
• Idle transactions
• System thrashing
• Obvious unsafe behavior

Verify Database security

• Network security (OS)
• HBA