"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