Re: Hardware/OS recommendations for large databases ( 5TB)

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Luke Lonergan" <LLonergan(at)greenplum(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware/OS recommendations for large databases ( 5TB)
Date: 2005-11-15 15:20:05
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD898@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Merlin,
>
> > > just FYI: tyan makes a 8 socket motherboard (up to 16 cores!):
> > > http://www.swt.com/vx50.html
> > >
> > > It can be loaded with up to 128 gb memory if all the sockets are
> > > filled :).
>
> Another thought - I priced out a maxed out machine with 16 cores and
> 128GB of RAM and 1.5TB of usable disk - $71,000.
>
> You could instead buy 8 machines that total 16 cores, 128GB RAM and
28TB
> of disk for $48,000, and it would be 16 times faster in scan rate,
which
> is the most important factor for large databases. The size would be
16
> rack units instead of 5, and you'd have to add a GigE switch for
$1500.

It's hard to say what would be better. My gut says the 5u box would be
a lot better at handling high cpu/high concurrency problems...like your
typical business erp backend. This is pure speculation of course...I'll
defer to the experts here.

Merlin

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Weisberg 2005-11-15 15:40:53 Re: Hardware/OS recommendations for large databases ( 5TB)
Previous Message Michael Stone 2005-11-15 14:55:45 Re: Hardware/OS recommendations for large databases (