Great article! Lots of useful information. If you are planning deep dives on some of the tips oulined in this article, my top 3 would be:

1. Using EXPLAIN ANALYZE, EXPLAIN, and ANALYZE. The differences and how to actually use each one. Understanding the output.

2. Partial Indexes.

3. Partitioning, especially with multi-tenant databases.