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.
Course Outline
1. Understanding the PostgreSQL Query Planner
- Query execution plans and Query Planner algorithms (classic, genetic)
- Analysing query execution plans (data access methods, join methods)
- Controlling plan selection (configuration parameters, pg_hint_plan)
2. Query Planner Statistics
- Execution plan cost estimation
- Default statistics model
- ANALYZE operation and extended statistics
3. Using Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST, GIN indexes
4. Using Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Using Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query
- Architecture
- Configuration parameters
- Analysing parallelised query execution plans
7. Workload and Performance Monitoring
- Logging slow queries
- Using auto_explain extension
- Using pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or equivalent knowledge
- Practical experience with SQL and PostgreSQL operations
Audience
Database Administrators, DevOps Engineers, and Developers responsible for tuning and maintaining PostgreSQL in production environments.
14 Hours
Testimonials (1)
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
