On Sat, Jun 03, 2006 at 11:38:10AM +0100, [EMAIL PROTECTED] 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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
