介绍

《PostgreSQL指南：内幕探索》 这本书的作者网站，算是免费给你在线看书了，可惜是英文版本的。

这本书也算是比较老的书了，年代久远的Pg9版本，很多理念甚至出现的BUG到最新版都不适用了，所以了解基础的底层设计理念即可。大家都知道国内因为Mysql占茅坑占得早，加上甲骨文极强的业务推广能力，Mysql遍布大部分公司，Postgresql本身在国内的中小公司普及度一般，反倒是大厂经常借用来改造成自己的数据库，这里我就不一一点名了。

此外Postgresql的MVCC有Mysql的原作者参与，可以作为对比学习的范本，并且Postgresql的MVCC实现和细节都要简单很多。当然对比两个MVCC实现谁优谁劣其实是没有意义的，就好像对比两个数据库好还是坏，重要的是应用场景和具体的知识，这些能消化掉才是本领。

Web

The Internals of PostgreSQL : Introduction (interdb.jp)

Introduce

PostgreSQL is a well-designed open-source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works with each other cooperatively. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity prevent it. The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

Contents

• Chapter 1. Database Cluster, Databases and Tables
• Chapter 2. Process and Memory Architecture
• Chapter 3. Query Processing
• Chapter 4. Foreign Data Wrappers (FDW) and Parallel Query
• Chapter 5. Concurrency Control
• Chapter 6. VACUUM Processing
• Chapter 7. Heap Only Tuple (HOT) and Index-Only Scans
• Chapter 8. Buffer Manager
• Chapter 9. Write Ahead Logging (WAL)
• Chapter 10. Base Backup and Point-In-Time Recovery (PITR)
• Chapter 11. Streaming Replication

Author Blog

Hironobu SUZUKI @ InterDB

Copyright

转载声明？这里贴上了

© Copyright ALL Right Reserved, Hironobu SUZUKI.

If you want to use any part of this document and/or any figure, please contact me. If you work at Amazon, you cannot use and refer to this document because of the copyright violation issues.
Exception: Educational institutions can use this document freely.