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
- Interpreting execution plans and understanding Query Planner algorithms (classic and genetic)
- Evaluating query execution strategies (data retrieval and joining methods)
- Directing plan selection via configuration settings and pg_hint_plan
2. Query Planner Statistics
- Assessing the cost of execution plans
- The standard statistical model
- Executing ANALYZE operations and managing extended statistics
3. Leveraging Indexes
- B-tree indexes (single column, composite, function-based, and partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Optimising Cache Memory
- Buffer Cache management
- Work Memory configuration
- Maintenance Work Memory settings
6. Parallel Query Processing
- System architecture
- Relevant configuration parameters
- Analysing execution plans for parallelised queries
7. Workload and Performance Oversight
- Capturing logs for slow-running queries
- Utilising the auto_explain extension
- Leveraging the pg_stat_statements extension
- Reviewing cumulative statistics
8. Performance Benchmarking with PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possession of comparable expertise
- Practical experience with SQL syntax and PostgreSQL administration
Who this is for
This course is designed for Database Administrators, DevOps Engineers, and Developers who are accountable for optimising and maintaining PostgreSQL instances 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.
