Re: hardware upgrade, performance degrade? - Mailing list pgsql-performance

From John Rouillard
Subject Re: hardware upgrade, performance degrade?
Date
Msg-id 20130304231717.GD7039@renesys.com
Whole thread Raw
In response to Re: hardware upgrade, performance degrade?  (Steven Crandell <steven.crandell@gmail.com>)
Responses Re: hardware upgrade, performance degrade?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: hardware upgrade, performance degrade?  (Steven Crandell <steven.crandell@gmail.com>)
List pgsql-performance
On Mon, Mar 04, 2013 at 03:54:40PM -0700, Steven Crandell wrote:
> Here's our hardware break down.
>
> The logvg on the new hardware  is 30MB/s slower (170 MB/s vs 200 MB/s )
> than the logvg on the older hardware which was an immediately interesting
> difference but we have yet to be able to create a test scenario that
> successfully implicates this slower log speed in our problems. That is
> something we are actively working on.
>
>
> Old server hardware:
>         Manufacturer: Dell Inc.
>         Product Name: PowerEdge R810
>         4x Intel(R) Xeon(R) CPU           E7540  @ 2.00GHz
>         32x16384 MB 1066 MHz DDR3
>         Controller 0: PERC H700 - 2 disk RAID-1 278.88 GB rootvg
>         Controller 1: PERC H800 - 18 disk RAID-6 2,178.00 GB datavg, 4
> drive RAID-10 272.25 GB logvg, 2 hot spare
>         2x 278.88 GB 15K SAS on controller 0
>         24x 136.13 GB 15K SAS on controller 1
>
> New server hardware:
>        Manufacturer: Dell Inc.
>         Product Name: PowerEdge R820
>         4x Intel(R) Xeon(R) CPU E5-4620 0 @ 2.20GHz
>         32x32 GB 1333 MHz DDR3
>         Controller 0: PERC H710P  - 4 disk RAID-6 557.75 GB rootvg
>         Controller 1: PERC H810    - 20 disk RAID-60 4,462.00 GB datavg, 2
> disk RAID-1  278.88 GB logvg, 2 hot spare
>         28x278.88 GB 15K SAS drives total.

Hmm, you went from a striped (raid 1/0) log volume on the old hardware
to a non-striped (raid 1) volume on the new hardware. That could
explain the speed drop. Are the disks the same speed for the two
systems?

--
                -- rouilj

John Rouillard       System Administrator
Renesys Corporation  603-244-9084 (cell)  603-643-9300 x 111


pgsql-performance by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: hardware upgrade, performance degrade?
Next
From: Scott Marlowe
Date:
Subject: Re: hardware upgrade, performance degrade?