pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brian Wipf <brian@clickspace.com>
To: pgsql-performance@postgresql.org
Subject: Configuring System for Speed
Date: Fri, 8 Sep 2006 01:52:28 -0600
Message-ID: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com> (raw)

I am in the process of speccing out a new box for a highly utilized  
(updates, inserts, selects) 40GB+ database. I'm trying to maximize  
performance on a budget, and I would appreciate any feedback on any  
of the following.

Hardware:
2 - Intel Xeon 5160 3.0 GHz 4MB 1333MHz
8 - Kingston 4GB DDR2 ECC Fully Buffered
16 - WD Raptor 150GB 10000 RPM SATA II HD
1 - 3Ware 9550SX-16ML Serial ATA II RAID card
1 - Supermicro X7DBE+ Motherboard
1 - Supermicro SC836TQ-R800V Case

The Woodcrest CPU, Raptor HD and 3Ware 9550SX RAID card have all been  
highly recommended on this list, so there may not be much to comment  
on there. The Supermicro X7DBE+ motherboard is appealing because of  
its 16 RAM slots and 64GB of maximum memory. The Supermicro  SC836TQ- 
R800 case was selected because of its 16 drive bays in 3U and dual  
800W power supplies (the motherboard requires 700W).

RAID Configuration/File System:
A lot of info in the lists, but I'm not sure of the best approach for  
this setup.
I was thinking of using 14 drives in a RAID 10 (ext3) for the db and  
wals and 2 mirrored drives (ext3 or xfs) for the OS. Another option  
would be 12 drives in a RAID 10 for the database (ext3, maybe ext2)  
and 4 drives in a RAID 10 for the OS and wals (ext3) (with separate  
RAID cards). There are many choices here. Any suggestions?

OS:
The consensus in the list seems to be as long as you have the 2.6  
Linux Kernel, it's really a matter of personal preference. However,  
it's hard to have a preference when you're new to the Linux world,  
like I am. Red Hat, Fedora Core, Slackware, Suse, Gentoo? I guess my  
primary goal is speed, stability, and ease of use. Any advice here,  
no matter how minimal, would be appreciated.

Thanks,

Brian Wipf




view thread (6+ messages)  latest in thread

Message-ID: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com>
Permalink:  ../8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com/
Also on:    postgresql.org/message-id/8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com

 · 

reply

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: brian@clickspace.com
  Subject: Re: Configuring System for Speed
  In-Reply-To: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.com>
  References: <8FE8AE4A-43AD-4AE5-82B7-6C77BC4A0248@clickspace.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