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. Demystifying the PostgreSQL Query Planner
- Execution plans and Query Planner algorithms (classic, genetic)
- Interpreting execution plans (data access patterns, join strategies)
- Influencing plan selection (configuration settings, pg_hint_plan)
2. Query Planner Statistics
- Estimating the cost of execution plans
- The default statistics framework
- The ANALYZE command and extended statistics
3. Strategic Index Usage
- B-tree indexes (single-column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Advanced Table Structures
- Table partitioning
- Unlogged tables
- Temporary tables
- Materialised views
5. Leveraging Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- Internal architecture
- Relevant configuration parameters
- Analyzing plans for parallelized queries
7. Workload and Performance Monitoring
- Capturing slow queries via logging
- Utilizing the auto_explain extension
- Leveraging the pg_stat_statements extension
- Managing cumulative statistics
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or comparable proficiency
- Practical experience with SQL and day-to-day PostgreSQL administration
Target Audience
Database Administrators, DevOps Engineers, and Developers tasked with tuning and maintaining PostgreSQL in production settings.
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.
