From: John Rouillard <rouilj@renesys.com>
To: pgsql-performance@postgresql.org
Subject: Re: hardware upgrade, performance degrade?
Date: Mon, 4 Mar 2013 23:17:17 +0000
Message-ID: <20130304231717.GD7039@renesys.com> (raw)
In-Reply-To: <CALvesgmVwmKoa==dZVKj9ww_8jxUbbqcbQFdi0W8cRKWwM0RYw@mail.gmail.com>
References: <CALvesgn0Urm0Mj5HD-tM_-0Vw=4A-_O98Q+cxJ7NNXf7me+vcg@mail.gmail.com>
<CAFwQ8rc+POTz7USK0siefnSwC5R_ZMX4yhtmiWPjKZttedG9Zw@mail.gmail.com>
<CALvesgnv9AGR5Vo2BRqA62-PWB_63mvg7P5K6LGeoHhXh+fMiQ@mail.gmail.com>
<5133AF87.9040704@agliodbs.com>
<5133B3ED.7000906@verizon.net>
<CALvesgmVwmKoa==dZVKj9ww_8jxUbbqcbQFdi0W8cRKWwM0RYw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rouilj@renesys.com
Subject: Re: hardware upgrade, performance degrade?
In-Reply-To: <20130304231717.GD7039@renesys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox