another articles with pgsql performance tips:
http://candle.pha.pa.us/main/writings/pgsql/performace.pdf