PostgreSQL Performance Tuning Certificate for Andrzej Sabat
Certificate ID:
681211
Authentication Code:
963d1
Certified Person Name:
Andrzej Sabat
Trainer Name:
Michał Kuna
Duration Days:
2
Duration Hours:
14
Course Name:
PostgreSQL Performance Tuning
Course Date:
27 June 2022 09:00 to 28 June 2022 16:00
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