Get in Touch
 Duration 14 hours

Course Outline

  • Introduction
  • Query Optimization
    • PostgreSQL Logging Configuration
    • Query Execution Plans
    • Statistical Analysis
    • SQL Best Practices
    • Indexing Strategies
    • Table Partitioning
  • Performance Optimization
    • Operating System Recommendations
    • Server Parameter Adjustment
    • Extension – pg_stat_statements
    • Demonstrations and Practical Exercises
  • Benchmarking
    • Database Benchmarking Procedures
    • Pgbench Utilization
    • Result Interpretation
    • Demonstrations and Practical Exercises

Requirements

This training is recommended only for individuals with prior knowledge of PostgreSQL.

Number of participants


Price per participant

Testimonials (6)

Upcoming Courses

Related Categories