From: Alex Turner <armtuk@gmail.com>
To: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: Miles Keaton <mileskeaton@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Date: Tue, 11 Jan 2005 09:34:15 -0500
Message-ID: <33c6269f0501110634707a8f4f@mail.gmail.com> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A75A2@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3412A75A2@Herge.rcsinc.local>
$4000 is not going to get you much disk - If you buy components from
the cheapest source I know (newegg.com) you end up around $5k with
14x36gig Raptor SATA drives and a 4U chasis with a 14xSATA built in
back plane packing 2x9500S AMCC Escalade RAID cards, which are
supported in Linux, 4Gig RAM and 2xOpteron 242. If you are not CPU
bound, there isn't much point going to 246. If you want SCSI, then
you will be paying more. Check out rackmountmart.com for Chasises,
they have a nice 5U that has a 24xSATA backplane (We will be acquiring
this in the next few weeks). If you really want to go nuts, they have
an 8U with 40xSATA backplane.
Alex Turner
NetEconomist
On Tue, 11 Jan 2005 08:33:09 -0500, Merlin Moncure
<merlin.moncure@rcsonline.com> wrote:
> > Subject: [PERFORM] which dual-CPU hardware/OS is fastest for
> PostgreSQL?
> >
> > I'm sorry if there's a URL out there answering this, but I couldn't
> find
> > it.
> >
> > For those of us that need the best performance possible out of a
> > dedicated dual-CPU PostgreSQL server, what is recommended?
> >
> > AMD64/Opteron or i386/Xeon?
> >
> > Linux or FreeBSD or _?_
> >
> > I'm assuming hardware RAID 10 on 15k SCSI drives is fastest disk
> > performance.
> >
> > Any hardware-comparison benchmarks out there showing the results for
> > different PostgreSQL setups?
>
> My recommendation would be:
> 2 way or 4 way Opteron depending on needs (looking on a price for 4-way?
> Go here: http://www.swt.com/qo3.html). Go no less than Opteron 246.
> Tyan motherboard
> Serial ATA controller by 3ware (their latest escalade series size for
> your needs) (if money is no object, go scsi). Make sure you pick up the
> bbu.
> Redhat Linux FC3 x86-64
> Good memory (DDR400 registered, at least)...lots of it.
>
> You can get a two way rackmount for under 4000$. You can get a 4-way
> for under 10k$. Make sure you pick up a rackmount case that has a
> serial ATA backplane that supports led status light for disk drives, and
> make sure you get the right riser, heh.
>
> Merlin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
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: armtuk@gmail.com, merlin.moncure@rcsonline.com, mileskeaton@gmail.com
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
In-Reply-To: <33c6269f0501110634707a8f4f@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