# PostgreSQL 管理：配置与监控 > 围绕多版本并发控制、WAL、锁、扩展、本地化和升级展开的管理课程。 --- LLMS 索引： [llms.txt](/llms.txt) --- 这里整理 PGPRO 培训的八门 PostgreSQL 课程。中文页先固定课程顺序、主题键和来源关系，下一步可以逐页加工译文。 > **资料状态:** 中文译文骨架，正文待加工 > **翻译基线:** English。英文完整 16 版课程包已公开，俄文完整 16 版用于逐章交叉核对。 ## 课程定位 围绕多版本并发控制、WAL、锁、扩展、本地化和升级展开的管理课程。 ## 资料状态 | 语言 | 当前公开包 | 版本 | 主题数 | 课程页 | | --- | --- | --- | ---: | --- | | 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) | ## 课程目录 - [00 PostgreSQL 16](/dba2/dba2-00-introduction/) - [01 Isolation](/dba2/dba2-01-mvcc-isolation/) - [02 Page Layout and Row Versions](/dba2/dba2-02-mvcc-tuples/) - [03 Snapshots](/dba2/dba2-03-mvcc-snapshots/) - [04 HOT Updates and Page Pruning](/dba2/dba2-04-mvcc-hot/) - [05 Vacuuming](/dba2/dba2-05-mvcc-vacuum/) - [06 Autovacuuming](/dba2/dba2-06-mvcc-autovacuum/) - [07 Freezing](/dba2/dba2-07-mvcc-freeze/) - [08 Buffer Cache](/dba2/dba2-08-wal-buffercache/) - [09 Write-Ahead Log](/dba2/dba2-09-wal-log/) - [10 Checkpoint](/dba2/dba2-10-wal-checkpoint/) - [11 WAL Tuning](/dba2/dba2-11-wal-tuning/) - [12 Object-Level Locks](/dba2/dba2-12-locks-objects/) - [13 Row-Level Locks](/dba2/dba2-13-locks-rows/) - [14 Locks in RAM](/dba2/dba2-14-locks-memory/) - [15 Managing Extensions](/dba2/dba2-15-admin-extensions/) - [16 Localization](/dba2/dba2-16-admin-localization/) - [17 Server Upgrade](/dba2/dba2-17-admin-upgrade/) ## 辅助资料 - `dba2_new_features.pdf` - `dba2_student_guide.pdf` ## 编辑状态 英文和俄文页已经从官方 PDF 提取为原生 Markdown；中文页保留同一主题结构，用于后续翻译、术语统一、图表重建和交叉引用。 - [课程版本矩阵](/versions/) - [可执行翻译清单](/checklist/) - [来源与许可](/about/) --- 本节页面： - [第 00 讲：Configuration and Monitoring / PostgreSQL 16（待翻译）](/dba2/dba2-00-introduction/): 中文译稿占位页：Configuration and Monitoring / PostgreSQL 16 - [第 01 讲：MVCC / Isolation（待翻译）](/dba2/dba2-01-mvcc-isolation/): 中文译稿占位页：MVCC / Isolation - [第 02 讲：MVCC / Page Layout and Row Versions（待翻译）](/dba2/dba2-02-mvcc-tuples/): 中文译稿占位页：MVCC / Page Layout and Row Versions - [第 03 讲：MVCC / Snapshots（待翻译）](/dba2/dba2-03-mvcc-snapshots/): 中文译稿占位页：MVCC / Snapshots - [第 04 讲：MVCC / HOT Updates and Page Pruning（待翻译）](/dba2/dba2-04-mvcc-hot/): 中文译稿占位页：MVCC / HOT Updates and Page Pruning - [第 05 讲：MVCC / Vacuuming（待翻译）](/dba2/dba2-05-mvcc-vacuum/): 中文译稿占位页：MVCC / Vacuuming - [第 06 讲：MVCC / Autovacuuming（待翻译）](/dba2/dba2-06-mvcc-autovacuum/): 中文译稿占位页：MVCC / Autovacuuming - [第 07 讲：MVCC / Freezing（待翻译）](/dba2/dba2-07-mvcc-freeze/): 中文译稿占位页：MVCC / Freezing - [第 08 讲：WAL / Buffer Cache（待翻译）](/dba2/dba2-08-wal-buffercache/): 中文译稿占位页：WAL / Buffer Cache - [第 09 讲：WAL / Write-Ahead Log（待翻译）](/dba2/dba2-09-wal-log/): 中文译稿占位页：WAL / Write-Ahead Log - [第 10 讲：WAL / Checkpoint（待翻译）](/dba2/dba2-10-wal-checkpoint/): 中文译稿占位页：WAL / Checkpoint - [第 11 讲：WAL / WAL Tuning（待翻译）](/dba2/dba2-11-wal-tuning/): 中文译稿占位页：WAL / WAL Tuning - [第 12 讲：Locks / Object-Level Locks（待翻译）](/dba2/dba2-12-locks-objects/): 中文译稿占位页：Locks / Object-Level Locks - [第 13 讲：Locks / Row-Level Locks（待翻译）](/dba2/dba2-13-locks-rows/): 中文译稿占位页：Locks / Row-Level Locks - [第 14 讲：Locks / Locks in RAM（待翻译）](/dba2/dba2-14-locks-memory/): 中文译稿占位页：Locks / Locks in RAM - [第 15 讲：Administration / Managing Extensions（待翻译）](/dba2/dba2-15-admin-extensions/): 中文译稿占位页：Administration / Managing Extensions - [第 16 讲：Administration / Localization（待翻译）](/dba2/dba2-16-admin-localization/): 中文译稿占位页：Administration / Localization - [第 17 讲：Administration / Server Upgrade（待翻译）](/dba2/dba2-17-admin-upgrade/): 中文译稿占位页：Administration / Server Upgrade