Advanced Development & Performance
The class covers the whole range of performance topics, from systems administration, development and operational improvements.
- Server Architecture & Cacheing
- Tuning Parameters
- MVCC, VACUUM and HOT
- Locking & Concurrency
- Database design alternatives
- Advanced Development Summary
- Reading EXPLAINs
- Workload Analysis, Benchmarking and Profiling
- Join Planning
- Indexes
- SQL Performance Tips & Tricks
- What's New in 9.2 Performance
