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

Requirements

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

  14 Hours
 

Testimonials (3)

Related Courses

Related Categories