Re: Database Server Tuning

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Database Server Tuning
Дата
Msg-id 0BD83171-6C91-11D8-95B1-000A9578CFCC@kcilink.com
обсуждение исходный текст
Ответ на Re: Database Server Tuning  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Database Server Tuning  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Mar 2, 2004, at 4:27 PM, Josh Berkus wrote:

> Vivek,
>
>> I did a bunch of testing with different RAID levels on a 14 disk
>> array.  I finally settled on this:  RAID5 across 14 disks for the
>> data, the OS (including syslog directory) and WAL on a RAID1 pair on
>> the other channel of the same controller (I didn't want to spring for
>


> With large RAID, have you found that having WAL on a seperate array
> actually
> boosts performance?   The empirical tests we've seen so far don't seem
> to
> support this.

Yes, it was a noticeable improvement.


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Scaling further up
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: WAL Optimisation - configuration and usage