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
- Query execution plans and Query Planner algorithms (classic, genetic)
- Interpreting query execution plans (data access methods, join methods)
- Guiding plan selection via configuration parameters and pg_hint_plan
2. Query Planner Statistics
- Cost estimation for execution plans
- The default statistics model
- The ANALYZE operation and extended statistics
3. Utilizing 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. Cache Memory Management
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- System architecture
- Relevant configuration parameters
- Analyzing parallelized query execution plans
7. Workload and Performance Monitoring
- Logging slow queries
- Leveraging the auto_explain extension
- Utilizing the pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possession of equivalent knowledge
- Practical experience with SQL and PostgreSQL operations
Audience
This course is tailored for Database Administrators, DevOps Engineers, and Developers tasked with tuning and maintaining PostgreSQL in production environments.
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.
