These days noSQL databases quite popular, but knowing how an SQL database works at a pretty low level is not just a good idea, but a great idea. This document covers PostgreSQL in great detail.
PostgreSQL is an 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.
Table Of 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