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
- Execution plans and Planner algorithms (classic, genetic)
- Evaluating execution plans (data access and join techniques)
- Managing plan selection (configuration settings, pg_hint_plan)
2. Query Planner Statistics
- Cost estimation for execution plans
- Standard statistical models
- ANALYZE operations and expanded 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
- Materialised views
5. Utilising Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Queries
- System architecture
- Relevant configuration parameters
- Reviewing parallelised query execution plans
7. Workload and Performance Surveillance
- Logging of slow-running queries
- Utilising the auto_explain extension
- Utilising the pg_stat_statements extension
- Cumulative statistical data
8. Benchmarking via PgBench
Requirements
- Successful completion of PostgreSQL Server Administration or possession of comparable expertise
- Practical experience with SQL and PostgreSQL operations
Target Audience
This course is designed for Database Administrators, DevOps Engineers, and Developers tasked with optimising and sustaining PostgreSQL environments in production settings.
Testimonials (3)
A good first contact with a new database technology
Cont Florian - Banca Transilvania Cluj
Course - PostgreSQL Server Administration
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.
