PostgreSQL 13. Query Optimization
Course ID : PS-QPT-4
Duration In-class (в days) : 2 days
Duration Online : 2 days
Сurriculum : очно, Virtual Instructor-Led Training - ONLINE
Overview
This course covers configuring instance parameters to improve performance, as well as identifying and optimizing problematic queries.
Audience for this course
- Database Administrators
- Database Developers
Prerequisites for this course
- Familiarity with Unix OS
- Proficiency in SQL
- PostgreSQL as covered in the DBA1 “PostgreSQL Administration: Basic Course” or DEV1 “Developing the Server Side of PostgreSQL 16 Applications: Basic Course”
Outcomes
Upon completion of this course, students will gain the skills to:
- Understand query planning and execution
- Tune instance parameters related to performance
- Identify problematic queries and optimize them
Outline
Module 1. “Demo Database”
- General Diagram of the “Air Transportation” Demo Database
Module 2. “Query Execution”
- General Approaches to Optimization
- Simple Protocol and Query Processing Stages
- Advanced Protocol
- Detailed Query Planning
Module 3. “Data Access”
- Access Methods
- Parallel Access
- Index Types
Module 4. “Sorting and Grouping”
- Sorting
- Grouping
Module 5. “Join Methods”
- Nested Loop Join
- Hash Join
- Merge Join
Module 6. “Statistics”
- Basic Statistics
- Advanced Statistics
Module 7. “Query Optimization”
- Profiling
- Materialization
- Functions
- Tuning Approaches
