pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Does "HYPERTHREADING" do any harm if we use with RH9.0
3+ messages / 3 participants
[nested] [flat]

* Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
@ 2005-01-08 00:29 amrit@health2.moph.go.th
  2005-01-08 01:20 ` Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 3+ messages in thread

From: amrit@health2.moph.go.th @ 2005-01-08 00:29 UTC (permalink / raw)
  To: pgsql-performance

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.
Amrit
Thailand




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
  2005-01-08 00:29 Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? amrit@health2.moph.go.th
@ 2005-01-08 01:20 ` Josh Berkus <josh@agliodbs.com>
  2005-01-07 18:48   ` Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 Steve Poe <spoe@sfnet.cc>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh Berkus @ 2005-01-08 01:20 UTC (permalink / raw)
  To: amrit@health2.moph.go.th; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Does "HYPERTHREADING" do any harm if we use with RH9.0
  2005-01-08 00:29 Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? amrit@health2.moph.go.th
  2005-01-08 01:20 ` Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? Josh Berkus <josh@agliodbs.com>
@ 2005-01-07 18:48   ` Steve Poe <spoe@sfnet.cc>
  0 siblings, 0 replies; 3+ messages in thread

From: Steve Poe @ 2005-01-07 18:48 UTC (permalink / raw)
  To: josh@agliodbs.com; +Cc: pgsql-performance

Josh Berkus wrote:

>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.
>
>  
>
Sorry for the "dumb" question, but what would be considered high 
regarding CS levels?  We just upgraded our server's to dual 2.8Ghz Xeon 
CPUs from dual Xeon 1.8Ghz which unfortunately HT built-in.  We also 
upgraded our database from version 7.3.4 to 7.4.2

Thanks.

Steve Poe






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-01-08 01:20 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-08 00:29 Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? amrit@health2.moph.go.th
2005-01-08 01:20 ` Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? Josh Berkus <josh@agliodbs.com>
2005-01-07 18:48   ` Steve Poe <spoe@sfnet.cc>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox