Command Prompt Audit & Tune and Performance Audit for Postgres

Command Prompt will review your current Postgres database environment and document best practices, including optimization of the operating system and database, through the Audit and Tune and/or Performance Audit processes.

This option provides a documented best practices list of recommendations for your PostgreSQL installation. This includes EC2, RDS, and Aurora.

• Verify application interface
• Verify best practices network access
• Verify Instance appropriateness for workload
• Verify OS (EC2 only)

• Analyze information from system monitoring tools, such as sar, iostat, and vmstat
• Examine table and index bloat
• Check system-wide autovacuum settings
• Check logs for errors and warnings
• Identify and examine slow queries
• Check wal/checkpoints for performance bottlenecks
• Check for unused indexes
• Recommendations for optimization of the top slowest queries

Using Amazon EC2, RDS or Aurora for PostgreSQL and need enterprise class support? Command Prompt is the oldest dedicated Postgres and Open Source provider in the AWS Partner Network. With over 25 years of experience, Command Prompt provides 24x7x365 professional support for all your Postgres needs within the Amazon Cloud. For every service that Command Prompt offers, whether custom development, professional services, or support, you will know exactly how much you are paying. You never have to wonder if your services fall under a support contract or are going to be arbitrarily billed as professional services.