I would suggest subscribing to and reading the fine postgresql mailing lists (general and performance).

It's amazing what you can learn from the questions and answers they get.