Re: Pg+Linux swap use

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: William Yu <wyu(at)talisys(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Pg+Linux swap use
Date: 2003-11-06 22:58:52
Message-ID: 200311062258.hA6Mwq504482@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark wrote:
>
> William Yu <wyu(at)talisys(dot)com> writes:
>
> > Rob Sell wrote:
> >
> > > Not being one to hijack threads, but I haven't heard of this performance hit
> > > when using HT, I have what should all rights be a pretty fast server, dual
> > > 2.4 Xeons with HT 205gb raid 5 array, 1 gig of memory. And it is only 50% as
> > > fast as my old server which was a dual AMD MP 1400's with a 45gb raid 5
> > > array and 1gb of ram.
> >
> > Not to get into a big Intel vs AMD argument but 50% sounds about right. Let's
> > first assume that the QS rating for the MP1400 is relatively accurate and
> > convert that to a 1.4GHz Xeon. 2.4/1.4 = +71%. Since processor performance
> > does not increase linearly with clockspeed, 50% is in line with expectations.
>
> Hm. You've read "50% as fast" as "50% faster".
> I wonder which the original poster intended.

Hyper-threading makes 2 cpus be 4 cpu's, but the 4 cpu's are each only
70% as fast, so HT is taking 2x cpus and making it 4x0.70 cpu's, which
gives 2.80 cpu's, and you get that only if you are hammering all four
cpu's with a full load. Imagine ifd get two cpu-bound processes on the
first die (first 2 cpu's of 4) and the other CPU die is idle, and you
can see that HT isn't all that useful unless you are sure to keep all 4
cpu's busy.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message radha.manohar 2003-11-09 15:06:14 Re: error while executing a c program with embedded sql
Previous Message Hannu Krosing 2003-11-06 19:54:13 Re: Interbase/Firebird - any users out there - what's