[DB] a good tutorial on how to optimize postgresql

http://www.postgresql.org/docs/8.1/interactive/performance-tips.html

Yeah, the documentation of Postgresql is a very good source to learn optimization of postgresql. Read it carefully and periodically.