Re: questions about disk configurations

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: questions about disk configurations
Дата
Msg-id 1039562015.27243.304.camel@haggis
обсуждение исходный текст
Ответ на Re: questions about disk configurations  (Hubert depesz Lubaczewski <depesz@depesz.pl>)
Ответы Which of the solution is better?
Список pgsql-performance
On Tue, 2002-12-10 at 15:16, Hubert depesz Lubaczewski wrote:
[snip]
> anyway: what i understood is that usually the best (performance-wise),
> would be to put:
> xlog - separate - unraid'ed disk, or raid0

Unless your data is *easily* recreatable, NEVER RAID0!!

> tables - any raid, but not raid 1
> indices - any raid, but not raid 1

Why not RAID1 (mirroring)?  It speeds up both reads and writes.

Things are also dependent on the RAID controller, since they
all have different strengths and weaknesses.

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA      http://members.cox.net/ron.l.johnson  |
|                                                               |
| "My advice to you is to get married: If you find a good wife, |
| you will be happy; if not, you will become a philosopher."    |
|    Socrates                                                   |
+---------------------------------------------------------------+


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

Предыдущее
От: Hubert depesz Lubaczewski
Дата:
Сообщение: Re: questions about disk configurations
Следующее
От: Wei Weng
Дата:
Сообщение: Which of the solution is better?