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
- Understanding query execution plans and Planner algorithms (classic, genetic).
- Analyzing execution plans, including data access and join methods.
- Managing plan selection via configuration parameters and pg_hint_plan.
2. Query Planner Statistics
- Evaluating execution plan cost estimation.
- Reviewing the default statistics model.
- Utilizing 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. Advanced Table Structures
- Partitioned tables.
- Unlogged tables.
- Temporary tables.
- Materialized views.
5. Optimizing Cache Memory
- Buffer Cache management.
- Work Memory configuration.
- Maintenance Work Memory settings.
6. Parallel Query Execution
- Parallel query architecture.
- Relevant configuration parameters.
- Analyzing parallelized query execution plans.
7. Workload and Performance Monitoring
- Implementing slow query logging.
- Utilizing the auto_explain extension.
- Leveraging the pg_stat_statements extension.
- Working with cumulative statistics.
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or possession of equivalent expertise.
- Professional experience with SQL and PostgreSQL operational tasks.
Target Audience
This course is designed for Database Administrators, DevOps Engineers, and Developers who are responsible for 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.
