| 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: | Whole Thread | Raw Message | 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
| 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 ( |