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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Hardware/OS recommendations for large databases ( 5TB)
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD898@Herge.rcsinc.local
обсуждение исходный текст
Ответы Re: Hardware/OS recommendations for large databases (  ("Luke Lonergan" <llonergan@greenplum.com>)
Re: Hardware/OS recommendations for large databases ( 5TB)  (William Yu <wyu@talisys.com>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: Hardware/OS recommendations for large databases (
Следующее
От: "Adam Weisberg"
Дата:
Сообщение: Re: Hardware/OS recommendations for large databases ( 5TB)