Table of Contents

Preface

  1. Who this book is for

  2. Naming Conventions

Chapter 1: Hardware

  1. Computer Components

  2. Amazon Web Services

Chapter 2: Database Models

  1. Relational Databases (RDMS or RDBMS)

  2. Key Value Stores

  3. Document Stores

  4. Graph DBMS

Chapter 3: Relational Deep Dive

  1. ACID Compliance

  2. Write Ahead Log (WAL)

  3. How Postgres Stores Data

  4. How Postgres Stores Updates and Deletes

  5. Postgres Vacuums

  6. Column Order Matters

Chapter 4: Indices

  1. Btree Index

  2. Gin Index

  3. GiST Index

  4. Trigrams in Gin or GiST Indices

Chapter 5: Database Tuning

  1. PostgreSQL Config

Chapter 6: Query Optimization

  1. Explain Explained

Appendix: Database Vocabulary