Re: Two identical systems, radically different performance

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Two identical systems, radically different performance
Дата
Msg-id CAOR=d=0s7WZmb3AmQxYvKq6BKgszXA=avV3S-5b0dLe0KK5raw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Two identical systems, radically different performance  (Andrea Suisani <sickpig@opinioni.net>)
Ответы Re: Two identical systems, radically different performance  (Andrea Suisani <sickpig@opinioni.net>)
Список 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 по дате отправления:

Предыдущее
От: Andrea Suisani
Дата:
Сообщение: Re: Two identical systems, radically different performance
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: LIKE op with B-Tree Index?