Re: Hardware suggestions for high performance 8.3

От: Matthew Wakeling
Тема: Re: Hardware suggestions for high performance 8.3
Дата: ,
Msg-id: Pine.LNX.4.64.0806251341320.4085@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: Hardware suggestions for high performance 8.3  (Henrik)
Список: 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, )

On Wed, 25 Jun 2008, Henrik wrote:
> Would you turn off fsync if you had a controller with BBU? =)

No, certainly not. Fsync is what makes the data move from the volatile OS
cache to the non-volatile disc system. It'll just be a lot quicker on a
controller with a BBU cache, because it won't need to actually wait for
the discs. But you still need the fsync to move the data from main OS
cache to BBU cache.

>> Also, do you really need 6*750GB for OS and transaction logs? How big can
>> they be?
>
> Ahh, we are going to save a lot of other datafiles on those also but maybe
> i'll just get a cabinett.

Or you could just get 10 large SATA drives. To be honest, the performance
difference is not large, especially if you ensure the database data is
held compactly on the discs, so the seeks are small.

Matthew

--
It's one of those irregular verbs - "I have an independent mind," "You are
an eccentric," "He is round the twist."
                                      -- Bernard Woolly, Yes Prime Minister


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

От: Andrew Sullivan
Дата:
Сообщение: Re: Hardware vs Software RAID
От: Greg Smith
Дата:
Сообщение: Re: Hardware vs Software RAID