pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: 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