Five Steps to PostgreSQL Performance by Josh Berkus October 2009

I found this to be informative, and much of the advice applies to databases besides PostgreSQL.