← ALL KNOWLEDGE

KNOWLEDGE / DB

Databases

How data is modeled, stored, indexed, queried, and kept consistent.

DB
PostgreSQLIndexingTransactionsQuery PlanningReplication
01

Foundational · 8 min

A Mental Model for PostgreSQL Indexes

A visual model for B-tree indexes, scans, selectivity, and why a planner may ignore an index.

PostgreSQLIndexingQuery Planning
→02

Intermediate · 9 min

Transactions and Isolation Levels

How database isolation controls what concurrent transactions are allowed to observe.

PostgreSQLTransactionsConsistency
→