[lkml]   [2003]   [Dec]   [12]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
Messages in this thread
SubjectRe: more dbt-2 results hyperthreading on linux-2.6.0-test11
Hi Jun,

DBT-2 is a fair use implementation of the TPC-C (OLTP), if you're
familiar with that.

I have 14 drives attached through 1 megaraid raid controller, and 52
drives connected through 4 channels on 2 mylex raid controllers, all in
a raid-0 configuration. I am using LVM2 on both sets of drives.

iostat tells me that each of the 14 drives attached through the raid
controller are utilized < 2%, while each of the other 52 drives seem to
peak at about 48% in one of the hyperthreaded cases (274). I'm not too
familiar with the umpteen other columns that iostat reports, but that
suggests to me I have a fair amount of i/o headroom. Unfortunitely, I
don't believe I can get my hands on any addition drives or


On 12 Dec, Nakajima, Jun wrote:
> I'm not familiar with this particular workload, but noticed higher idle
> and wait time with HT enabled, compared to HT-disabled case. This kind
> of symptom often indicated insufficient I/O bandwidth from my
> experience, and faster systems (with more threads) tend to show lower
> throughput because you end up measuring disk seek time of more I/O
> requests. Can you add more disk controller(s) and disks?
> Jun
>> -----Original Message-----
>> From: [mailto:linux-kernel-
>>] On Behalf Of
>> Sent: Friday, December 12, 2003 2:28 PM
>> To:
>> Cc:;; pgsql-
>> Subject: more dbt-2 results hyperthreading on linux-2.6.0-test11
>> Hi Nick,
>> Here are the results of the comparisons I said I would do.
>> no-hyperthreading:
>> - metric 2288.43
>> - baseline
>> hyperthreading:
>> - metric 1944.42
>> - 15% throughput decrease
>> hyperthreading w/ Ingo's C1 patch:
>> - metric 1978.39
>> - 13.5% throughput decrease
>> hyperthreading w/ Nick's w26 patch:
>> - metric 1955.91
>> - 14.5% throughput decrease
>> It looks like there is some marginal benefit to your or Ingo's patches
>> with a workload like DBT-2. I probably don't understand enough about
>> hyperthreading, but I wonder if there's something PostgreSQL can do to
>> take advantage of hyperthreading
>> Anyway, each link has pointers to readprofile and annotated oprofile
>> assembly output (if you find that useful.) I haven't done enough
> tests
>> to have an idea of the error margin, but I wouldn't be surprised if
> it's
>> at least 1%.
>> Let me know if there's anything else you'd like me to try.
>> Thanks,
>> Mark

To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to
More majordomo info at
Please read the FAQ at

 \ /
  Last update: 2005-03-22 13:59    [W:0.044 / U:0.160 seconds]
©2003-2018 Jasper Spaans|hosted at Digital Ocean and TransIP|Read the blog|Advertise on this site