John,
> and Postgres server runtime parameters and other settings relating to
> tuning. Also is there any benchmarking tools available that will help me
> tune this server.
Check out
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Also, I'd like to see what you get under heavy load for context-switching.
We've been having issues with RH+Xeon with really large queries.
--
-Josh Berkus
Aglio Database Solutions
San Francisco