PostgreSQL
PostgreSQL is a row-oriented database built for OLTP: many small, concurrent transactions that read and write individual rows safely. Covers setup, MVCC, WAL, indexing, the planner, replication, and operations.
Row-oriented OLTP database
PostgreSQL is a row-oriented database built for OLTP: many small, concurrent transactions that read and write individual rows safely. Covers setup, MVCC, WAL, indexing, the planner, replication, and operations.
- 11
- chapters
- 28
- sections
- 0
- figures
- 1Why PostgreSQLWhat problem it solves, and when it's the wrong choice.1 sections0 figures
- 2FoundationsGet it running, understand the process model, and write your first schema.3 sections0 figures
- 3Data TypesChoosing the right shape for your data, including JSONB and arrays.2 sections0 figures
- 4Storage InternalsHow Postgres actually stores rows on disk, and why old ones stick around.3 sections0 figures
- 5Transactions & ConcurrencyIsolation levels, locks, and what blocks what.2 sections0 figures
- 6Indexing & Query PlanningMaking the planner choose the fast path.3 sections0 figures
- 7SQL & QueryingJoins, windows, views, and partitioning.4 sections0 figures
- 8WAL, Vacuum & RecoveryThe log that makes crash recovery and backups possible, and the cleanup that keeps tables lean.3 sections0 figures
- 9Replication & ScalingRunning it across machines, safely, over time.2 sections0 figures
- 10Security & OpsUsers, permissions, and day-to-day configuration.2 sections0 figures
- 11Monitoring & PerformanceWatching it run, tuning it, and what breaks in production.3 sections0 figures