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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: amrit(at)health2(dot)moph(dot)go(dot)th
Cc: PGsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
Date: 2005-01-08 01:20:08
Message-ID: 200501071720.08858.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Loren M. Lang 2005-01-08 03:36:47 TEXT field and Postgresql Perfomance
Previous Message amrit 2005-01-08 00:29:18 Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?