PostgreSQL Performance Tuning Training Course


14 hours (usually 2 days including breaks)


It is recommended to take this training only if you have a prior knowledge of PostgreSQL.


This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance. 

Course Outline

  • Introduction
  • Query Tuning
    • Logging in PostgreSQL
    • Query Plans
    • Statistics
    • SQL Best Practices
    • Indexes
    • Table Partitioning
  • Performance Tuning
    • Operating System Best Practices
    • Server Parameter Tuning
    • Extension – pg_stat_statements
    • Demo and Labs
  • Benchmarking
    • Database Benchmarking
    • Pgbench
    • Reading the Results
    • Demo and Labs

Leave a Reply

Your email address will not be published. Required fields are marked *