From: Scott Marlowe <scott.marlowe@gmail.com>
To: Enrico Sirola <enrico.sirola@gmail.com>
Cc: Justin <justin@emproshunts.com>
Cc: Craig James <craig_james@emolecules.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: Mon, 17 Mar 2008 15:57:20 -0600
Message-ID: <dcc563d10803171457v11d0b607p2eb594a02284114c@mail.gmail.com> (raw)
In-Reply-To: <F582459A-C80F-40EE-B266-FC8C1131EFC7@gmail.com>
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
<47DCBBF9.1090401@emproshunts.com>
<F38ADB71-8F77-41C8-9066-488FFCA7BD67@fastcrypt.com>
<47DD6F4C.2050208@emolecules.com>
<47DEBD7C.2060204@emproshunts.com>
<B18EFFDB-D930-47AB-A0BF-2A4AAF1C4765@fastcrypt.com>
<47DEC2AD.8080602@emproshunts.com>
<47DEB978.2030307@emolecules.com>
<47DEC8AB.8060608@emproshunts.com>
<F582459A-C80F-40EE-B266-FC8C1131EFC7@gmail.com>
On Mon, Mar 17, 2008 at 2:58 PM, Enrico Sirola <enrico.sirola@gmail.com> wrote:
> Hi Justin,
>
> Il giorno 17/mar/08, alle ore 20:38, Justin ha scritto:
>
> > it is a RAID 10 controller with 6 SAS 10K 73 gig drives. The
> > server is 3 weeks old now.
> >
> > it has 16 gigs of RAM
> > 2 quad core Xenon 1.88 Ghz processors
> > 2 gig Ethernet cards. RAID controller perc 6/i with battery backup
> > 512meg cache, setup not lie about fsync
> >
> > WAL is on a RAID 0 drive along with the OS
>
> Did you try with a single raid 10 hosting DB + WAL? It gave me much
> better performances on similar hardware
> Bye,
Note that it can often be advantageous to have one big physical
partition on RAID-10 and to then break it into logical partitions for
the computer, so that you have a partition with just ext2 for the WAL
and since it has its own file system you usually get better
performance without having to actually hard partition out a separate
RAID-1 or RAID-10 for WAL.
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: scott.marlowe@gmail.com, enrico.sirola@gmail.com, justin@emproshunts.com, craig_james@emolecules.com, gsmith@gregsmith.com
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
In-Reply-To: <dcc563d10803171457v11d0b607p2eb594a02284114c@mail.gmail.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