# Summary - [[README|The Lazy Elephant (Introduction)]] ## Chapter 1: The Building Blocks & The Art of Procrastination - [[Postgres/Chapter 1 - The Building Blocks|Chapter 1: The Building Blocks & The Art of Procrastination]] - [[Postgres/Structures/_Structures|Structures Overview]] - [[Postgres/Structures/Tuple|The Tuple]] - [[Postgres/Structures/Page|The Page]] - [[Postgres/Structures/Table|The Table]] - [[Postgres/Structures/Result Set|The Result Set]] - [[Postgres/Architecture/MVCC|MVCC (Why Deleting is Too Hard)]] ## Chapter 2: The Mighty Indexes (Building Cheat Sheets) - [[Postgres/Chapter 2 - The Mighty Indexes|Chapter 2: The Mighty Indexes]] - [[Postgres/Structures/Index|Index Architecture Overview]] - [[Postgres/Structures/Index/BTree|B-Tree]] - [[Postgres/Structures/Index/Hash|Hash]] - [[Postgres/Structures/Index/GiST|GiST]] - [[Postgres/Structures/Index/SPGiST|SP-GiST]] - [[Postgres/Structures/Index/GIN|GIN]] - [[Postgres/Structures/Index/BRIN|BRIN]] ## Chapter 3: The Query Planner (The Lazy General) - [[Postgres/Chapter 3 - The Query Planner|The Query Planner]] ## Chapter 4: The Grand Operations (The Soldiers) - [[Postgres/Chapter 4 - The Grand Operations|Chapter 4: The Grand Operations]] - [[Postgres/Operations/_Postgres Operations|Operations Overview]] - [[Postgres/Operations/SeqScan|Sequential Scan]] - [[Postgres/Operations/IndexScan|Index Scan]] - [[Postgres/Operations/IndexOnlyScan|Index Only Scan]] - [[Postgres/Operations/BitmapHeapScan|Bitmap Heap Scan]] - [[Postgres/Operations/BitmapIndexScan|Bitmap Index Scan]] - [[Postgres/Operations/NestedLoop|Nested Loop Join]] - [[Postgres/Operations/HashJoin|Hash Join]] - [[Postgres/Operations/MergeJoin|Merge Join]] - [[Postgres/Operations/Aggregate|Aggregate]] - [[Postgres/Operations/Sort|Sort]] - [[Postgres/Operations/Limit|Limit]] - [[Postgres/Operations/WindowAgg|WindowAgg]] - [[Postgres/Operations/ModifyTable|ModifyTable]] - [[Postgres/Operations/Materialize|Materialize]] - [[Postgres/Operations/Hash|Hash]] - [[Postgres/Operations/Gather|Gather]] - [[Postgres/Operations/GatherMerge|Gather Merge]] - [[Postgres/Operations/SubqueryScan|Subquery Scan]] - [[Postgres/Operations/CTEScan|CTEScan]] - [[Postgres/Operations/Append|Append]] - [[Postgres/Operations/MergeAppend|Merge Append]] - [[Postgres/Operations/RecursiveUnion|Recursive Union]] - [[Postgres/Operations/BitmapAndBitmapOr|BitmapAnd / BitmapOr]] - [[Postgres/Operations/CustomScanForeignScan|Custom Scan / Foreign Scan]] - [[Postgres/Operations/SampleScan|Sample Scan]] - [[Postgres/Operations/TidScan|Tid Scan]] - [[Postgres/Operations/ValuesScan|Values Scan]] - [[Postgres/Operations/FunctionScan|Function Scan]] - [[Postgres/Operations/TableFuncScan|Table Func Scan]] - [[Postgres/Operations/ProjectSet|Project Set]] - [[Postgres/Operations/Redistribute|Redistribute]] - [[Postgres/Operations/Unique|Unique]] - [[Postgres/Operations/Result|Result]] ## Chapter 5: Safety & Promises (The Pocket Diary) - [[Postgres/Chapter 5 - Safety Without Sweating|Chapter 5: Safety & Promises]] - [[Postgres/Architecture/WAL|Architecture: Write-Ahead Log (WAL)]] - [[Postgres/Architecture/Transactions|Architecture: Transactions (The Pinky Swear)]] ## Chapter 6: The Hunger of Resources (The Speed of the Elephant) - [[Postgres/Chapter 6 - The Hunger of Resources|Chapter 6: The Hunger of Resources]] - [[Postgres/Resources/_Resources|Resources Overview]] - [[Postgres/Resources/CPU|CPU]] - [[Postgres/Resources/Memory|Memory]] - [[Postgres/Resources/Disk IO|Disk IO]] - [[Postgres/Resources/Network|Network]] ## Chapter 7: The Waiting Game (Diagnostic Guide) - [[Postgres/Chapter 7 - The Waiting Game|Chapter 7: The Waiting Game]] - [[Postgres/Workloads/_Workloads|Workloads Overview]] - [[Postgres/Workloads/Lock|Locks]] - [[Postgres/Workloads/LWLock|LWLocks]] - [[Postgres/Workloads/IO|Disk IO]] - [[Postgres/Workloads/IPC|IPC (Inter-Process Communication)]] - [[Postgres/Workloads/Client|Client]] - [[Postgres/Workloads/Timeout|Timeout]] - [[Postgres/Workloads/Activity|Activity]] - [[Postgres/Workloads/Extension|Extension]] - [[Postgres/Workloads/CPU|CPU (Wait)]] - [[Postgres/Workloads/BufferPin|BufferPin]] ## Chapter 8: The Cloud Scales (Outsourcing Labor) - [[Postgres/Chapter 8 - The Cloud Scales|Chapter 8: The Cloud Scales]] - [[Postgres/Architecture/Cluster|Cluster Architecture (Overview)]] - [[Postgres/Architecture/Cluster/Aurora|Amazon Aurora]] - [[Postgres/Architecture/Cluster/AlloyDB|Google AlloyDB]] - [[Postgres/Architecture/Cluster/Neon|Neon (Serverless branching)]]