WAL, Vacuum & Recovery Write-Ahead Log VACUUM & Autovacuum Backup & Restore

WAL, Vacuum & Recovery

WAL, Vacuum & Recovery

The log that makes crash recovery and backups possible, and the cleanup that keeps tables lean.

The log that makes crash recovery and backups possible, and the cleanup that keeps tables lean.

Sections

8.1
Write-Ahead LogCheckpoints, crash recovery, archiving
8.2
VACUUM & AutovacuumBloat, freezing, and dead tuple cleanup
8.3
Backup & Restorepg_dump, pg_restore, base backups, PITR

Partitioning

Range, list, and hash partitioning, plus pruning

Write-Ahead Log

Checkpoints, crash recovery, archiving