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. Grasping the PostgreSQL Query Planner
- Query execution paths and Planner algorithms (standard, genetic)
- Interpreting query execution plans (data access techniques, join strategies)
- Managing plan selection (configuration settings, pg_hint_plan)
2. Query Planner Statistics
- Estimating execution plan costs
- Default statistical models
- The ANALYZE process 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 Architectures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Utilizing Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- System architecture
- Configuration parameters
- Analyzing execution plans for parallel queries
7. Workload and Performance Surveillance
- Recording slow queries
- Utilizing the auto_explain extension
- Utilizing the pg_stat_statements extension
- Cumulative statistics
8. Benchmarking via PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possession of comparable expertise
- Practical experience with SQL and PostgreSQL operational tasks
Target Audience
Database Administrators, DevOps Engineers, and Developers tasked with tuning and sustaining 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.
