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. Trigram Index

Chapter 5: Database Tuning

  1. PostgreSQL Config

Appendix: Database Vocabulary