Using PEM to understand and improve performance in Postgres: the Postgres Tuning Wizard and Performance Diagnostics

The Postgres Enterprise Manager (PEM) Tuning Wizard reviews your installation, and recommends a set of configuration options that will help tune a Postgres installation to best suit the anticipated workload. PEM's Performance Diagnostics uses Postgres' wait state information to analyze queries in context of the current workload and help identify further performance improvement opportunities in terms of locks, IO, and CPU bottlenecks.

 

This webinar will explore:

  • How to intelligently manage all your database servers with a single console
  • Useful features and functionality needed for visual database administration
  • Managing the performance and design of your database servers

 

Webinar video:

 

Webinar slides: