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. Exploring the PostgreSQL Query Planner
- Examining query execution plans and Planner algorithms (classic, genetic)
- Interpreting execution plans (data access methods, join strategies)
- Managing plan selection (configuration settings, pg_hint_plan)
2. Query Planner Statistics
- Estimating execution plan costs
- Understanding the default statistical model
- Executing ANALYZE operations and managing extended statistics
3. Implementing Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST and GIN indexes
4. Leveraging Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Optimising Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query Execution
- Underlying architecture
- Relevant configuration parameters
- Analysing execution plans for parallelised queries
7. Workload and Performance Monitoring
- Logging slow-running queries
- Utilising the auto_explain extension
- Leveraging the pg_stat_statements extension
- Managing cumulative statistics
8. Benchmarking with PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possessing equivalent expertise
- Practical experience with SQL and PostgreSQL operations
Target Audience
This course is tailored for Database Administrators, DevOps Engineers, and Developers who are accountable for optimising and maintaining PostgreSQL within 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.
