Duration
14 hours (usually 2 days including breaks)
Requirements
It is recommended to take this training only if you have a prior knowledge of PostgreSQL.
Overview
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
Course Outline
- Introduction
- Query Tuning
- Logging in PostgreSQL
- Query Plans
- Statistics
- SQL Best Practices
- Indexes
- Table Partitioning
- Performance Tuning
- Operating System Best Practices
- Server Parameter Tuning
- Extension – pg_stat_statements
- Demo and Labs
- Benchmarking
- Database Benchmarking
- Pgbench
- Reading the Results
- Demo and Labs