# PostgreSQL 查询性能优化

> 从访问方法、排序、连接和统计信息入手，学习执行计划分析和查询调优。

---

LLMS 索引： [llms.txt](/llms.txt)

---

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

这里整理 PGPRO 培训的八门 PostgreSQL 课程。中文页先固定课程顺序、主题键和来源关系，下一步可以逐页加工译文。

> **资料状态:** 中文译文骨架，正文待加工

> **翻译基线:** English。英文完整 16 版日期包已公开，文件名带 20251018 日期；俄文 16 版用于逐章交叉核对。

## 课程定位

从访问方法、排序、连接和统计信息入手，学习执行计划分析和查询调优。

## 资料状态

| 语言 | 当前公开包 | 版本 | 主题数 | 课程页 |
| --- | --- | --- | ---: | --- |
| English | [QPT-handouts-16-en-20251018.zip](https://edu.postgrespro.com/16/QPT-handouts-16-en-20251018.zip) | 16-20251018 | 17 | [HTTP 200](https://postgrespro.com/community/courses/QPT) |
| Русский | [QPT-handouts-16.zip](https://edu.postgrespro.ru/16/QPT-handouts-16.zip) | 16 | 17 | [HTTP 200](https://postgrespro.ru/education/courses/QPT) |

## 课程目录

- [00 Optimizing Queries](/qpt/qpt-00-introduction/)
- [01 Demo database "Air Transport"](/qpt/qpt-01-demodb-bookings/)
- [02 Planning and Execution](/qpt/qpt-02-query-query/)
- [03 Access Methods](/qpt/qpt-03-am-am/)
- [04 Parallel Data Access](/qpt/qpt-04-am-parallels/)
- [05 Index Types](/qpt/qpt-05-am-indexes/)
- [06 Sorting](/qpt/qpt-06-sort-sort/)
- [07 Grouping](/qpt/qpt-07-sort-group/)
- [08 Nested Loop Join](/qpt/qpt-08-join-nestloop/)
- [09 Hash Join](/qpt/qpt-09-join-hashjoin/)
- [10 Merge Join](/qpt/qpt-10-join-mergejoin/)
- [11 Basic Statistics](/qpt/qpt-11-stats-basic/)
- [12 Extended Statistics](/qpt/qpt-12-stats-extended/)
- [13 Profiling](/qpt/qpt-13-optim-profiling/)
- [14 Materialization](/qpt/qpt-14-optim-materialization/)
- [15 Functions](/qpt/qpt-15-optim-functions/)
- [16 Approaches to Configuration](/qpt/qpt-16-optim-tuning/)

## 辅助资料

- `demodb.pdf`
- `qpt_new_features.pdf`
- `qpt_student_guide.pdf`

## 编辑状态

英文和俄文页已经从官方 PDF 提取为原生 Markdown；中文页保留同一主题结构，用于后续翻译、术语统一、图表重建和交叉引用。

- [课程版本矩阵](/versions/)
- [可执行翻译清单](/checklist/)
- [来源与许可](/about/)

---

本节页面：

- [第 00 讲：Optimizing Queries（待翻译）](/qpt/qpt-00-introduction/): 中文译稿占位页：Optimizing Queries
- [第 01 讲：Demo database "Air Transport"（待翻译）](/qpt/qpt-01-demodb-bookings/): 中文译稿占位页：Demo database "Air Transport"
- [第 02 讲：Query Execution / Planning and Execution（待翻译）](/qpt/qpt-02-query-query/): 中文译稿占位页：Query Execution / Planning and Execution
- [第 03 讲：Data Access / Access Methods（待翻译）](/qpt/qpt-03-am-am/): 中文译稿占位页：Data Access / Access Methods
- [第 04 讲：Data Access / Parallel Data Access（待翻译）](/qpt/qpt-04-am-parallels/): 中文译稿占位页：Data Access / Parallel Data Access
- [第 05 讲：Data Access / Index Types（待翻译）](/qpt/qpt-05-am-indexes/): 中文译稿占位页：Data Access / Index Types
- [第 06 讲：Sorting and Grouping / Sorting（待翻译）](/qpt/qpt-06-sort-sort/): 中文译稿占位页：Sorting and Grouping / Sorting
- [第 07 讲：Sorting and Grouping / Grouping（待翻译）](/qpt/qpt-07-sort-group/): 中文译稿占位页：Sorting and Grouping / Grouping
- [第 08 讲：Join Methods / Nested Loop Join（待翻译）](/qpt/qpt-08-join-nestloop/): 中文译稿占位页：Join Methods / Nested Loop Join
- [第 09 讲：Join Methods / Hash Join（待翻译）](/qpt/qpt-09-join-hashjoin/): 中文译稿占位页：Join Methods / Hash Join
- [第 10 讲：Join Methods / Merge Join（待翻译）](/qpt/qpt-10-join-mergejoin/): 中文译稿占位页：Join Methods / Merge Join
- [第 11 讲：Statistics / Basic Statistics（待翻译）](/qpt/qpt-11-stats-basic/): 中文译稿占位页：Statistics / Basic Statistics
- [第 12 讲：Statistics / Extended Statistics（待翻译）](/qpt/qpt-12-stats-extended/): 中文译稿占位页：Statistics / Extended Statistics
- [第 13 讲：Query Optimization / Profiling（待翻译）](/qpt/qpt-13-optim-profiling/): 中文译稿占位页：Query Optimization / Profiling
- [第 14 讲：Query Optimization / Materialization（待翻译）](/qpt/qpt-14-optim-materialization/): 中文译稿占位页：Query Optimization / Materialization
- [第 15 讲：Query Optimization / Functions（待翻译）](/qpt/qpt-15-optim-functions/): 中文译稿占位页：Query Optimization / Functions
- [第 16 讲：Query Optimization / Approaches to Configuration（待翻译）](/qpt/qpt-16-optim-tuning/): 中文译稿占位页：Query Optimization / Approaches to Configuration