Re: opinion on disk speed

Поиск
Список
Период
Сортировка
От Jeremy Haile
Тема Re: opinion on disk speed
Дата
Msg-id 1134137725.8767.249418727@webmail.messagingengine.com
обсуждение исходный текст
Ответ на opinion on disk speed  (Vivek Khera <vivek@khera.org>)
Ответы Re: opinion on disk speed  (Frank Wiles <frank@wiles.org>)
Список pgsql-performance
> one other note, you probably don't want to use all the disks in a raid10
> array, you probably want to split a pair of them off into a seperate
> raid1  array and put your WAL on it.

Is a RAID 1 array of two disks sufficient for WAL?  What's a typical
setup for a high performance PostgreSQL installation?  RAID 1 for WAL
and RAID 10 for data?

I've read that splitting the WAL and data offers huge performance
benefits.  How much additional benefit is gained by moving indexes to
another RAID array?  Would you typically set the indexes RAID array up
as RAID 1 or 10?



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

Предыдущее
От: Kaloyan Iliev
Дата:
Сообщение: Query not using index
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: Query not using index