PostgreSQL: Videos

Tuning PostgreSQL for High Write Workloads

  • What are Checkpoints, Full Page Write, Log Buffer and how they affect Write & Update performance
  • Tuning: WAL Compression, Max WAL
  • Only index on important things
  • HOT Update v.s. Not HOT Update
  • Avoid Randomness
  • Vaccum in Memory by config checkpoint_timeout
  • Use Amazon Aurora: No Checkpoints, No Full Page Write, No Log Buffer

Tracing PostgreSQL Performance

Tuning PostgreSQL for High Write Workloads

PostgreSQL 9.6. How config performs in high-write workloads.

B-tree indexes by Anastasia Lubennikova

AWS Training Series

PostgreSQL In-Depth Training

B-tree, index, PostgreSQL 13.

Fundamentals are high-level overview.
Recommend the Performance Part 1 & Part 2.