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. Understanding the PostgreSQL Query Planner
- Examining query execution plans and Planner algorithms (classic, genetic)
- Interpreting query execution plans (data access methods, join methods)
- Guiding plan selection through configuration parameters and pg_hint_plan
2. Query Planner Statistics
- Evaluating execution plan costs
- Reviewing the default statistics model
- Exploring the ANALYZE operation and extended statistics
3. Leveraging Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Implementing 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 Processing
- System architecture
- Relevant configuration parameters
- Analysing execution plans for parallelised queries
7. Monitoring Workload and Performance
- Logging slow-executing queries
- Utilising the auto_explain extension
- Utilising the pg_stat_statements extension
- Reviewing Cumulative Statistics
8. Benchmarking using PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or demonstration of equivalent expertise
- Practical experience in SQL and PostgreSQL operational tasks
Audience
Database Administrators, DevOps Engineers, and Developers tasked with the tuning and upkeep of PostgreSQL within 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.
