From: | Mark F <enigma_3319(at)hotmail(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hardware for PostgreSQL (RAID configurations) |
Date: | 2007-11-02 21:23:53 |
Message-ID: | BAY101-W166BC063A82D96974BFB53918D0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
From: enigma_3319(at)hotmail(dot)com
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM]
Date: Fri, 2 Nov 2007 15:03:12 -0500
In an 8 disk configuration where 2 are used for OS; 2 for xlog, and 4 for the database.. is this possible given Dell's possible configurations only allow 2 different RAID setups (SAS Raid1/Raid5)? I will also be contacting Dell, but does this require a more advanced RAID controller that supports 3 disk clusters (Raid 1 with 2 disks, Raid 1 with 2 disks, Raid 5 with 4 disks)? If I'm only allowed a 2:6 disk setup, where do you recommened placing the Xlogs; on the OS disks or on the databasae disks?
- Mark
On 11/1/07, Mark Floyd <mfloyd(at)evryx(dot)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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Peek-a-boo FREE Tricks & Treats for You! Get 'em!
_________________________________________________________________
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Larsen | 2007-11-03 20:22:18 | Union within View vs.Union of Views |
Previous Message | Mark F | 2007-11-02 20:03:12 |