Course Outline
1. Understanding PostgreSQL Query Planner
- Query execution plans, Query Planner algorithms (classic, genetic)
- Analysing query execution plans (data access methods, join methods)
- Controlling plan selection (configuration parameters, pg_hint_plan)
2. Query Planner Statistics
- Execution plan cost estimation
- Default statistics model
- ANALYZE operation, extended statistics
3. Using Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST, GIN indexes
4. Using Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Using Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query
- Architecture
- Configuration parameters
- Analysing parallelised query execution plans
7. Workload and Performance Monitoring
- Logging slow queries
- Using auto_explain extension
- Using pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or equivalent knowledge
- Working experience with SQL and PostgreSQL operations
Audience
Database Administrators, DevOps Engineers, and Developers responsible for tuning and maintaining PostgreSQL in production environments.
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 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
