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.1 Performance