# Summary - [The Lazy Elephant (Introduction)](README.md) ## Chapter 1: The Building Blocks & The Art of Procrastination - [Chapter 1: The Building Blocks & The Art of Procrastination](Postgres/Chapter 1 - The Building Blocks.md) - [Structures Overview](Postgres/Structures/_Structures.md) - [The Tuple](Postgres/Structures/Tuple.md) - [The Page](Postgres/Structures/Page.md) - [The Table](Postgres/Structures/Table.md) - [The Result Set](Postgres/Structures/Result Set.md) - [MVCC (Why Deleting is Too Hard)](Postgres/Architecture/MVCC.md) ## Chapter 2: The Mighty Indexes (Building Cheat Sheets) - [Chapter 2: The Mighty Indexes](Postgres/Chapter 2 - The Mighty Indexes.md) - [Index Architecture Overview](Postgres/Structures/Index.md) - [B-Tree](Postgres/Structures/Index/BTree.md) - [Hash](Postgres/Structures/Index/Hash.md) - [GiST](Postgres/Structures/Index/GiST.md) - [SP-GiST](Postgres/Structures/Index/SPGiST.md) - [GIN](Postgres/Structures/Index/GIN.md) - [BRIN](Postgres/Structures/Index/BRIN.md) ## Chapter 3: The Query Planner (The Lazy General) - [The Query Planner](Postgres/Chapter 3 - The Query Planner.md) ## Chapter 4: The Grand Operations (The Soldiers) - [Chapter 4: The Grand Operations](Postgres/Chapter 4 - The Grand Operations.md) - [Operations Overview](Postgres/Operations/_Postgres Operations.md) - [Sequential Scan](Postgres/Operations/SeqScan.md) - [Index Scan](Postgres/Operations/IndexScan.md) - [Index Only Scan](Postgres/Operations/IndexOnlyScan.md) - [Bitmap Heap Scan](Postgres/Operations/BitmapHeapScan.md) - [Bitmap Index Scan](Postgres/Operations/BitmapIndexScan.md) - [Nested Loop Join](Postgres/Operations/NestedLoop.md) - [Hash Join](Postgres/Operations/HashJoin.md) - [Merge Join](Postgres/Operations/MergeJoin.md) - [Aggregate](Postgres/Operations/Aggregate.md) - [Sort](Postgres/Operations/Sort.md) - [Limit](Postgres/Operations/Limit.md) - [WindowAgg](Postgres/Operations/WindowAgg.md) - [ModifyTable](Postgres/Operations/ModifyTable.md) - [Materialize](Postgres/Operations/Materialize.md) - [Hash](Postgres/Operations/Hash.md) - [Gather](Postgres/Operations/Gather.md) - [Gather Merge](Postgres/Operations/GatherMerge.md) - [SubqueryScan](Postgres/Operations/SubqueryScan.md) - [CTEScan](Postgres/Operations/CTEScan.md) - [Append](Postgres/Operations/Append.md) - [Result](Postgres/Operations/Result.md) ## Chapter 5: Safety Without Sweating - [The Write-Ahead Log (WAL)](Postgres/Chapter 5 - Safety Without Sweating.md) ## Chapter 6: The Hunger of Resources - [Chapter 6: The Hunger of Resources](Postgres/Chapter 6 - The Hunger of Resources.md) - [Resources Overview](Postgres/Resources/_Resources.md) - [CPU](Postgres/Resources/CPU.md) - [Memory](Postgres/Resources/Memory.md) - [Disk IO](Postgres/Resources/Disk IO.md) - [Network](Postgres/Resources/Network.md) ## Chapter 7: The Waiting Game (Workloads & Locking) - [Chapter 7: The Waiting Game](Postgres/Chapter 7 - The Waiting Game.md) - [Workloads Overview](Postgres/Workloads/_Workloads.md) - [Locks](Postgres/Workloads/Lock.md) - [LWLocks](Postgres/Workloads/LWLock.md) - [Disk IO](Postgres/Workloads/IO.md) - [IPC (Inter-Process Communication)](Postgres/Workloads/IPC.md) - [Client](Postgres/Workloads/Client.md) - [Timeout](Postgres/Workloads/Timeout.md) - [Activity](Postgres/Workloads/Activity.md) - [Extension](Postgres/Workloads/Extension.md) - [CPU (Wait)](Postgres/Workloads/CPU.md) - [BufferPin](Postgres/Workloads/BufferPin.md) ## Chapter 8: The Cloud Scales (Outsourcing Labor) - [Chapter 8: The Cloud Scales](Postgres/Chapter 8 - The Cloud Scales.md) - [Cluster Architecture (Overview)](Postgres/Architecture/Cluster.md) - [Amazon Aurora](Postgres/Architecture/Cluster/Aurora.md) - [Google AlloyDB](Postgres/Architecture/Cluster/AlloyDB.md) - [Neon (Serverless branching)](Postgres/Architecture/Cluster/Neon.md)