From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-performance@postgresql.org
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Vivek Khera <khera@kcilink.com>
Subject: Re: dell versus hp
Date: Thu, 08 Nov 2007 14:31:04 -0600
Message-ID: <47331DA7.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <200711082114.36788.dfontaine@hi-media.com>
References: <82607932-FC46-4B73-BF78-2290EE55F7F5@pvv.ntnu.no>
<44B74F2E-29A6-4746-B8A8-E9355CC2F527@kcilink.com>
<dcc563d10711081022i9a8a64fg2fe00e6159027426@mail.gmail.com>
<200711082114.36788.dfontaine@hi-media.com>
>>> On Thu, Nov 8, 2007 at 2:14 PM, in message
<200711082114.36788.dfontaine@hi-media.com>, Dimitri Fontaine
<dfontaine@hi-media.com> wrote:
> The Dell 2900 5U machine has 10 spindles max, that would make 2 for the OS
> (raid1) and 8 for mixing WAL and data... not enough to benefit from the
> move,
> or still to test?
From our testing and various posts on the performance list, you can
expect a good battery backed caching RAID controller will probably
eliminate most of the performance difference between separate WAL
drives and leaving them on the same RAID array with the rest of the
database. See, for example:
http://archives.postgresql.org/pgsql-performance/2007-02/msg00026.php
Ben found a difference of "a few percent"; I remember seeing a post
from someone who did a lot of testing and found a difference of 1%.
As stated in the above referenced posting, it will depend on your
workload (and your hardware) so it is best if you can do some
realistic tests.
-Kevin
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: Kevin.Grittner@wicourts.gov, dfontaine@hi-media.com, scott.marlowe@gmail.com, khera@kcilink.com
Subject: Re: dell versus hp
In-Reply-To: <47331DA7.EE98.0025.0@wicourts.gov>
* 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