From: Scott Marlowe <scott.marlowe@gmail.com>
To: Mark Floyd <mfloyd@evryx.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: hardware for PostgreSQL
Date: Thu, 1 Nov 2007 22:31:03 -0500
Message-ID: <dcc563d10711012031m156e9914sd9129cc4305005c@mail.gmail.com> (raw)
In-Reply-To: <3B6F8084-0BD0-48C3-A6DB-C393FB4E5EFE@evryx.com>
References: <3B6F8084-0BD0-48C3-A6DB-C393FB4E5EFE@evryx.com>
On 11/1/07, Mark Floyd <mfloyd@evryx.com> wrote:
> Hello,
> Dell PowerEdge Energy 2950
> (2) Quad Core Intel Xeon L5320, 2x4MB Cache, 1.86Ghz, 1066Mhz FSB
> 4GB 667Mhz Dual Ranked DIMMs, Energy Smart
>
> PERC 5/i, x8 Backplane, Integrated Controller Card
>
> Hard Drive Configuration: Integrated SAS/SATA RAID1/Raid 5
>
> Hard Drive 1 (For Operating System): 36GB 10K RPM SAS 3Gbps 2.5-in
> Hot Plug HD
> Hard Drive 2 (For logs): 36GB 10K RPM SAS 3Gbps 2.5-in Hot Plug HD
>
> Hard Drives 3,4,5,6 (In a RAID 5 Configuration): (4) 146GB 10K SAS
> 3Gbps Hard Drive, 2-5 inch, Hot Plug
If you can fit 8 drives in it, for the love of god add two more and
mirror your OS and xlog drives ( I assume that's what you mean by
drive 2 for logs). Running a server on non-redundant drives is not
the best way to do things.
And if you can live on ~ 300 Gigs of storage instead of 450 Gigs, look
into RAID-10 for your data array. RAID 10 is noticeably faster than
RAID-5 for any database that sees a fair bit of writing activity.
> It's overkill for our initial system but we are shooting for a system
> that allows for growth. If someone can let us know if we're on the
> right path or are shooting ourselves in the foot with this setup I'd
> appreciate it.
Other than the 8 cores, it's not really overkill. And depending on
your usage patterns 8 cores may well not be overkill too.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, mfloyd@evryx.com
Subject: Re: hardware for PostgreSQL
In-Reply-To: <dcc563d10711012031m156e9914sd9129cc4305005c@mail.gmail.com>
References: <3B6F8084-0BD0-48C3-A6DB-C393FB4E5EFE@evryx.com> <dcc563d10711012031m156e9914sd9129cc4305005c@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