Re: Hardware suggestions for high performance 8.3

От: Henrik
Тема: Re: Hardware suggestions for high performance 8.3
Дата: ,
Msg-id: 132B78B6-137B-48AA-B467-1108FA1F4BC3@mac.se
(см: обсуждение, исходный текст)
Ответ на: Re: Hardware suggestions for high performance 8.3  ("Claus Guttesen")
Список: pgsql-performance

Скрыть дерево обсуждения

Hardware suggestions for high performance 8.3  (Henrik, )
 Re: Hardware suggestions for high performance 8.3  ("Claus Guttesen", )
  Re: Hardware suggestions for high performance 8.3  (Henrik, )
 Re: Hardware suggestions for high performance 8.3  (Matthew Wakeling, )
  Re: Hardware suggestions for high performance 8.3  (Henrik, )
   Re: Hardware suggestions for high performance 8.3  ("Claus Guttesen", )
   Re: Hardware suggestions for high performance 8.3  (Matthew Wakeling, )
   Re: Hardware suggestions for high performance 8.3  (Greg Smith, )
    Re: Hardware suggestions for high performance 8.3  (Henrik, )
    Re: Hardware suggestions for high performance 8.3  (Henrik, )
     Re: Hardware suggestions for high performance 8.3  (Greg Smith, )
      Re: Hardware suggestions for high performance 8.3  ("Scott Marlowe", )
      Re: Hardware suggestions for high performance 8.3  ("Joshua D. Drake", )
 Re: Hardware suggestions for high performance 8.3  (Greg Smith, )

25 jun 2008 kl. 12.56 skrev Claus Guttesen:

>> We have a database with lots of small simultaneous writes and reads
>> (millions every day) and are looking at buying a good hardware for
>> this.
>>
>> What are your suggestions. What we are currently looking at is.
>>
>> Dual Quad Core Intel
>> 8 - 12 GB RAM
>>
>> 10 disks total.
>>
>> 4 x 146 GB SAS disk in RAID 1+0 for database
>> 6 x 750 GB SATA disks in RAID 1+0 or RAID 5 for OS and transactions
>> logs.
>>
>> Good RAID controller with lots of memory and BBU.
>
> I have very positive experiences with HP's DL360 and DL380. The latter
> slightly more expandable (2U vs. 1U). I have used the internal
> p400i-controller with 512 MB cache on the DL380 and bought an external
> p800-controller (512 MB cache as well) and a MSA-70-cabinet. I've have
> 11 disks in raid-6 (one hotspare).
Mmm I've used DL380 and I also have had good experience with them.

I guess that the nees of splitting up the transactions logs are not
that important if you have enought disks in a raid 10 or raid 6.
>

> My personal preference is FreeBSD and the DL3x0-servers all run
> without problems on this platform. But choose your OS depending on
> what you're most comfortable with. And choose hardware according to
> what your OS supports.
>
I like BDS also but this time its a 64bit Linux system which wil be
used.
>
>
> Our largest table has 85 mill. entries.
>
I believe we will be running in the 200 mill. area.

Thanks for your input!

//Henke


В списке pgsql-performance по дате сообщения:

От: "Kevin Grittner"
Дата:
Сообщение: Re: Hardware vs Software RAID
От: Andrew Sullivan
Дата:
Сообщение: Re: Hardware vs Software RAID