Did you tune your postgresql.conf file? You'll get terrible performanceif you don't.
Check out:http://www.powerpostgresql.com/PerfListhttp://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html