Advanced Development & Performance
This class covers the whole range of performance topics, from systems administration, development and operational improvements.
Please note: This course was previously advertised as 1 day but based on student feedback we have extended it to 3 days to provide an extended range of topics.
|Subject Areas||Topics||Course acquired skills|
Server Architecture & Caching
MVCC, VACUUM and HOT
Locking & Concurrency
Database design alternatives
Advanced Development Summary
Workload Analysis, Benchmarking and Profiling
SQL Performance Tips & Tricks
What's New in 9.3 Performance
Advanced PostgreSQL development
Advanced application design
Advanced tuning and performance
Advanced database architecture with PostgreSQL
|Minimum prerequisites:||Course length|
Basics of programming
Basics of systems administration
Basics of PostgreSQL database administration
We recommend you attend ‘PostgreSQL 9 Database Administration’ course before attending this course.