Amrit, > I use RH 9.0 with postgresql 7.3.2 and 4 Gb ram [server spec. Dual Xeon > 3.0] and someone mention that the hyperthreading will not help but if I let > it there will it be any harm to the system? > Any comment please.
Sometimes. Run a test and take a look at your CS (context switch) levels on VMSTAT. If they're high, turn HT off. If it's a dedicated PG system, though, just turn HT off. We can't use it. Also, upgrade PostgreSQL to 7.3.8 at least. 7.3.2 is known-buggy. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend