If you were to gird up your loins and learn PostgreSQL performance optimization from scratch, but already knowing where to find the articles and manuals and stuff online, what URLs would you be visiting? What core bits of PostgreSQL would you focus on understanding the most deeply? What books would you buy?
Note: if your comment doesn’t appear it probably went into the spam queue because of links. I’ll retrieve it, don’t worry.