Re: Two identical systems, radically different performance - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Two identical systems, radically different performance
Date
Msg-id CAOR=d=0s7WZmb3AmQxYvKq6BKgszXA=avV3S-5b0dLe0KK5raw@mail.gmail.com
Whole thread Raw
In response to Re: Two identical systems, radically different performance  (Andrea Suisani <sickpig@opinioni.net>)
Responses Re: Two identical systems, radically different performance  (Andrea Suisani <sickpig@opinioni.net>)
List pgsql-performance
On Wed, Oct 17, 2012 at 9:45 AM, Andrea Suisani <sickpig@opinioni.net> wrote:
> On 10/15/2012 05:34 PM, Scott Marlowe wrote:
>> I'd recommend more synthetic benchmarks when trying to compare systems
>> like this.  bonnie++,
>
>
> you were right. bonnie++ (-f -n 0 -c 4) show that there's very little (if
> any)
> difference in terms of sequential input whether or not cache is enabled on
> the
> RAID1 (SAS 15K, sdb).

I'm mainly wanting to know the difference between the two systems, so
if you can run it on the old and new machine and compare that that's
the real test.

> I've run 2 bonnie++ test with both cache enabled and disabled and what I get
> (see attachments for more details) it's a 400MB/s sequential input (cache)
> vs
> 390MBs (nocache).
>
> I dunno why but I would have expected a higher delta (due to the 512MB
> cache)
> not a mere 10MB/s, but this is only based on my gut feeling.

Well the sequential throughput doesn't really rely on caching.  It's
the random writes that benefit from caching, and the other things
(random reads and seq read/write) that indirectly benefit because the
random writes are so much faster that they no longer get in the way.
So mostly compare random access between the old and new machines and
look for differences there.
>>  the memory stream test that Greg Smith was
>> working on, and so on.
>
>
> this one https://github.com/gregs1104/stream-scaling, right?

Yep.

> I've executed the test with HT enabled, HT disabled from the BIOS
> and HT disable using sys interface. Attached 3 graphs and related
> text files

Well it's pretty meh.  I'd like to see the older machine compared to
the newer one here tho.

> I'm trying... hard :)

You're doing great.  These problems take effort to sort out.


pgsql-performance by date:

Previous
From: Andrea Suisani
Date:
Subject: Re: Two identical systems, radically different performance
Next
From: Merlin Moncure
Date:
Subject: Re: LIKE op with B-Tree Index?