Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
Дата
Msg-id 200501071720.08858.josh@agliodbs.com
обсуждение исходный текст
Ответ на Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?  (amrit@health2.moph.go.th)
Ответы Re: Does "HYPERTHREADING" do any harm if we use with RH9.0
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: amrit@health2.moph.go.th
Дата:
Сообщение: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
Следующее
От: Steve Poe
Дата:
Сообщение: Re: Does "HYPERTHREADING" do any harm if we use with RH9.0