Course Outline
1. Grasping the PostgreSQL Query Planner
- Query execution plans and Query Planner algorithms (classic, genetic)
- Interpreting query execution plans (data access methods, join strategies)
- Managing plan selection (configuration parameters, pg_hint_plan)
2. Query Planner Statistics
- Cost estimation for execution plans
- The default statistics model
- The ANALYZE command and extended statistics
3. Leveraging Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Employing Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Managing Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- Architectural overview
- Relevant configuration parameters
- Analysing execution plans for parallelised queries
7. Monitoring Workloads and Performance
- Logging slow-running queries
- Utilising the auto_explain extension
- Utilising the pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or comparable expertise
- Practical experience with SQL and PostgreSQL operational tasks
Audience
Database Administrators, DevOps Engineers, and Developers who are accountable for optimising and maintaining PostgreSQL within production settings.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
