Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
1. Mastering the PostgreSQL Query Planner
- Execution plans and Query Planner algorithms (classic, genetic)
- Interpreting query execution plans (data access and join methods)
- Guiding plan selection (configuration settings, pg_hint_plan)
2. Query Planner Statistics
- Estimating execution plan costs
- The default statistical model
- ANALYZE operations and extended statistics
3. Leveraging Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialized views
5. Optimizing Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- Architectural overview
- Relevant configuration parameters
- Analysis of parallel query execution plans
7. Workload and Performance Monitoring
- Capturing slow queries via logging
- Utilizing the auto_explain extension
- Applying the pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or comparable expertise
- Practical experience in SQL and PostgreSQL operations
Intended Audience
Database Administrators, DevOps Engineers, and Developers tasked with optimizing and sustaining PostgreSQL in production settings.
Testimonials (3)
I expanded my knowledge on DB performance management, some are directly usable while others provide great insight/context for me.
Longze Chen - Center for Open Science
Course - PostgreSQL Advanced - Performance Management
Different index and table types
Brian J. Geiger - Center for Open Science
Course - PostgreSQL Advanced - Performance Management
performance knowledge