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.
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