Postgres Professional has recently made strides in expanding its educational offerings by translating the DBA2: Configuration and Monitoring of PostgreSQL 16 course into English. This comprehensive four-day program is tailored for PostgreSQL administrators who possess foundational Unix skills and a level of PostgreSQL knowledge akin to that of the DBA1. Basic PostgreSQL Administration course.
Course Overview
The DBA2 course delves into the practical dimensions of PostgreSQL configuration, monitoring, and maintenance. It equips database administrators with insights into how server internals influence daily administrative choices. Key topics covered in the curriculum include:
- Multi-Version Concurrency Control (MVCC)
- Isolation levels
- Row versions
- Vacuuming and autovacuuming
- Freezing
- Buffer cache management
- Write-ahead logging (WAL)
- Checkpoints
- WAL tuning
- Object-level and row-level locks
- Locks in RAM
- Extensions
- Localization
- Server upgrades
Upon completion of the course, participants will be adept at configuring PostgreSQL parameters in alignment with the server’s internal architecture. They will also gain the ability to monitor the server effectively, utilizing feedback for continuous tuning, managing localization settings, handling extensions, and grasping the fundamentals of PostgreSQL upgrades.
The course materials are thoughtfully designed, featuring a student guide that provides detailed instructions on setting up the virtual machine and executing practical tasks. The translation into English was skillfully carried out by Elena Sharafutdinova, with special acknowledgments to Ilya Bashtanov and Alexander Meleshko for their invaluable review and assistance in refining the course content.
For those interested in enhancing their PostgreSQL expertise, the DBA2: Configuration and Monitoring of PostgreSQL 16 course offers a robust opportunity to deepen their understanding and skills in this powerful database management system.
