# Configuration and Monitoring of PostgreSQL

> MVCC, WAL, locks, extensions, localization, monitoring and upgrades.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

This course keeps the official topic order and exposes the English handout as readable, native Markdown for review and future editorial work.

> **Source status:** 官方 PDF 已提取为原生 Markdown

> **Translation baseline:** English baseline. The current English archive is the working baseline; the Russian edition is retained for chapter-level cross-checking.

## Course scope

MVCC, WAL, locks, extensions, localization, monitoring and upgrades.

## Source status

| Language | Current package | Version | Topics | Course page |
| --- | --- | --- | ---: | --- |
| English | [DBA2-handouts-16-en.zip](https://edu.postgrespro.com/16/DBA2-handouts-16-en.zip) | 16 | 18 | [HTTP 200](https://postgrespro.com/community/courses/DBA2) |
| Русский | [DBA2-handouts-16.zip](https://edu.postgrespro.ru/16/DBA2-handouts-16.zip) | 16 | 18 | [HTTP 200](https://postgrespro.ru/education/courses/DBA2) |

## Contents

- [00 PostgreSQL 16](/en/dba2/dba2-00-introduction/)
- [01 Isolation](/en/dba2/dba2-01-mvcc-isolation/)
- [02 Page Layout and Row Versions](/en/dba2/dba2-02-mvcc-tuples/)
- [03 Snapshots](/en/dba2/dba2-03-mvcc-snapshots/)
- [04 HOT Updates and Page Pruning](/en/dba2/dba2-04-mvcc-hot/)
- [05 Vacuuming](/en/dba2/dba2-05-mvcc-vacuum/)
- [06 Autovacuuming](/en/dba2/dba2-06-mvcc-autovacuum/)
- [07 Freezing](/en/dba2/dba2-07-mvcc-freeze/)
- [08 Buffer Cache](/en/dba2/dba2-08-wal-buffercache/)
- [09 Write-Ahead Log](/en/dba2/dba2-09-wal-log/)
- [10 Checkpoint](/en/dba2/dba2-10-wal-checkpoint/)
- [11 WAL Tuning](/en/dba2/dba2-11-wal-tuning/)
- [12 Object-Level Locks](/en/dba2/dba2-12-locks-objects/)
- [13 Row-Level Locks](/en/dba2/dba2-13-locks-rows/)
- [14 Locks in RAM](/en/dba2/dba2-14-locks-memory/)
- [15 Managing Extensions](/en/dba2/dba2-15-admin-extensions/)
- [16 Localization](/en/dba2/dba2-16-admin-localization/)
- [17 Server Upgrade](/en/dba2/dba2-17-admin-upgrade/)

## Supplementary materials

- `dba2_new_features.pdf`
- `dba2_student_guide.pdf`

## Editorial status

The available English handout is extracted from the official PDF. Where no current English archive was found, the route remains ready for a later source edition.

- [Version matrix](/en/versions/)
- [Work checklist](/en/checklist/)
- [Sources and permissions](/en/about/)

---

Section pages:

- [Lesson 00: Configuration and Monitoring / PostgreSQL 16](/en/dba2/dba2-00-introduction/): Native Markdown source page: Configuration and Monitoring / PostgreSQL 16
- [Lesson 01: MVCC / Isolation](/en/dba2/dba2-01-mvcc-isolation/): Native Markdown source page: MVCC / Isolation
- [Lesson 02: MVCC / Page Layout and Row Versions](/en/dba2/dba2-02-mvcc-tuples/): Native Markdown source page: MVCC / Page Layout and Row Versions
- [Lesson 03: MVCC / Snapshots](/en/dba2/dba2-03-mvcc-snapshots/): Native Markdown source page: MVCC / Snapshots
- [Lesson 04: MVCC / HOT Updates and Page Pruning](/en/dba2/dba2-04-mvcc-hot/): Native Markdown source page: MVCC / HOT Updates and Page Pruning
- [Lesson 05: MVCC / Vacuuming](/en/dba2/dba2-05-mvcc-vacuum/): Native Markdown source page: MVCC / Vacuuming
- [Lesson 06: MVCC / Autovacuuming](/en/dba2/dba2-06-mvcc-autovacuum/): Native Markdown source page: MVCC / Autovacuuming
- [Lesson 07: MVCC / Freezing](/en/dba2/dba2-07-mvcc-freeze/): Native Markdown source page: MVCC / Freezing
- [Lesson 08: WAL / Buffer Cache](/en/dba2/dba2-08-wal-buffercache/): Native Markdown source page: WAL / Buffer Cache
- [Lesson 09: WAL / Write-Ahead Log](/en/dba2/dba2-09-wal-log/): Native Markdown source page: WAL / Write-Ahead Log
- [Lesson 10: WAL / Checkpoint](/en/dba2/dba2-10-wal-checkpoint/): Native Markdown source page: WAL / Checkpoint
- [Lesson 11: WAL / WAL Tuning](/en/dba2/dba2-11-wal-tuning/): Native Markdown source page: WAL / WAL Tuning
- [Lesson 12: Locks / Object-Level Locks](/en/dba2/dba2-12-locks-objects/): Native Markdown source page: Locks / Object-Level Locks
- [Lesson 13: Locks / Row-Level Locks](/en/dba2/dba2-13-locks-rows/): Native Markdown source page: Locks / Row-Level Locks
- [Lesson 14: Locks / Locks in RAM](/en/dba2/dba2-14-locks-memory/): Native Markdown source page: Locks / Locks in RAM
- [Lesson 15: Administration / Managing Extensions](/en/dba2/dba2-15-admin-extensions/): Native Markdown source page: Administration / Managing Extensions
- [Lesson 16: Administration / Localization](/en/dba2/dba2-16-admin-localization/): Native Markdown source page: Administration / Localization
- [Lesson 17: Administration / Server Upgrade](/en/dba2/dba2-17-admin-upgrade/): Native Markdown source page: Administration / Server Upgrade