Take full advantage of your PostgreSQL server's hardware with pgtune

pgtune is an awesome little Python script that you can run on your postgresql.conf to quickly optimize your config for optimal performance.

As with any performance tuning: YMMV. You should still tweak things manually after running pgtune, but this looks great for picking off low hanging performance fruit!