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