Videos

Tuning PostgreSQL for High Write Workloads

https://www.youtube.com/watch?v=xrMbzHdPLKM

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

PostgreSQL In-Depth Training

B-tree, index, PostgreSQL 13.

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

More