Performance Tuning and Optimization for Postgres DBAs and Developers

Date: 2017-08-16
Location: online
Language: English

Course Outline:

  • Introduction
  • Performance Tuning: Overview
  • Tuning Technique
  • Operating System
  • SQL Tuning
    • Logging Slow Queries
  • Query Planning and Optimization
  • Table Statistics
  • Indexes
  • Loading a Table in Memory
  • Plan Cache
  • Tablespaces
  • Database Parameter Tuning
  • Proactive Maintenance
  • Vacuum and Auto Vacuum
  • The Visibility Map
  • Routine Re-indexing
  • EDB Postgres Enterprise Manager: Performance Dashboards
  • Optimizing Slow queries: EDB Postgres Enterprise Manager's SQL Profiler
  • Optimizing Slow queries: Index Advisor
  • Setting Maintenance Alerts in EDB Postgres Enterprise Manager

Target Audience:

Database Administrators, Architects, Developers, Analysts, and Support Engineers


Working knowledge of PostgreSQL

Register Now Click Here

Note: Certifications offered by EnterpriseDB is an independent certification, and are not reviewed or endorsed by the PostgreSQL Community.

Posted by EnterpriseDB Corporation (

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.