This is a full-day training session focused on areas that you should master to tune PostgreSQL for performance.
The training starts by explaining the overall architecture of the database system, how it interacts with the operating system, and what settings are important – both in PostgreSQL and the operating system. We’ll spend some time explaining the basics of locking and MVCC in PostgreSQL, and will then discuss topics that are relevant for performance optimization at the query level.
Topics covered in this course include, but are not limited to:
- Server Architecture and Tuning
- MVCC and VACUUM
- Locking and Concurrency
- EXPLAIN SQL Tuning
- Workload Analysis