Section 02 of 10

Databases & Postgres

Relational guts, MVCC, indexes, isolation, and how Postgres actually works.

1. 2.1

   ACID properties

   Crisp →Deep dive →
2. 2.2

   MVCC in Postgres

   Crisp →Deep dive →
3. 2.3

   Transaction isolation levels

   Crisp →Deep dive →
4. 2.4

   B-tree indexes

   Crisp →Deep dive →
5. 2.5

   GIN and GIST indexes

   Crisp →Deep dive →
6. 2.6

   Query planner and EXPLAIN

   Crisp →Deep dive →
7. 2.7

   Join strategies (nested, hash, merge)

   Crisp →Deep dive →
8. 2.8

   Partitioning and sharding

   Crisp →Deep dive →
9. 2.9

   Streaming replication

   Crisp →Deep dive →
10. 2.10

    Connection pooling (pgbouncer)

    Crisp →Deep dive →