pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Reliability recommendations
Date: 15 Feb 2006 13:17:35 -0500
Message-ID: <878xsc4hc0.fsf@stark.xeocode.com> (raw)
In-Reply-To: <43F36D51.5090502@commandprompt.com>
References: <20060215090446.2F3AC1B819F@mx1.hub.org>
	<1140018387.43f34cd36a076@imp2-g19.free.fr>
	<1140018967.43f34f1761803@imp2-g19.free.fr>
	<1140020490.9369.254450363@webmail.messagingengine.com>
	<43F36D51.5090502@commandprompt.com>


"Joshua D. Drake" <jd@commandprompt.com> writes:

> Jeremy Haile wrote:
> > We are a small company looking to put together the most cost effective
> > solution for our production database environment.  Currently in
> > production Postgres 8.1 is running on this machine:
> >
> > Dell 2850
> > 2 x 3.0 Ghz Xeon 800Mhz FSB 2MB Cache
> > 4 GB DDR2 400 Mhz
> > 2 x 73 GB 10K SCSI RAID 1 (for xlog and OS)
> > 4 x 146 GB 10K SCSI RAID 10 (for postgres data)
> > Perc4ei controller

You don't say how this box is performing. There's no way to give
recommendations in a vacuum. Some users really need $50k boxes and others
(most) don't. This looks like a pretty good setup for Postgres and you would
have to be pushing things pretty hard to need much more.

That said some users have reported problems with Dell's raid controllers even
when the same brand's regular controllers worked well. That's what Joshua is
referring to.

> > The above is a standard Dell box with nothing added or modified beyond
> > the options available directly through Dell.
>
> You should probably review the archives for PostgreSQL user
> experience with Dell's before you purchase one.


-- 
greg




view thread (33+ messages)  latest in thread

Message-ID: <878xsc4hc0.fsf@stark.xeocode.com>
Permalink:  ../878xsc4hc0.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/878xsc4hc0.fsf@stark.xeocode.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsstark@mit.edu, jd@commandprompt.com, jhaile@fastmail.fm
  Subject: Re: Reliability recommendations
  In-Reply-To: <878xsc4hc0.fsf@stark.xeocode.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