On Sat, Jun 03, 2006 at 11:38:10AM +0100, fzied@xxxxxxxxx wrote: >> What version of PostgreSQL? (8.1 is better than 8.0 is much better than 7.4.) > 8.1.3 on RHEL 4 OK, that sounds good. >> Have you remembered to turn HT off? > no !! what is it ? HT = Hyperthreading. It usually does more harm than good on databases (although others have reported differing results). >> Have you considered Opterons instead of Xeons? (The Xeons generally >> scale bad with PostgreSQL.) > No can't have it OK, that's bad -- it's probably the single thing that could have helped performance the most. /* Steinar */ -- Homepage: http://www.sesse.net/
