While there is some PostgreSQL-specific things in this, the vast majority of it is pretty solid advice regardless of the database you have.