Tuning PostgreSQL for High Write Workloads
https://www.youtube.com/watch?v=xrMbzHdPLKM
- 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
https://www.youtube.com/watch?v=RpoC3UcG5YA
Tuning PostgreSQL for High Write Workloads
https://www.youtube.com/watch?v=xrMbzHdPLKM
PostgreSQL 9.6. How config performs in high-write workloads.
B-tree indexes by Anastasia Lubennikova
https://www.youtube.com/watch?v=n5-xEEQFqPY
AWS Training Series
B-tree, index, PostgreSQL 13.
Fundamentals are high-level overview.
Recommend the Performance Part 1 & Part 2.