- PostgreSQL 의 내부 구조를 설명하는 무료 PDF
총 5개 파트(현재는 파트1만 공개. 곧 공개 예정)
- Part 1. Isolation and MVCC
- Isolation
- Pages and Tuples
- Snapshots
- Page Pruning and HOT Updates
- Vacuum and Autovacuum
- Freezing
- Rebuilding Tables and Indexes
- Part 2. Buffer Cache and WAL
- Buffer Cache
- Write-Ahead Log
- WAL Modes
- Part 3. Locks
- Relation-Level Locks
- Row-Level Locks
- Miscellaneous Locks
- Locks in Memory
- Part 4. Query Execution
- Query Execution Stages
- Statistics
- Table Access Methods
- Index Access Methods
- Index Scan
- Nested Loop
- Hashing
- Merging and Sorting
- Part 5. Types of Indexes
- Hash
- B-Tree
- GiST
- SP-GiST
- GIN
- BRIN