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
- Execution plans and Query Planner algorithms (classic, genetic)
- Interpreting query execution plans (data access and join methods)
- Managing plan selection via configuration parameters and pg_hint_plan
2. Query Planner Statistics
- Cost estimation for execution plans
- The default statistical model
- 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 Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Utilizing Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Processing
- Underlying architecture
- Relevant configuration parameters
- Analyzing execution plans for parallelized queries
7. Workload and Performance Monitoring
- Capturing slow query logs
- Implementation of the auto_explain extension
- Implementation of the pg_stat_statements extension
- Reviewing cumulative statistics
8. Benchmarking with PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possession of comparable expertise
- Practical experience in SQL and PostgreSQL operations
Target Audience
Database Administrators, DevOps Engineers, and Developers tasked with the tuning and maintenance of 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.
